I have a main table where all the data is kept and several queries with the
same data sorted in various ways.  The columns in my main table contain
information such as the title of the paper, the author(s), the instructor,
the year, etc.  I'm having trouble with sorting the Title ...

I have spent the last several days looking on this site for any help for
calculating a 7 day high and 7 day low.  I have found many discussions about
dates and using the current dates for calculations.  I need to find the 7 day
high and low for dates that occured in the past, ...

I've tried unsuccessfully, using DCount and a subquery to number records in
my query.
In a query called "ModelCount", I'm trying to number the records returned
from the "Model Build Count" query using the resourceID field, which is a

I have a query and it is pulling 3 fields, Item, year, qtySold.  How do I
write the query to show me only the items that sold 0 in year 2004 and 2005?
Thanks

I have a duedate and recdate that I would like to know what the days between
are
I have tried DATEDIF([DUEDATE],[RECDATE], "D")  it is unidentified.
Help.

I have a table called tblCustomer and a table called tblSales. My table
customer has a Cust_Contact column that has some blanks in it. My tblSales
table has an Owner, Service_Contact and a Sales_Contact columns.
What I want to do is have my query look at the tblCustomer table, and ...

I wish to sum the total employment for mulitple locations of each company.  
The database has hundreds of different companies.  How can I group each
company by name, and then calculate the employment sum for each company?  
Thank you.  

Using a three table join, I am trying to get an aggregate sum of one
field from one table and the count for a field in another table in the
same recordset. The problem is that if multple records are returned
from the join, the aggregates are multiplied by the number of records

Trying to use = ([Interval] \ 86400) & ":" & Format(([Interval] \ 3600) Mod
60, "00") & ":" & Format(([Interval] \ 60) Mod 60, "00") & ":" &
Format([Interval] Mod 60, "00")
to convert interval to DD:HH:MM:SS however the calculation is off. If there

This code calculates the age of an entry - but only in days!!!!
Counting days it works fine, but I need it to also show hours.
Example:  2 hours should show .2 not 2...
Help

I am trying to send a daily appointment sheet to my Salesmen.  I don't want
to send an entire data base, just those appointments for each day.  I've
tried using a report and a query.  For a number of reasons I don't to publish
my data base to the web, I need to use a form because ...

I have monthly sales data for a number of tenants.  I want to get a YTD Sum
and ad Running Year Sum i.e. June_2004 to July_2005.  I have no problem doing
either in a seperate query, but am having problems getting them into one
query.  Is there anyway to create a single query to ...

We just converted to Access 2003 from Access 1997. I was able to copy and
paste criteria into a parameter query when promted. Now I can't get the copy
or paste function to work when openning a query with an input criteria. What
should I be looking at to correct this problem?

When running a crosstab query, one cannot tell ahead of time what columns are
going to appear based on parameter criteria fed to an underlying query that a
crosstab query is created from.  That, of course, is the dynamic nature of
crosstab result sets.  However, if I know all the ...

Hi there, using A02 on XP.  Not a programmer.  Have a problem figuring out
how to get the data I need.  
I want to find all the contract records I need from tInfo and also see the
most recent [PYE] date for each contract from tRPSAdminBills.  The 2 tables