Hello everyone..
I am attempting to automate the generation of reporting data that is stored
in an access databse. Normally this data would be generated by the
application, but in this situation, I need to fake the data for demo

Have made a query which I need to display the records in a report for a
nominated customer.
The fields I used are
CustomerID (Combo box), unitno, repairdate (paramater between start

Dear Group,
I'm trying to do an SQL query which updates a column with the results
of a sum.  If feel like it should be simple but I can't get the syntax
right.  Here's the problem:

I have 2 queries. The second query uses the first query to select the
total jobs for each driver. What I cannot do is to get the query to
prompt for start and end date so that the selected records fall between
the two dates. My first query is as follows:

I have the following query to delete the top 65500 records from a table
tbl_CRS
DELETE * From tbl_CRS
SELECT TOP 65500

I have a table with four fields: Project,Month, HoursSpentToDate,
WorkHrsThisMonth.
Project is a project name
MonthNo is the sequential number of each month in the calendar.  There can

How do I create a delete query button on a form.
The button wizard does not list my delete query.
I ve also aked this on the forms page... sorry for reading it twice.

I am trying to write a Acces query where I only show the part after the ~
sign in a column? I know how to do this in Excel but can't figure it out in
ACCESS. Can anyone give me a hand?
Thanks,

Hi,
I have two tables in access (e.g. t1 and t2). I am trying to delete rows
from t1 where t1.key1 and t1.key2 = t2.key1 and t2.key2. There is not a
column that is unique in either table, rather there is a concatenated primary

In my parameter query I have a field called "Rec'd Date" that shows date and
time for example - 2/28/2006 11:20:28 AM or 2/28/2006 my problem is when the
query pops up asking for the Rec'd date I would input 2/28/2006 I only get
the 2/28/2006 data not the 2/28/2006 11:20:28 AM  ...

I am doing a simple select query between a SQL database table and an Excel
file.  When I join the two appropriate fields, I receive a "type mismatch in
expression" message.  The Excel file is formatted as text and I have
performed this identical query with other Excel files and ...

One job of a database I am building is to track if "Incoming Folks" have been
"Phoned" or "Mailed".  These two things are tracked in two different fields
in the same table using "Yes/No" Combo Box.  I would like to have a query
that will provide a list of all folks with a 'No' in ...

Some help please.  Daily I am importing an excel worksheet into access to be
able to generate reports.  The orignal date field in excel is formatted as
date time as my reports are base on differences in time.  I want the user to
input a date and generate a report only for that ...

Example:
Two Tables (Table 1 and Table 2)
Field = ItemNumber (Primary Key on Table 1; Foreign Key on Table 2)
How would I identify all instances where the ItemNumber is populated on

The line of code shown below consistantly deletes one fewer records than it
should, i.e if there are three records that meet the delete criteria, ony two
are deleted.
Docmd.RunSQL("Delete From Output WHERE [Cntrl] = True")