I'm working with crosstab queries to do some counts.  I was wondering
how I can get a crosstab query to display the font color in Blue when
the count is 0 or Red when the count is greater than 0.  I've read
that this is not possible directly in a query, but I've been working

I have very large database( almost 500,000 ) that contains road
characteristic readings in two columns taken by a highly sophisticated
instrument . I would like to remove the rows that the instrument
missed to take the reading. Could some one help me in doing this.

I have a table with two fields, one for the homephonenumbers, and one for the
workphonenumbers.
Let's say I want to query for the home phone number and also provide for
null values. Then the criteria query for the user to input would be:

I am trying to divide one field by another, in a table or query (would be
happy for it to work in either!!).  The field I need the expression in is
called Federal Ratio.  
I am trying to divide Federal Share by Total Cost.  This is what I come up

how do I hide warning messages when running a delete or append query?

I have two tables
tableone
name#  emptyfield field3 field4 field5
tabletwo

I have very large database( almost 500,000 ) that contains road
characteristic readings in two columns taken by a highly sophisticated
instrument . I would like to remove the rows that the instrument
missed to take the reading. Could some one help me in doing this.

I want to get a Month-field in month-name instead of digit from a DateStamp
which is a TEXT-field (not created by me, an imported file),
e.g. dateStamp (TEXT):
2007-03-09-02.49.21.534728

When I used the following union query, I received an error message saying
"Snytax Error (missing operator) in query expression:
SELECT Month End query 1.F1, Month End query 1.F2 AS F2A, Month End Query
2.F2 AS F2B

I have 2 tables (table A and table B). Table B contains 100 records. Table A
contains 50 records. All 50 records from table A are in table B. I want to
create a delete query that will delete all the 50 common records from Table
B. I have created a query with both tables joined by ...

Ok, I am trying to create a query that will bring me back the top 5 Shrink %
Retails for each store in a table.  I've been tooling around with this but I
can seem to get it to work correctly.  Here's the base query:
SELECT [Weekly Detail].Area, [Weekly Detail].Region, [Weekly

I have the same question as one of authors submitted about the problem in
converting the Timestamp format into a normal date format and I found answer
as listed below.  However I couldn't get it worked ??  Please help.
My field is a text field from an imported file, and I am using ...

I was quite interested in some SQL I saw earlier in this site from Allen
Browne and John Spencer.  If the poster is OK with this, I'd like to steal it
for my app that deals with ping-pong tounaments.    The SQL involved  
SELECT........ (SELECT Top 3 ....) ...

I'm trying to reproduce the following (ignore the iserror stuff):
=IF(ISERROR(LEFT(G2,SEARCH(" ",G2,1))),G2,LEFT(G2,SEARCH(" ",G2,1)-1))
Basically I need to find the first occurence of a space, which will be
the end of a string of First Names, eg. Fleur Annabel and return just

I am working on a database that somebody else created.  This person used a
LOT of VB that I am not very familiar with but I am hoping I can solve this
problem without having to resort to hiring a VB person.
There is a form that is using a query to populate a subform, and the query