I need to produce a report by division, product, state and salesman that
totals price and quantity for years 2003 thru 2005.
I thought of a cross tab query, but I can only sum on one field and can only
hav max of 3 row headings.  How can I accomplish this.

Hio Group,
After reading several newsgroup postings, I was able to construct the
following SQL, which filters records according to the most recent date,
but my problem is that it's so slow.  There are only 5,000 records in

In our dB someone enter descriptions in capital letters. I need to Identify
those entry. How can I do that?

Hi, i have a problem that i think someone will be able to help me with,
i have a log file showing my router connectivity. the fields are
Date, Time, cct condition
the cct condition shows the result of a ping, this can either give the result

I have a field containing mainly alpha strings, some records have an asterisk
as the first character.  How could I create a Select Query which just shows
me the records that begin with an asterisk?  Is there a way to make an
asterisk an asterisk rather than a wild card?

IM stumped What i have is 9 colums that have different dates . I need to
query for the newest date and only the newest and place them into one column.
HOW ?

Hi, Please help...
I have a query that pulls back all visit enquires on a job. from the results
its shows me multiple rows for the same job. Is there a way of taking all
this data and placing it all onto 1 row?

I have a field in my query where it looks at another field and if that field
is less than 450 it puts that amount in the field but if it is more than 450
it puts in 450.  That part works fine, however when the field is blank or
empty I want this field to remain empty also.  Here ...

I am new at this and need some direction. After creating a 2 table database
with forms and reports, etc., I realized I needed to catagorize the accounts.
I have spent two days inputing data. Today I created a new table, 'Catagory'.
When I try to add it to a query, with the table ...

I created a form to download debit transactions using a multiselect of
accounts and a date range.
Everything works dandy. The code is:
Private Sub run_download_request_Click()

Hi, Please help... :-)
I have a query that counts the number of days between visit and closure of a
job. This gives me a vast number of results. What I am trying to do is group
them together so that its easier to report on.

I have a really long IIF statement in a Query. I need an ELSE at the end,
because if its none of the options then I need it to be Z. Otherwise my sub
query whiches uses these codes has a blank fld.
Does anyone have any suggestions on how I could handle this?

Criteria for a number field in query design view is coming from a Form
unbound text box.
[Forms]![Form1].[NumberTxtBox]
When user puts X (i.e. 100) in that textbox and runs the query - all the

Hello chaps,
I am really hoping somebody can help me out with this one as I just cant get
it solved.  Here is what I am trying to do.
I have a table of items, each item has an age and a date it was uploaded into

I`m using a form to Generate a report. In My form I have 1 combo box. What
can I put in my Query for the Criteria section if I want the report to
generate the selection i made in the combo box.