Everytime I open a merge main document with the new version of WORD (2003) I
get a message that reads: "Openning this document will open the following SQL
command: SELCT*FROM 'OO-O1$'  Data from your DB will be placed in the
document."

I have a query where I want to put the criteria
iif([forms]![master]![cmbfield]=0;null;[forms]![master]![cmbfield]) and
filter the field cmbkeymaster (Numeric)
cmbfield is numeric not string. I noticed that null takes it as string I

I am trying to create a Make Table query that will create a True/False
datatype field in the underlying table that is created. The user creates the
table and views the contents in a form, so I don't want them to alter the
table design to use it.

Access 2003.
I need to compare two tables which of the same structure and show the
difference (data).
Bascially we have a Table (i.e. CurrentEmployeeTable) which the whole table

I am having trouble with the query producing the correct Dates
I have the Log Date Field and for the criteria I have
Between Nz([Forms]![frmDate]![txtStart],[LogDate]) An
Nz([Forms]![frmDate]![txtEnd],[LogDate]

error message pop up, upon my trying to download the updates for microsoft
office 2003  ( when I press report it or don't report or simply X out ) it
wipe off the entrie thing.  What should I do......>?

To remove some redundancy between different but similar tables I have a
query which a field I defined that uses the Iif statement to compare memo
field A and memo field B in a database and choose A if it is <> "" and B
otherwise. i.e.

What I want is a query that will group data from several tables and put
together a report. I want this report to look like a ledger sheet with a
break down of what was paid by date.

Let me set the stage then try to explain what I think I understand about
update.  Basically, I am adding some data (a new table) to our employee
database from another, external data source.  (I'm going to simplify for the
sake of clarity.)  In the existing database, there is ...

I have 5 tables which were set up across rather than down - ie
fields are Jan04,Feb04...Sept04,Oct04...Jan05,Feb05...Aug05,Sept05
I currently have a query/report which is pulling the correct rolling12
months from the tables - but it requires the query/report to be

Im had to plan out the capacity the microsoft access database can hold. I am
supposed to find out how much is the size for each record per table and times
it with approximately the number of records extimated.
For example

Whenever I join two tables, it doesn't seem to matter what kind of join I
use, (left, right, equi, etc.)  but I can't update ANYTHING. (None of the
fields can be updated). Any help would be appreciated. Thanks

OK, I've browed through the threads and can't find a clue that can help me.
This is what I have -
Database with multiplte tables:
- Master Table (my term) is 3QYTD with many fields, key is UI

I need an Access query to convert data from this format:
key        flag
user1     A
user1     B

Customizing Access parameter queries, how will I make a query works using an
with six controls?  I am working with Access 2003.  I am grateful for Martin
Green Office Tips from http://www.fontstuff.com/access/acctut08.htm  and the
instruction works for my database. I have a ...