Bellow is my query. It gives me the result it is supposed to give me which is
each customer has 7 records because I have 7 months in the system. But when I
count months for each customer, it gives me 49 instead of 7. Why could this
happen?

need help to fix the SQL querry.
this querry shows perticular inventory of a specified month and year.
the result it shows is also correct. but the problem is it subtacts
purchases made in the specified month (example: July) from Sales Made

I am using Office 2003 on Windows XP.
I am trying to run a make table query against an Oracle DB into Access.
The following line is causing the problem:
A.FUND BETWEEN '801' AND '999'

I have a db that I make several data manipulations on (delete, insert,
updates, etc). The database is large ( > 1GB) and I constantly make updates
to tables that contain over a million rows. I have modified the
maxlocksperfile setting to 200,000 but I still get errors. I read ...

We have a table that saves meter readings and dates.  We need to calculate
latest useage ([latest reading] MINUS [second latest]).   Dmax function will
return the latest reading, but how can I capture the second latest to use in
the calculation?)  

I have a query that Ken Snell helped me with.  It detects missing dates in
my employee timesheet db.  My query has a field of [D] form tbl "Q", a field
of [FirstDay] where a date was entered indicating the employees first day of
work for the season, and [LastDay] for the date the ...

Is there a way (running a query, macro etc) to combine all data from one
field (different records) into one different field.
Example we have 500 records.  Each has a account number in the "Facility ID
Number" Field. I want to take those 500 account numbers and update a

I have a saved query object with a replace function embedded in it (update xx
set xx=replace(xx,'|','EOR').  This query works in several different Windows
environments except one.  I have checked references in a test database and
they are all there.  I cannot check the references ...

I am using Office 2003 on Windows XP.
I am using ADO combined with JET. Is this the most current provider to use?
Microsoft.Jet.OLEDB.4.0
Could someone please confirm? Thanks much in advance.

I have a report that shows impression reads for two consequetive months.  I
am looking for a way to alter my query to allow me to see all devices that
did not have a value for either the previous month or the current month.  
For example, device A could have an impression for this ...

I have a field called categories.
In this field there are 8 categories.
Some records have more than one catergory.
Is there any way I can use a combo box to be able to choose more than one

So after reading documenation and Usenet help replies this morning I
have concluded that the IIf function in Access is not going to help
with my current situation. If I understand correctly, IIf is only used
when and only when there is a field that could be null. For instance,

I am working on a web application for a company that uses an existing
company database. I just found out before the long weekend that a
couple hundred of the items in the table aren't completely related.
I am mostly using 2 tables for the project: ItemVersion, ItemVersionRev

I have a dilemma with a multi-level BOM which has plagued me for months.  I
use linked tables which are in a data warehouse which I have no control over
so the tables/fields cannot change.  The table I'm using has the following
fields:

I'm looking for some advice please.  I have an orders table and a inventory
table - one to many.  When the items in the inventory table are received and
used, I flag a field (closed) yes.  What I would like to do is check the
inventory table per order number and when all items ...