I have a table "Training_Session", two attributes in the table, are "date"
and "finish_time".  The date represents the date the training session is
held, the finish time is the time that the training_session is completed.  
They are both Date/Time Fields, the key thing to note is ...

I am trying to locate a posting error in our GL table. The error in question
can be located when the line posted immediately before the freight
(GLAccount 603750) is GLAccount 785099 (Exchange). The ID field is an
autonumber so I guess it can be used to get ID -1

how do you look up a street in an address in a parameter query?

I am running Access 2000.  I have created a query called newcustomers.  I
have created
a report called newcustreport.  On the On Open event of the report, I want
to have the

I am trying to create a query that will count one field and will allow
us to have a date parameter, i.e. select the date or date period we
want.
The query contains three fields: occupation, Filed date, and a count

I am new to MS access and have an assignment to find out if the particular
column name exists in about 50 different tables in a given MS access database.
Any suggestions?

In a query, I have two tables that I'm joining together with Left-Join on two
fields  Here's a non-artist's rendering of the two tables :)
Table1
    ItemType

I have the following in my query on reportdate field, but I'm getting a
syntax error.  
Between Forms![frmReportPanel]![FromDate] AND Forms![frmReportPanel]![ToDate]
Can anyone tell me the correct syntax?

Thank you in advance, I have a query that is composed of two tables, one
table contains basic information records for all the companies we do
accounting for (name, tel, fax, address).  The second table contains a year
column, and a column for each month of the year.  Both tables ...

I have a report input that I need to pull from 4 different columns, each of
which will either have a yes or a no in the record. How can I total, say the
number of yes's in each of the columns?

i have several records per person for example
Name              paid          date
joe smith      $50.00       1/20/2003
joe smith      $20.00       2/20/2003

I am pulling data from 3 tables and it is possible a report may be pulled
executing this query when no record has yet been created in one of the
tables.  When this happens an error is shown on the report.  
Two tables are joined to the main table by an ID# and the joins are #1.

I have a table with a column named "Policy".  Unfortunately, it is an
imported table without a primary key.  My problem is that I need to
distinguish this field.  There are duplicate Policy numbers and other columns
with the same or different records  For Example:

I am using Access to preform an Append Querry but no records will append.

I have two tables and I need to get a third table with the differences :
Table 1
---------
Field1 :-> A