Can anyone tell me what I am doing wrong.  I am getting this error when I
try to run the following:
strSQL = "SELECT tblHouses.RollNumber,
tblCurrentMeterInformation.RollNumber, tblHouses.FirstOfHouseAddress,

The following query runs without error, but does not update the fields. I
have a similar query that works fine.  Any help is appreciated.
UPDATE SummryT002, SummryT003_RptData
SET SummryT002.RptName = SummryT003_RptData!RptName,

Myself a novice user. I am building a databse and one of the elements is a
form designed to look like a programme card for my Personal Trainers to write
a bespoke programme using a number of combo drop boxes, so they can choose
exercise, reps, sets and so on. The data for these ...

I created three different tables with common field I would like to do a query
that merge common fields and uncommon fields into one table the only problems
is that some on field have data type memo, I am getting a messege that the
query cann't be created because of these types of ...

New Column Name: CostFactor1.  Statement Criteria: If [vendor code] field is
667 then the value will be 667, else if vendor code is 1897 then value is
1897, else (if none of those two are met) then result is a combination of
[Manufacturer Code] & [Category] fields.

I have a query with fields of job name, job number, bidder 1, bidder 2,
bidder 3, bidder 4.  I want to be able to see the job number, name, for all
records in which fields bidder 1, bidder 2 or bidder 3 field has info
entered.  Some records may have bidder 1 blank, but will have ...

I have a database with 2 fields that are check boxes. What I want is my query
to compare both fields and only display that record if EITHER is a "no"
condition, but filter out if BOTH are "yes"

I have a table that uses yes/no checkboxes. I'm now at a point where I need
to use the data in a query, especially in IIF() statements. However, I don't
know how this is done with checkboxes. It returns an error if I write
IIF([field]="Yes",1,0) .

I had created macros in 2000 which called a series of queries, but now in
2003 this won't work.  When I try to run the macro it just closed the
database entirely. How can I run multiple queries in 2003?

Would like to have a list of valid Values for a field to drop when Q is ran.  
For example, Start Q--Use Between[x] And [y] for date range, then the list
box would open to select a choice to satisy the next criteria.  How would
this be accomplished?

I have been stifled with question for 5 days...my boss will lose hi
patience....help please!!
i have a table "students" in my case as below,
Student# -------------------City --------------------------Amount

I deleted part of my accessfile , saved and now I want to find what I deleted
. is this possible, can i find an older version of my file on file somewhere?

I have a database of records with expected (Expr1) and final (Expr2) due
dates.  These dates are calculated with the Dateadd function and calculate
correctly.
I'm trying to create queries (and reports based off the queries) that will

I have a parameter that uses
Between [Forms]![frmMaster]![BeginDate] And [Forms]![frmMaster]![EndDate]
The problem is:  I don't want the dates to be required.  Is there a way to
tell my query to ignore the dates?

I have a Table with a Birthday field and its type is DATE. How will i filter
or query those records whose birthday is NOVEMBER?
please help me.