I can't seem to weed out the syntax error in this SQL query, even after
pasting the syntax from the immediate window into Access's SQL Window.  I
keep getting the "Enter Parameter Value" box with MCCR14D06 as the parameter
name, which is the value in lst.Column(1, varItem).  Any ...

I have designed the following query in the Access query design grid.
It deletes a record from a table with two fields. When I preview the query
results 4 fields are displayed:
fldTestRprtStdID, fldTestrprtStdRef, Field0, and Field1.

Each time I make the table, the information changes, but I want the fields
numbered 1,2,3,4... always starting with one.

I have a parameter query that asks for [Last name], [First Name] and sorts by
[Last name], [First Name]. A form uses this query. No problem here.
The users sometimes want to sort the data (on the form) by: [Code], [Last
Name], [First Name] or by: [Date], [Last Name], [First Name]  ...

Where is the setting that decides the size of the font in the Zoom window?
Right now, the zoom window is the same size as the Query grid, which kind of
defeats the purpose, to an extent.
Many thanks,

I have a query that is supposed to group results and sum totals of certain
fields.  The sql from the query design window is below...
SELECT BeginningOfWeek([pcslog dos]) AS SundayDate, Employee![EMP Last Name]
& ", " & Employee![EMP First Name] & " " & Employee![EMP Middle Name] ...

In Access 2000 DAO, what is the syntax to refer to a field in an open query?

*here is the post from 'forums' where not many people responded because I put
it in the wrong area. Thanks in advance!!*
Sorry, let me try this again. It's hard for me to explain everything. Let me
start with the one table. I work at a metal alloys company, and this database

How do I create a query to show when records do NOT match?
My data is something like this.
TABLE 1              TABLE 2
item number      item number

Hallo
I hope some one can help me
I have a query that has this as the criteria in the Date field:

I have a backend mdb and a frontend mdb. I have added a field to a table in
the backend using code. Now I need to update a query in the front end that
feeds a form to include the new field added to the table in the backend.
Can this be done through code thus the adding of the field ...

I know VBA and SQL, but I'm new in Access.
I would like to do a dynamic query, but don't know how, so if anybody could
help me I appreciate it.
What I have: many tables with the same fields, but different data.

Can anyone advise how I can change the name of a field when I create an
export file.
I have a table who's data is exported
orderID

This may be a very simple answer but i just cannot figure it out.  I have a
query with multiple columns one being address.  How could i search for only a
portion of whats entered in the column.  Below is a sample table:
Name                   Address

How do I change the snipped of SQL code below to force it to always choose
the last month?
Last(Iif(Assistant_Retail_Manager_Activities.Month BETWEEN #01/01/2005# AND
#03/31/2005#,Assistant_Retail_Manager_Activities.Deposits_Outstanding,0)) AS