The setup I'm dealing with is as follows:
- The rows in both queries contain a field called 'system number' which is
the field being compared.
- In the first query there is only one row for each system number.

I have some tables that are named according to the date they are created e.g.
20080101TABLE, 20080215TABLE… and so on. The field names on these tables are
exactly the same. Currently I’m building a query to analyze every table but I
want to make this procedure faster. Before I ...

I think I have a simple question. I want to create a query to list tasks with
target completion dates scheduled before the end of the current month. I have
been unable to determine if there is an end of month expression I can plug
into a query designed by the Access 2000 wizard. ...

I created the Survey Database. I chose the Memo filed for my questions since
all questions are long.
I would like to give you an example of one question.
The problem is when I run the query, the question didn't show all.

I have a make table Query that pulls records which include invoice numbers
(table name is PromoTableAgentIncentive).  I have a query
(Promo_AgentIncentive_Exclude) that contains invoice numbers that are in the
PromoTableAgentIncentive but should be excluded from the final product ...

Team          Amount           Date
-------          ---------          ------
Blue             100               01/03/2008
Blue             200               02/03/2008

I have a field that contains 6 digits, then an astrik, then 3 digits, then an
astrik , then possible 2 digits, then an astrik and 1 digit.  I need to
filter for all but the records that contain the last astrick and 1 digit.  I
have tried  "Not Like "######" & "*" & "###" & "*" & ...

I have a a table (due to many reasons!), my query of "price" is text,
Now,
I want to convert it from "Text" into "Number".
(Because later on i need to export it to other system)

I have two date fields and I need the number of days from one date to the
other.  My fields are [Maturity date] and Date: [Enter a Date].  I want the
number of days between the two.  So if the maturity date = 12/31/12 and you
enter a date = 12/31/08.  That means on 12/31/08 there ...

I want to run a query on a table in which I have memo fields, thus they
contain greater than 255 characters, and output all the values in the field,
not just the first 255 characters.  How can I achieve this

For testing purposes, I want to restrict the query to a range of
numerical values e.g. <4999.
I get error messages when I try to type <4999 in the criteria field.
The field contains an expression does have an alias if that makes a

I have a series of daily date readings(over 3 years) and would like to sum
those by calendar month and year.
The table is:
Date    Volume

I'm currently building a pass through query which ties to an IBM Iseries ODBC
driver. Is there any way to include an "in" statement from another non-pass
through table or query in the same access database? For the sake of example,
let's say I have a static table of user names ...

What do I put to trim off the spaces after a value in query? The table is
obtained from ODBC link and the values on a field somehow got spaces. Example:
My field in the query is:
WC: PO_WORKCENTER_ID

Lets say I have 2 tables:  the 1st table has a field, ID1,  with records
a,b,c,d...  and the 2nd table has a field, ID2,  with records p,q,r,s...
What is a good way to make a query with Fields ID1 and ID2 that show all
combinations of 2 records, 1 from each table?   Like this: