In Access table, if I retrieve a variable and apply filter, then the sorted
variable will be displayed. On the other hand, if I set a equation by
combining different variables together for calculation, the value of the
equation can also be displayed, but if I apply filter into ...

Here is my query
SELECT [Staff Count].Location, Submitted, [Staff Count] FROM [Staff Count]
LEFT JOIN Submitted ON [Staff Count].[Location] = [Submitted].[Location]
I have another query called Active (field I need is Active) and Resolved

i try to build a query with date
in my table i have 2006-03-29 (yyyy-mm-dd)
i tried
select * from test3

Help!
I just don’t understand why I can’t get this SQL to work the way I would
like it.
I got 2 tables I’m working with.

I am working on an inherited Access 2000 database for sale and purchase of
items.  Right now it is setup with a sales table and a purchases table, each
with the quantity and cost of the item (either sold or purchased).
I need to create a report of all the inventory items with a ...

The query field below creates an error: "The expression is typed incorrectly,
or is to complex to be evaluated".  The date comparision is killing me.  I
can't seem to get it to work.  The ExpDateFormatter is a field that formats a
field into mm/dd/yyyy from yyyymmdd and the point ...

My desktop can perform the function 'Format([Number],"000")' in a query but
my laptop can't.  Both are running Office 2003 SP2 with full Windows and
Office updates uploaded.  How can I fix this?

I have a query that was working fine but like some of us we just cant stop
playing and then mess it all up.... yeah thats what I did...
Anyway... really simple one this... so simple I cant do it again...
I have a query with a orderdate, and in the criteria it has the code:

I am tyring to create a CrossTabb Query that is
fed by a regular query.
My regular query has a field with a criteria of
"Forms![frmMainMenu]![DefaultYear]"

I have three separate tables in the accounting department:
Account codes, Locations, Program codes.
I want to create (I guess through using a query) an output of all potential
combinations among three tables.

We pick up items from customers. We pay them every three months for the
customers only the accumulated amount reaches a certain number and their
account becomes "0", for the rest the amount will carry over for next quarter.
How do I handle this situation?

As always, much thanks in advance!!!
I have a table that lists payments from clients.  One column of that table
lists visits numbers and diagnosis that are connected to that clients.  For
example, one client (#12345) might have two visits (1 and 2) and have two

can I set up a select query to prompt the user to ask for the name o
the field to filter?  Each month in my table has it's own field and
want the user to specify which month to run the "Is Not Null" filte
on.  Otherwise I'll have to have 12 queries..

  I have been trying everything.  What I want to do is run a query on one
table that counts the unique occurances of Emp #.  also, I want to group by
month, week, or day.  I pasted in some code that I found...however it is not
working.  Please help with some basic code that will ...

I would like to know if there is a way of running a query on databases
located on physically different computers (AS/400) without having to first
re-link the databases everytime you want to run the query on a different
machine.  My Access query queries the exact same table names ...