I'm a entry-level Access user and I'm working with a DB that someone else
created which (as far as I can tell) uses an Append Query to bring data from
an Excel spreadsheet into a table.  
The problem I am having is that it does not bring all of the data.  In the

I have a field "SumOfQty" in a query that I want to use an IIF statment in
the criteria: If [Forms]![Zero Qty]![Checkbox] is checked then "SumOfQty"
criteria is 0.
else >0.  The 0 works, but it won't see the >0.  What would be the solution

I have confusing question.
I have 5 fields, how would I go about running a query or 3 of the fields,
but show all 5 in the result?  I want to query the distinct values of only
selected fields, but show all of the fields in the results.

Thanks for all your help guys, this dcount has me stumped. Here is
another query I am having trouble with.
Here is the SQL, this works great:
=SELECT Count(IIf(Current Like "714*",1,Null))/Count(IIf(Current Not

Hey all.  I am going to post this quick and hopefully get a response back
soon.  Any help is appreciated.
IIF([forms]![frm_report_dates]![cbo_source]="Domestic",1,IIf(Len([forms]![frm_report_dates]![cbo_source])>0,2,IIf([forms]![frm_report_dates]![cbo_error_source]=1,1 ...

This SQL shows me records that have duplicates (>1)
It only shows one ICNNo and a NUMBER of how many >1
I need to show the data for both records so I know which to delete..
Suggeations?

Hi, iam trying to run an update query. the situation is as follows, i
have linked excel sheets in my table. so i am using the update query
to update all the records that i have them in my access tables. i
tried this before many times and i was successful in doing that. But

I got a table over some companies where one of the colums is the number of
employees in the company, atm that field is a text field, co employee number
can be listed as "5-9" or "10-19" or an exact number.
I would like to changes the the colume so in the fields you will se the

Please how can I copy or insert the filename (workbook) without the .xls
extension in the first column of the access table and the worksheet name
(worksheet tab) in the second column of an access table?
Please I am working on a cost accounting document of

I have a query set up to pull all employee weekly time records charged to a
certain category.  I want to summarize the total hours charged to that
category (which I can do), but I also want to display the date of the last
week that they charged to that category.

I have two identical tables.  Information is input into each table by two
seperate sources.  I would like to have a query that compares the fields in
each table and list those records with any field that does not match.  The
code below does not work, but I am trying to get ...

how are you?

I have the following code that exports the below query to excell. I would
like the files name to include the month and date. How would I format this?
DoCmd.OutputTo acOutputQuery, "qryShopOrderSqFtShippedSummaryExport",_
acFormatXLS, "W:\Cokato\Production\ProdRoomRpt.xls"

I have a lot to learn about queries and hope that the experts can help
me.  I need a column providing a running balance taking in account the
following criteria: INV (on hand) - O_QTY (Order Qty) + S_QTY (Supply
Qty) for each SKU#.  Something like:

I'm not sure whether this is the right group. If not please point me to
the right one.
I have a database containing a table for each month and each table
contains information on the articles in the stock. I would now like to