When I try to save a query I get the error "Invalid Argument".
When I switch to the datasheet view all of the data comes in just fine so I
don't understand why I am getting this error.

I have used Duane Hookum's concantenate code in a query - it works great!  
However, I need to modify it to fit my database application.
In my database, tblFamMem.FirstName is a number, which is linked to a lookup
table with NameID and NameText.  I want to be able to concantenate ...

SELECT [District Special Table].District_Id, [District Special
Table].District_Name_Long, [WA Capital Projects Special].CP_Scope, [WA
Capital Projects Special].CP_Status_ID, [Building
Special].Building_Name_Long, [School Special Table].Long_Name, [Capital

I'm sorry for the several posts, but I figured I'd enter a final detail
thread so we don't have to go back and forth.  I understand the concept, but
I'm having issues still.  This is what I want to do. (please excuse the
naming conventions, I know thy're poor)

Around 10 months ago I was using Excel to find out how many resolvers
had been involved in incidents based on extracts from our system.  As
a result of better reporting functionality this has now been
transferred to access so the queries can be created dynamically.

I have an inhouse function:
Function CalRunDate(drawn_date As Date)
Dim iday As Integer, calrundate2
iday = Weekday(DMax("drawn_date", "tblInLab_WC_TAT_ER57"))

Hi gurus!
I am wanting to INSERT mulitple records into a table based on a SELECT
statement from the same table.
I have an ID field in the Table I am APPENDing records to which needs to be

I'm hoping someone can help me with this as I'm not very advanced in Access.
I created a query.  Before the query opens I would like the user to input
info but I want them to select the info from a list box (or is it a value
list?).  In any case, I can get it to ask for the input ...

I have a query based on a single table. I have within the query 16 fields
(Abrasion, Laceration, Puncture, etc...) that vary in name but have the same
response "Yes", "No", or is left blank. I am trying to figure out within this
one query how to set up a parameter that will ...

 First off I am using Microsoft acess 2003 and am running of an SQL Server
I am designing a macro that calls a number of different queries to
accomplish my end goal.  Each query requires a date input (which is the same
for all of them).  I have created a form to enter the one ...

If I wanted to run an update query based on the multi-selected items in a
list box, how can I capture all the selected records?  Normally, I'd enter
the following in the query criteria.
[forms].[frmMain].[lstActiveStores]

Is it possible to update a table from a summary query?  I always get a
'operation must use an updatable query'.
For example, query 'qSumTracts2000' is the summary query
SELECT PDAsSubareasTracts.CT, Sum(PDAsSubareasTracts.[2000]) AS SumOf2000

I have a table with multiple fields.
In more then one field there are character as { } or ""
I want to remove these characters.
How can I remove these characters? I know already use a code to replace text

I've a table organized by states, years, subjects,
grades, levels and an associated student count.
I want to find the percentage of students in each
year, subject, grade and level.

Ok here is the problem:
I have the following task to do:
List everyone who has bought two or more books by the same author
Problem is I cant seem to udnerstand how subqueries work so Im totally