I have a query that may result in a linked table with no data. The result it
gives me is #ERROR. I want to change the message to be TBD.
I tried the below IIF statement and I still get the #ERROR.
PO DUE: IIf([DUE DATE]="","TBD",[DUE DATE])

I have a query and report for a table with several Names in it.  The query is
set up so that the criteria (under Name) is [enter name].  When the report is
run, it prompts for the name and issues a report for that name.  Is there
something I can enter for the prompt so that it ...

I setup a new Access Database in 2007 but saved it as 2003.  I linked ODBC
three tables to a SQL Server.  I then wrote a Make Table Query that had a
criteria for a certain type of record.  When I run the Make Table Query it
says in the lower left corner the following error:

I'm trying to exclude certain records i.e. containing either red, white or
blue in one field.
can someone explain
Not like "red" AND Not like "white" AND Not like "blue"

I have a query that is showing info like this:
Name    Thing    Date
A            A1          MAY
A            A2          MAY

I have a cross-tab which works exactly as I want it to - a simple sum
of all value for a given month for each supplier:
TRANSFORM (Sum([xSqFtTable].[SqFt])) AS SumOfSqFt
SELECT xSqFtTable.Name, Sum(xSqFtTable.SqFt) AS [Total Of SqFt]

How to suppress overwritte warnings whan export from query to excel?
I have DoCmd.SetWarnings False but it still gives warning when overwrite
existing file.
Private Sub cmdGetIt_Click()

I have a field that is set as a General date and contains date and time.  
Example:  7/31/2006 11:18:00 PM.
I'm using Between with parameters:
 Between [Enter begin date] and [Enter end date]

When printing an Access Database query, the grid line does not show at the
top of the heading (first row).  How can I make this appear.  I am using
Access 2003.  Thanks!

Is it possible to create a query which deletes all records in a table?  Sort
of a reverse append query?

is there a simple way to create a query to retrieve multiple field
components? by this i mean i need to pull data on specific people within our
database.  is there a way that i could enter ALL of the names of these people
to return the data i need rather than querying them one at ...

Does anybody know how to insert a text containing a vertical bar (|)
into a text column by code?
I'm inserting rows to a table by code using CurrentDb.Execute strSQL,
and everything runs fine until the SQL string contains a vertical bar

I have a query that is showing info like this:
Name    Thing    Date
A            A1          MAY
A            A2          MAY

I've got this SQL in a select query called 8_qselWF_Prod:
SELECT Year, Period, Entity, Function, Prod, AllocMeth, Sum([Sum Monetary
Amount]) AS ProdAmt, CDbl(DSum("[ProdAmt]","8_qselWF_Prod")) AS ProdTtl,
CDbl([ProdAmt]/[ProdTtl]) AS Pct

I have a combo box with which users choose a particular staff member.  There
is a second combo that is then limited to clients of the staff member chosen
in the first combo.  It all works great except for one problem:  I have a
"generic" client that is used for certain types of ...