Access 2000 and Excel 2000.
I have several dates in a column of type datetime that are 1 January 1900.
When I copy/paste these dates into an excel spreadsheet they became 2 January
1900. The underlying integer value of 1 January 1900 in Access appears to be

I am trying to make a query that looks at the [Date Loss]-Date() and counts
the number that are <=30, Between 31 And 60, Between 61 And 90.  
Here is the SQL:
SELECT [CSM Report HHB].PMOS, [CSM Report HHB].GRADE, [CSM Report

I have a main form which displays a specific contacts details and a
subform which displays all contacts for the same company (with a link
which will display the selected alternative contacts details in the
main form if double clicked)

I have a query that counts the total number of records per Tech per month.
I'd like to see 0 for months when a Tech has no records but the NZ function
doesn't seem to be giving me that.  For instance when I run the query
(below), if one tech doesn't have any records for September ...

I just upgraded to Office 2007 yesterday.  I regularly work in a SQL 2005
database that I link to via ODBC in Access.  When I used Access 2003, I could
right click inside a column and enter criteria in the 'Filter For' box, such
as the following:

I have a table where there are several fields that hold a numerical
value. It is in fact a table that holds the results for tests. each
unit is tested on about 10 different aspects. Each one is scored from
1 to 4.

I am attempting to write a query on input values that can be Yes, No or N/A
but on the query I only want a count by category of the No responses.  I am
having no luck so far using either count or dcount.

I need a query that will return a record for every combination of records in
tables [employee] and [training_needs].
E.g. if [employee] has 6 records and [training_needs] has 7 records, my
query must return all 42 combinations.

Is there any way to use what is picked in a listbox as the table name in a
query?  Say I have a table that contains all my data which changes from week
to week.  I want the user to be able to pick the date (which is the same as
the table name) and run a query to compare it to the ...

Good Afternoon,
     I'm trying to determine a way to select objects (names) from an access
table to generate a report.  It's be nice if, a select query would permit you
to specify a quantity of items to be selected.  Can anyone assist?

I have a query based on a table that will continue to have data added to it.  
The query in question is based on date parameters.  The actual "Count" is
accurate for number of appeals and cost of appealsbroken down by different
responsibility.  The problem is with the percentages. ...

I'm having a brain cramp.  I am trying to create a query on a form where you
can type in a value in a text box, and if that value is in the table the
information for that value is displayed on the form.  Is there an easy way to
do this?  Thanks in advance!

I have an Access 2000 application where the user can select a multiude of
criteria to produce a report. When the user clicks the 'Print' button, I
then build a dynamic SQL statement based on the criteria selected.
I just had to add some additional criteria selection to the report ...

I have a locationID, a start date, and a finish date. I calculate the number
of months between the two dates in a query.
So, for example:
LocationXYZ   1/1/06     1/1/07   12.

I have a field named TodaysDate for which I use the following expression:  
TodaysDate: Date()... which works fine.
I then have a field named DaysFromClose which uses the expression:
DaysFromClose: DateDiff("d",[Completion Date],[TodaysDate])... which works