Please help, in the detail report section , I have four IIF expression
builder.
Category A                          Category B
Category C                           Category D

My job currently requires me to enter data from 300+ forms a month.
The system which we used in Excel was slow , and theprevious guy had
three workbooks for this job .
I have created a table in Access with four fields

I have a query asking for records whose field (CombinedDate) is not null.
I'd like be able to pull out only records whose CombinedDate occurs within
the next 2 weeks.
I have trouble creating expressions for dates & don't really catch when to

I have a select distinct query as follows:
SELECT DISTINCT [MergeString] FROM qryMergeTime
Whilst this does return the right records (i,e. only shows unique records in
the [MergeString] field, it doesnt show all the fields that I need to see,

Is it possible to select different fields from one tabel depending on wether
different selection boxes are ticked or not? I would like to write an
SQL-query like this:
SELECT Register.[E-mail_1]

  I want to use date variables in the criteria of a query.
When I put Between #1-1-07# and #1-30-07# it works
but if I try to use a date variable it doesn't work. In
the query by example view. The field in the database

Hi I have a field with data as per sample:
02075157471OR02075389326
The length of the data may vary
Is there a way to extract all the data including and to the right of the

I'm trying to run a query using a newly created check box.  I pasted the
properties from an existing check box so they would function the same way.  
The criteria that works on the original is "yes" or "no".  I can't get that
to work with the new text box.  Any suggestions?

Trying to create a report and keep getting "query must have at least one
destination field" error message.
Do I use a table or a query for the data to come from?
Cheers

I have a query with one field that occasionally has a null value.  I would
like to replace any null values with a proxy value.  
I would get that proxy from another table in the database which would like
to another field in the current table to determine which value to use as a

I have an append query to add records to table 1. This table has an ID field
set as AutoNumber. When records are appended to table 1, I need the
AutoNumber to be added to a second table. The second table has a field named
ID and it is a Number field.

I have a query string:
objRS.Open "Select * from Results WHERE Key =33", objConn, 0, 1
I need to change the 33 to the variable SearchText defined as follows:
Dim SearchText

Well, I'm getting this project done by writing my own routines instead of
trying to kludge FR03 DBWs.
Now I have another problem.
I get the error: Microsoft JET Database Engine error '80040e07'

It gives me a 'data type mismatch'
SELECT count(*), opdate
FROM qryticketsperday1
group by opdate

I need a query to pull the most recent n rows from a table. I figure the most
efficient way must be to use the autonumber key since that is indexed. So I
need to get the highest key then all records prior to that up to a certain
number (say 1000).