I have two data fields.  Field1 is 5 character length and Field 2 is 3.  I
need a query in which Field2= first 3 character of Field1.  How do I do that?
Thank you for your help.

I have a table with date, hour, and traffic data. The table was updated in
an hourly basis,e.g.
date    hour    traffic
5/1/05    0    100

Having the table named [Top3Sales] with some date like that:
Dept    Item    Sales
1223    OPQ    $868.00
1229    OPQ    $1,956.00

I am trying to combine the Alles170* rows into one row that shows the totals
for each column.
   ColA          ColB        ColC         ColD            ColE         ColF
   Alles170    -£86.92                    -£380.00       -£193.88

I use the like function under my criteria in some queries to be prompted when
I run the query, like day of the week.  When I try to put 2 days in I get no
results - I've tried seperating them by , or ;.  I can enter "Tue" and bring
up all Tuesday's events or "Wed" and bring up ...

Help.  I need to return the top records (based on highest Count) by
day....any suggestions?  This is what I have so far:
SELECT Date1, Field2, Count([ID])
FROM Table1

Hello,
I have a database where users update a number of products. They include an
update date each time.
How can I create a query to show only the last 3 updates - based on the

I am trying to create a parameter query where the user will enter a begin
date and an end date. When I run the query with the dates hard coded
(between #05/01/2005# and #05/31/2005#), I get the correct results. When I
run the query as a parameter query, I get result records in the ...

I need to construct a query that works something like this:
SELECT COLUMN(x) FROM TABLE
WHERE ROW1 = 1
The part I can't figure out is how to select a particular column whose

Hi, I have a table that has a list of different materials in one column and a
series of columns for different dates, each containing order numbers for each
material.
Material               Jan          Feb

I wish to create an Incremental Number field for this Make-Table Query which
is based on the records from another table. So each line of records in the
new Table has an incremented number starting from 1.
Do I use the ALTER TABLE statement? and how...

I'm creating a parameter query in my database, but I'd like the users to be
able to choose the parameter (like from a dropdown list) instead of having
to know the exact spelling of the parameter.  Is this possible?  The
selections for the parameter are in a separate table.

I am not getting why I can't 3 0's to display.  I get an error message
"Expecting End of Statement" while to trying to compile this code AND if I
leave 000 with nothing I get 1 0 and I need 3 to display in combination with
the CustomerID.  Cananyone point me in the right ...

I have four columns as follow:
Day           Product       Planned,qty              Actual,qty
5/1/2005      NNN            150                          130
5/1/2005      SSS            1000                         990

Please help me!! It is my first week at my first job and I have to go into a
meeting very soon to discuss some findings. I kinda told my boss that I could
create this report 'no problem'- which I thought I could. Here's my dilemma:
I need to create a summary report of an access ...