I have a table that has multiple fields   Two of the fields are status
(number) and tdate(datetime).
so records would be like:
2   1/15/2005 7:30:00am

Is there a way of generating a CONDITIONAL UNION for instance
SELECT PRO_ID, PRO_NAME, PRO_VALUE FROM PRODUCT WHERE PRO_NAME="RULER"
IF (SELECT COUNT(PRO_ID) FROM ANOTHER_PRODUCT WHERE PRO_VALUE=10)=1 THEN
UNION A

While merging labels, A complete data is not merged Eg: out of 800 records
only 447 records are selected in any order. I have checked all fields to
clear condition etc.

Is it possible to find what quarter of the year a given date is in?  Any
help will be appreciated.

Hej!
Har en fråga,  har en querie där jag skrivit i criteria Year(Now())-1
Or Year(Now()). När jag kör frågan får jag upp info om en medlem
för året 2006 och 2005. Är det möjligt att bara ha den ena eller

I've looked everywhere to find out how to do this but I couldn't
figure it out.  I need to take a table and where the TG_ID is the same
but has different NPA and update ALL_NPA to look like that at the
bottom and where it only returns one line per TG_ID with all the

Ok.  Here is a query that I am working with:
SELECT X.id, Y.year
FROM program AS X LEFT JOIN financial AS Y
ON X.fin_no = Y.fin_no

I have table where that I want to remove about 5,00 records.  All this
records contain an investor_code
The records I want to remove are records with investor_code = P
I know I can use an Append Query but I never done an append query before.  

  I need to build a query that collects information about the most current
revision only.  For example...
Base      Revision   Date
A           A            2000

I work for an insurance company and I need some professional help.  I have
two tables one call "Claims" the other "Reviewers"
In the "Claims" table I have the following fields:
ClaimNumber (Text)

I need to modify my query below that uses 2 tables (06_statments and Directory)
We get the statement table from the university, they identify users by
something other than name.
I want to get all entries for each "Service Number" (telephone number) from

I need to do a comparison query based on a field that sometimes contains 12
characters and sometimes contains 13 characters. I need to ignore the first
character of the field, which i can do by itself, but if there are 13
characters in the field then I have to also ignore the ...

I have an extracted list of US zip codes and their longitude and
latitude.  I want to use this data to restrict the sales area of a
product.  For example, say I have a store with a certain product line
in zip code 12345.  A different store from zip 12347 calls and wants to

I have created a form keeping track of "Clients", primary keyed by SSN.
Another form was created to keep track of "Client Cases" each time a
client comes in seeking help. This Cases form is primary keyed by an
autonumber.

I'm not even sure how to phrase this for a search to see if it has been
answered before.  I have a query that identifies results in a table with two
pertinent fields:  program name and transfer code.  A program name can appear
anywhere from 1 - 10 times in the query results because ...