I have a question about UNION's.
If you have a SQL Union Query and you want to UNION it with another SQL
Union Query how would you do this?  Is there a Sub-UNION?
Query 1

Does anyone know the maximum length allowed for a passthrough query in Access
2007?  So far, I have found a query length of 76,944 fails, but length 52,537
works just fine.
The error I receive when attempting to assign the SQL (done in VBA) is 438 -

Please help I'm absolutely stuck on this one, and I need assistance
pretty badly. I'm issuing a query whereby my order source field has 3
possible values, either c w or blank.  But in this case blank isn't
null it's just the 3rd option, phones.

Hi...
I'm trying to update several fields in several records in a table.
I use a form for user input.
Here's the code that I use.

I have a calculated field that calculates a date. It does not seem to retain
the date property.  It sorts as text rather than a date – I have been able to
set the field property format to short date.  It will sort by date if run
from the query screen.  I need to be able to select ...

How to calculate the age of the persons of a group for a precise day?
Example: what age do each one will have on July 1st 2008?
Thank you

I am trying to find a querry that will exclude a line of data if the
UnderlyingSymbol is in the list and the TradeType is Pip.
I tried this but to no avail
SELECT BTA_Trades_April.*

I'm trying to add to my query the percentage of New Business Issued with a
Downpayment.  In my query I'm counting the "RecordID" to count All New
Business Accounts and accounts with DownPayment have a code in the
DownPaymentCode field.  I'm counting NB with Down Payments with the ...

I have a situation with a number of corrupted mdb files when they are opened
on a machine running Vista. If I also try and compact/repair I get a message
"The Visual Basic for Applications project in the database is corrupt"
displays a number of times and then MsAccess.exe hangs ...

Hello. I'm creating a database for a website and I need a query that
Identifies how many records and that gives them numbers.
In my site I have 5 columns. There's a filters that loads for each column
their own data.

I have a 2 tables that contains the fields
Table1
EmployeID
EmployeeName

I have an M2M relation with a link table (tblTagLinks) containing parent keys (PKey) and child keys (CKey).
I want to return the smallest set of PKey values which have links to two different CKey values.
In other words, how do I combine
SELECT tblTagLinks.PKey

I have Access 2002.  I want to create a query so that only the first two
letters of an email appear.  How do I create such a query?
Thanks in advance,
Paul

Why is it that a query in Access resturns strange values when summing simple
figures.
Example: I have a number of records with a number field values like 8  7.5
6  8 12 9.3 and so on.

I am getting resistance to using Access databases at work because some
people who I believe don't know what they are talking about.  I am told that
when Access runs a query from tables on a server(split database)it pulls all
of the data back to the front end then querries it, ...