Hello. In my query I need to insert two records set if the result has only
two recordset.
I need to insert on employees time table the time that they spend to launch
per day if that time don't exist.

I've written a simple crosstab query based upon a select query which
has several left joins and subqueries in the WHERE clause.  The select
query runs fine, but when I try to run the crosstab query it says that
"The Microsoft Jet database engine does not recognize 'tRs.ID' as a

Hi I have a form named ParamForm that has two unbound text boxes name
SartDate and EndDate.
I would like to have my query open this form and to be able to input the
start date and end date bofore running the query and the attacthed report.

I wonder if anyone can help me, I have crosstab queries set up to show
orders recevied and orders closed for two teams by each week of the current
year, ( fields are Date_Received and Date_Closed )both of which are date and
time formatted, that all works fine.

HI I need to create a calculated field in a query in an Access Proyect (.adp)
but I dont know how, if somebody can help I would appreciate it.
Thanks

I have trouble believing that I can't figure this out, but I'm stuck. How do
I set up a condition in a query where I want all the records that have the
same value in a particular field, when I don't know (or care) what that
value actually is?

I accidently replaced my files on access, can you tell me how to restore
them back.  Thanks, Lynda

I'm running a query on a table and the records that are returned are often
duplicated (returned more than one).  This may be to general a question, but
what causes this?

Original code:
strCommand = "DELETE tblCMValues.* FROM qryCMValues WHERE [CMID] = " &
strZeroID & " AND [Type] =  """ & strType & """"
However, Type is in a different table in the query, so I was getting error

This Question is directed toware John Vinson.
A while back, I asked for a solution to find random records for mailing
throughout a 100,000+ database.  You told me to put the following into a
module:

I have a table containing transaction data which includes a 'SoldDate'
field.  This table contains records relating to all days of the week.
However, I want to exclude records relating to Saturdays in some of my
queries.

Im trying to setup a querry where  i can select one day two days or a week
etc using a date picker?
the problem is when i use Between [Forms]![Report]![startdate] And [Forms]!
[Report]![enddate] in date column in the criteria it does not like the one

How do I refer to a control on a sub-form in the query grid?

I want a query that extracts my own personal expenses from the total amount.
Do do so, i have to exclude some other items from the selection, even if
payed with my credit card.
The field is a text that starts with the number of my credit card and then

I seriously need some help. This problem has taken up way to much of
my time. I've spent hours searching through example code and trying to
change it so it works for me but nothing does. What I have is a small
database where I need to allow users to search for repair shops. I