I have a query in Access 2002 which returns the results of all tests taken >=
a certain date.  At the beginning of each month I go into my query and update
the criteria date in 7 different fields manually (in the same query) so that
it returns the results i want.  I would like ...

I have 2 tables: 'age' being the primary key to both.
1 table containts 2 fields which is automated to the the age e.g. (l 18 l
15.05235 l 35.5261) the second 2 columns contains values which are attached
to the the first column (in this case 18). How do i automate the 2nd table ...

I've got a query which has payment information for our brokers for all of our
accounts. The first field is the broker name, I have a table with these
stored also with their corresponding email addresses. Currently, I select the
broker from a combo box on my form to view payments to ...

I have 10 soccer teams, so for each weekend there are 5 games.
The first weekend could be team 1 vs 2, 3 vs 4 etc.
How can I create a table with all the possible combinations for the whole
season,

I am using Access 2002 I have a database that gets populated every Friday
the fields involved are (Name, Days Worked, Week Ending) for example:  Name
= John Doe   Days Worked = 5 (5 working days), and Week Ending (9/2/2005).
What I like to have is a parameter query so when a user ...

I want to design a query that looks up a pricing table and returns the record
that comes imediatly BEFORE the date specified, however I need to know more
about forming the query and formating dates.  What steps should I take.
Thanks,

I create a 2 tabels, 1.master, 2.tran(trasaction).
1.master tabels column are(code,name,type,cur_bal)
   type=1 -> bank infomation
   type=2 -> party information

Please can anyone help.
I want to be able to set a column as 1 if a start date is the last day of
the month.
Example: someones start date is on the 31/01/2006 I want it to be something

I am using a text box in a form to set the criteria for one of the fields in
a crosstab query and get the following response "The Microsoft Jet database
engine does not recognize [Forms]![frmReports]![txtRegion] as a valid field
name or expresion." The section in [] works fine in ...

I have a query which picks up information chosen from a drop down list on a
form.
Form name - cost centre
field - ccentre

Help!  I am trying to make a query that calculates a new field based on the
square root of the value in an existing field.  I have tried:
NewField: SQRT([OldField])
But I get the error "Undefined function 'SQRT' in expression"

I just have a question about filtering date fields by Month name.
For example
Data is
ID                   Date

I need to rename a set of tables that are used in many queries in an app, and
I am getting tired of having to deal with the extra characters at the
beginning of the table names.
In each case, I will be removing the same string from the query (FYI - this

I'm trying to use MS Access to create some custom reports that aren't
directly available in QuickBooks.  Can anyone tell me
1) if it's possible for Access to link directly to QuickBooks data, or
2) if there's a way to export all the tables and their fields to an XML, txt

I have a criteria like this in my query
Like "*" & Forms![Form1]![searchField] & "*"
Basically it will return any record which contain the word which is typed in
the search field. This works fine if only one word is typed in. I was