I'm getting 'Invalid argument' error trying to save this query. User claims
it ran fine until last Friday. Can anyone see a problem with the syntax? How
do you debug this type of thing? I removed the WHERE and ORDER BY and still
get the error, so it appears to be in the SELECT.

I have a date field which i want to group by month in a query, how do i do
this?
Field is [OrderDate]
Thanks,

Morning,
I currently have a maketable query that links to a pass thru query to create
a table.  Is there a statement I can add to the passthru query that will make
it create a new table all by itself?  Below is my current SQL passthru:

I have a table which requires updating monthly with information from 10
employees who do not have Access.  In order to ensure the data remained
generic I exported the table to an Excel file which I asked them to complete.
However, now when I try to import it back in, it errors ...

How do I design a query to show the items that do not match versus the
items that matched, when querying two files using a primary key?  I
need the outliers rather than the matches.

How can I concatanate values of one column in a query. for example
data:
ID    Text
1     A

Say I have 500 records that has been sorted in ascending order (post code).
How can I increment a new field with 1,3,5 etc for the first 250 records
then the second 250 with 2,4,6 etc
regards, Garry

I have been trying to nut out a query for the last few days and I have
found a solution using a vba function but I would like to optimize it
so it runs a whole lot faster.
I am developing a database for a contracting company which records all

Is there a function that can be used to access a value from a previous record
in a query?  I'm trying to build a formula that will pull the data from a
specific field found in the previous record.  i.e.  field2:
previous_record([field1])

Can anyone give me any guidance on how I can update a field in a table from a
query with summed totals?
Thanks!

I would be grateful for some help in writing a date expression in a query and
report (Access 2003).
I need the query/report to display all records where the due date is between
todays date plus 1 day". "Todays date plus 1 week". " Todays date plus 1

Yeah, I have a query that is populating in a subform. In the WHERE
clause I have one of the fields outside of the subfield. It shows
everything fine except the particular table's (that I'm querying) key,
which shows an "#Name?" value in it.

I want to run a query that does not show certain account types, for example
M, D, 1, DS, DV, S, X... I keep getting an error that my string is too long.

I can create a new table from two tables. Can I ad a primary key
(autonumber) the same time. cheers

I have a list of records and I want to select the records with times less
than 07:30:00 AM.  I keep getting a mismatch error when I try to run it.  I'm
trying to use the IFF statement to flag these events.
I have tried