This is a complex query that shows debt agings for all our customers from
CURRENT, 1-30, 31-60, 61-90, 91-181, 181-360, 360+ days. I have 2 tables
joined, ARDetail and Custusage these have specific fields from the text
files. I used IIF to do the calculations for each of these ...

I have data stored with Date and TIME, but want to group by Calendar Date.  
Which fuction do I use in the calculated field?  (since the query wants to
group by Time separately).
Thanks, SKB

I am trying to join a table and a query.  The qryJulysales gives manager,
acct, itemrange, sales, disconinv.  The table has acct, item range,
discoffinv.  This is what I need to accomplish:
Manager, acct, itemrange, sales, disconinv, discoffinv, totaldiscount

Hello~
I am trying to create a form that would allow the user to select the fields
they would like in a query and then to execute the query.  The number and
type of fields could be different each time executed.  I was thinking that

I have 2 stored Crosstab queries which are basically the same in structure
but which pull data from different sources:
qryXtab_tblTemp:
TRANSFORM Last(tblTemp.Freq) AS LastOfFreq

How can I attach a macro to a action querie so i can create a button that
will run the action querie?

I have been given a solution to an earlier post that I understand but can't
get to work.
Is the Select * From function used in Query Criteria box or elsewhere? I'm
dying to find out!

How do I write expression eg 1 of 3 where 1 is field [count of rejects] and
3 is field [count of tested] in excel I would use concatenate but I don't
know how to do in access
TIA

I have a data base which I have inherited and Im trying to sort ...
In my data base I have an employee number which is unique to the individual,
however over time this has been 'overlooked' and now Im using a data base I
would hope to have this as the Primary key ...

I am trying to get the column order in the Design View of a query to match
the order in the Datasheet View.  I know how to move columns in each view but
if you move them in Datasheet View, how do you get them synchronized back to
the order in the Design View?  Normally, I would ...

I am working on a project and there is an existng table which includes a
FirstName and a LastName field. I am trying to design a query to include the
data from both these fields in one column with a space in between them and a
different heading when the query is run.

I have an Orders table that has  a Freight field, a ShipCity field, OrderId
field, and CustomerID. I want to  create a query that displays  Order ID and
CustomerID with the minimum freight cost for orders sent to each city.
Please, use accessquery design grid.

This is from famous "Northwind" DB example.
Suppose you have an Orders table that has both a Freight field and a
ShipCity field. You can create a query that displays the minimum freight cost
for orders sent to each city and it's Order ID and CustomerID.

We've just converted our Access 2000 databases to Access 2003. A simple
SQL query:
Select ID, format(MaturityDate, "dd-mmm-yy") as MatDate

I really need some help. I have been trying to get this to work for hours
but can't solve it.
I have a list of Facilities that were inspection (tbl1). In the other table
is a listing of their inspections to include a grade and the date it