Access 2000. If I put a specific date, or a date <, in one column criteria it
is OK, but if I put crieria in two columns it only shows some of the data or
none at all. I have been unable to get any information up if I put > and <
dates.

This seems like it should be doable but I can't figure it out. I want to
reduce multiple records to one where the start date of one record is the day
after the end date of another where EEnum and Bondtype are equal. Thanks in
advance for any help you can provide. Example below.

I have attached my sql which does not seem to work.
UPDATE Material1A INNER JOIN war100708 ON Material1A.KishMaterialID =
war100708.KishMaterialID SET war100708.SKUNumber = Material1A!WARSKU;
It deletes the sku number from the original table (war100708) but it does

I have entered the following expression in the criteria field of a
query I am using in a form/subform.
IIf([Forms]![Current Unapproved Tickets]![Combo3]=0,"*",[Forms]!
[Current Unapproved Tickets![Combo3])

What is the SQL-92 equivalent to Access '&' when combining strings? Such as
getting a Full Name using Access is [First] & " " & [Last].
Specifically, I am trying to get a date in format mm/dd/yyyy.
I want Access Date(); I am using SQL-92

How do I get a pass through query to pull data from a column that has date
and time in it?
Thanks in advance for your help.

Thanks for taking the time to read my question.
I'm updating a DB and currently all the prices are split into different
columns based on package size. I'd like to get all prices into one column
now, as each package size now has it's own product code (Before there was

I am successfully pulling data fields from table-A to table-B based upon
record field relationships.  Now I would like to write a query to tell me
when table-A has additional records that need to be pulled into table-B.  An
exception query, if you will.

I have a csv text data that contains address information that has been
concatenated in an external query and imported into our database using the
TransferText method. The problem is that some of the records include PO box
numbers and Unit numbers so the addr_line2 field value ...

I have a crosstab query and would like to have date as column heading.
The heading column needs to fixes even there is no even in the table.
For example the data as following:
"Activity Date", "Activity Code",

A dataset of patient records includes two fields that define service dates
([from_date] and [thru_date]).  I want to create a subset of records that
were active on a specific date, i.e. 7/31/08.  The following sql returns no
records:

I am wanting to do 'bulk updates' to a Notes field - based on appropriate
criteria.  eg - "I send an email to all Volunteers living in Wellington to
invite them to ....".  (NOTE: The user has requested that the Notes field be
one record as opposed to a new record each time a new ...

Using MS Access 2003 with ODBC to SQL Server 2005 on a Win XP US English
system. The database is Access 2000 format. I do not have "SQL Server
Compatible Syntax (ANSI 92)" selected.
Several fields of my database are nvarchar text with mixed English and

I have a large database of patient specific information that I need to query.
I have times admitted and discharged into the unit stored in  10/2/2008  
11:05:00 AM type format.  What I need is to figure out how to write a query,
macro or something that I could run to tell me how ...