I have a table like:
MI1    MI2    QTY
1007    1005    2
***

I have data that is in this format:
ID    Client           Date
01    Jon             4/20/2006
02    Kim            4/20/2006

I have a table as below:
Province    NGO Name    Score
Province 1    XXX            34
Province 1    DDD            39

I have a query that runs great, until I use the where clause (WHERE
((([pickpro]-[sumofqty])<>0));).  When I add this it pops up the input box
for “Pickpro”.  
Here are the fields in play and below is all of the SQL.  

I have a table that consists of 20 fields.  The fields are populated by
a form.  The information feeds a report that looks simular to an
invoice.  (ex. feild 1 - 1 box  field 2 - expansion anchors)  I am
attempting to group the information into 2 fields so that I am able to

I put the follwoing expression in my Update to field:
IIf(Nz([dbo_tblProductversion].[Attachments],0)=-1,"Y","N")=[DEV_dbo_TblProduct].[Attachments].
I also have a ProductID field that is a number field from a seprate table.
When I add the following "<>[tblProduct].[productid]" ...

Database
I am designing a database which basically consists of a set of questions
that are fixed
And answer that will change for each client.

I am trying to do a make table query to retrieve all the records in a certain
category where the field is named Category.  I am choosing Make Table from
the query type drop down list.  When the make table dialog box comes up, it
gives me the option to put the table in the current ...

The following is my SQL from my crosstab query:
TRANSFORM Count(INTERVAL.NEXT_INSPECTION_DATE) AS [The Value]
SELECT INSPECTIONTYPEGROUP.INSPECTIONTYPEGROUP_DESC,
UNITNAME.UNITNAME_DESC, Count(INTERVAL.NEXT_INSPECTION_DATE) AS [Total Of

I have a table that intentionally has duplicate [Fund Name] records,
but with different dates. There is also a [Yes/No] checkbox field.
Sample below:
Table: [Duplicate Funds]

if i have a date/time column, and i wanted to pull out all in the field that
contains 12:00 am, how would i set up that query?

Would any body be able to help me im trying to do a simple command in access
with a query. I have a list of faults that have occured in our building with
our computers. They are labled either open if it has not been fixed or close
if they have. There is only 180 records in the ...

I import a list of records and wish to tally the number of occurrences for
each imported name...I believe there is a way to collapse all of the
duplicate entries and tally them.
In other words I import a large number of items and wish to see a breakout

I have yet another Insert Into statement error which might be
relatively easy to solve. Here's the problem:
I have a working VBA module which includes various SQL Insert Into
statments. Our system has a limit of taking in only 5 PRODUCT codes and

I have 27 separate databases which I want to sonsolidate the same table into
one big table in a the consolidation database.
I created a consolidation database with the same table design with no data
and linked all 27 tables coming from these 27 databases.