I have a querty that I want to look at DOB field and calculate if applicant
is over age 18 w/o having to change the  ">" date each time I run it.

Can someone tell me whether Wombats live only in Australia,
or also on other continents?
Apart from zoos, of course.
We all know that Wombats are to be found in Zoos.

I have a Base query that I need to filter down via a Form.  This form
has 21 options (date, Drop-down boxes, Check boxes) that can be used to
filter the data in my base query down for a report.
My Users have the ability to select a Type of form, whether or not that

What's wrong with qdf.Execute
If I use qdf.Execute, an error message comes out, but if I do not use qdf.
Execute, the following codes work OK
Set qdf = db.QueryDefs("qryCreateProd")

I'm a newbie to M/S Access. I need to do several calculations in a form
object.  Basically I want to calculate 4 intermediate results, display them
individually, and then combine them into an additional result. I can do the
calculations in text boxes, but can not find a way to ...

I'm looking to pass a value from a form to a query using something like the
following:
Like *[forms]![frmName]![txtValue]* where [txtValue] is a number which can
be contained anywhere within a string. For example:

I am looking for a way to query a table for the "latest workdate".
The table fields would be: Project,  Task (T1,T2,T3,etc)   and
workdate.  Within each project different tasks are worked upon at
different dates and each task may have many workdates associated with

I have the following rows and columns in a table
C1     C2
1      
        A

Scan steel receiving -     P063141049 682875 4480 There is a space between each
group of numbers. data length may be different so need to have the delimiter
in place to break correctly
First group of numbers will be the part number: P063141049 - need to drop

I have a table regarding tours that are given at our facility.  The main
fields are Tour ID, Tour Date, Tour Guide, Host Organization, etc.  All of
the tours are in CY05 and CY06.  I need to create a pivot chart that compares
the CY05 with CY06 sum of tours by Host Organization ...

I designed the following query a couple weeks ago.  It takes from an existing
table and creates another to my specified parameters.  It works fine with no
problems when running it.  Now I want to change it slightly but no matter
what I do when I go to save it it gives me a syntax ...

I have a query whith Col-A and Col-B. How can I do a difference(dates  
Col-B) in Col-C?
Col-A                             Col-B                    Col-C  (dufference)
Xpto (1st row)            15-Mar-2006                -      

Can someone please tell me how I would extract the first name from a text box
in an access query? i.e. Burt Reynolds  I want to extract Burt.
I tried this in a query and was successful extracting the last name..but it
has been challenging to extract just the first name.

I have a form that allows the user select from one check box of criteria and
then enter up to 4 "OR" criteria of data on 3 additional fields from 3
tables. The only way that I could complete this complicated task was to
create a total of 4 querys that return different data based ...

In a query, how can I select 'yes' records or all (yes and no records).  I
either want to see only yes-records or all records.
Thank you.