This sounds pretty stupid, but I can't figure this out?  Brain freeze!

IsSpc: InStr(1,[RxScript],Chr(32),1)
Gives Error:  Undefined Function 'instr' in Expression.
I have used 'instr' for years. Now my desktop MOD XP is balking, even though
the "Visual Basic for Applications" is listed as an available Reference in

I am in the queries under objects section but I don't know where to go from
here when I need to create a query using wizard, any suggestions on how to do
this?
Thanks!

Hoping for some help here.  I have two tables in my database that I'm trying
to join. A simplified example
TABLE1
Article      Year

I have two tables, A and B. In the table B there some of the IDs of the
table A. How can i make a query to select all the record in the table A which
IDs are not also in table B?
Thanks very much.

I am writing database for counting credits.
Need to use an iff function in a query
The result of the function should be:
If  sum of credits >50, then 50, otherwise the result should be a sum of

I'm running thisquery to concatenate last and first names into one field.  
How can I get the blanks out after last name? Thanks for any ideas.
SELECT [pt_last] & ', ' & [pt_first]
FROM batches;

I have a simple table that has only 2 colums, a name and a type. IE:
Name        Type
------------------
Jason        1

I have the following query which won't work:
SELECT [select pvt items].[ref number],
DLookUp("[private]![doctor]","[private]","[private]![ID]=[ref number]") AS
Expr1

I have two tables of restaurant data, one shows all items rung through a
till, the other shows how each check was paid off.
The link between the two is the 'check id'
I want to write a query which shows all checks and the detail for tables

Can anyone find the syntax error in this inner join SQL.
UPDATE tblContacts INNER JOIN tblCompanies
ON (tbl.Contacts.phone=tblCompanies.phone)
AND (tbl.Contacts.Address1=tblCompanies.Address1)

I have two tables:
log sheet
log_sheet - linked table from excel (emailed from contractor and saved to my
computer so I can update my database)

I have a shared Excel file where various people go in a plug in numbers.  My
Access 2003 database is linked to that file, and as necessary I use that
linked table in a query that moves the data over into a different table.
PROBLEMS:

Hello,
I wonder if you can help.
I have a query that opens up all the records where there is no entry in a
field called GameFormat.

I have an issue that is probably really simple.
I am trying to do a date calculation between two date fields but I keep
getting an error in Access.  Here is the info that I am working with.
I have added notes next to the field names stating what the fields are.