I don't know if I'm drawing a blank and missing something easy and obvious,
but what I'd like to to is take my table that has 2 date columns and build a
query that rolls through the dates, seaching for any 7 day block that meets a
certain condition.  I just can't figure out how ...

I am new to vb and MS access and database programming. I am doing a project
for Distributor Invoice system. I have problems as mentioned below.
I have 2 tables named "tblInvoice_BillDetails" and "tblInvoice_GoodsDetails".
To save memory I am using the above 2 tables in one form.

I have a query that is pulling data from one talbe.  If there are
duplicateds, which there are, How can I combine them?  Same customer number,
same name, same revenue code and same service branch-I want to combine
records that share this data or that have identical data

I want a drop down box of valid values on my parameter query.  Per online
examples, I created a form, which allows me to see a drop down box of valid
values and to click on one of the values.
The form works.  It opens with (choose one) in the drop down box.  Clicking

This is my second post for this - thank you
Each month I create a new table using the SQL below, where the records are
just copied from the GoalsMain table, except that the NewDate changes each
month. This works great unless I've added a new record in the

Hi - I want to run an update a memo field using an update query.  not sure
why it will not let me update the field when there is more than 127
characters. it comes up with the error message invalid argument.  can anyone
provide some guidance.  i kinda wanted to avoid using VBA, ...

Would performance be better if I queried a linked table or if I used a
pass-through query? and why?  or would it matter at all?

I have a field in a database that contains several different possible values:
ad, am, rp, etc.  It is possible to have a combination of values, such as
ad/rp, etc.
Can I use a criteria selection to select only those records where the

Table has a field named [Time] in second (Number DataType)
I want to format seconds into "HH:mm:ss".
What is wrong with following expression?
[Time]\3600 & ":" & ([Time] Mod 3600)\60 & ":" (([Time] Mod 3600) Mod 60)

It's been a while since I have used Access.  
I am trying to run a query so that I can use it for a report.  I need to
show dates for four different categories that are within a certain time frame
for each customer name.  Each customer can have up to four dates displayed

I have 121 records in a Table called survey.  When I run a Query, only 118
records display.  What am I doing wrong?  I have no filters applied.

I have a number of Edit Queries that I execute as part of an automated
process.  I only want to display to the user the Edit queries that have
results.  I have done this in the past but cannot find the code I used to not
display queries that had no results.  Can someone please ...

Trying to do a query with only records showing between certain dates in
descending order.  Not sure where I'm going wrong.  Have tried several codes
but for some reason, I can't get it to work.  Either I get an error code or I
get a pop-box asking for dates.  Can someone tell me ...

I am using Access 2002 and I have a query that I would like to count a
particular field, the problem is that my table has 500 records and I know
that there are 100 records that are "yes" , but I get the whole 500 records
in the count. How do I count the Yes only?  Thank you in ...

I need to compare three numeric fields and pick the greater of the three; I
will then have to use that number in subsequent calculations.
Any help with this will be greatly appreciated.
Thanks.