Help w/Query for Report

  • Thread starter Thread starter Damon Johnson
  • Start date Start date
D

Damon Johnson

Hi All,
Access 2002 on Win XP Pro

These are the fields I have so far;


Partno Date
PD-123 10/8/99
PD-123 10/8/99
PD-123 11/5/87
SP-32 11/5/89
RF-56 11/5/89
PD-451 10/5/90

I would like to be able to have a query that can scroll through the PARTNO
field and count how many of each part number was sold for a given time
period
I don't want to have to tpye the entire part number, but just type in the
prefix (PD, for example) as a parameter. And it give me how many PD-123's
were sold, how many PD-451's were sold and so on.
I guess the question from the query would be;

Tell me how many PD-*** were sold from 1/1/87 to 1/1/99.

What additional fields and calculations should I include in my query?
Iwant to be able to have a form that a user can input all the parameters in
at once. Then I would like to have the results print out on a report.

Thanks a bunch,
Damon
 
Hi,


Something like:


SELEC PartNo, COUNT(*)
FROM tableNameHere
WHERE PartNo LIKE [PartNo begin by: ] & "*"
GROUP BY PartNo




Hoping it may help,
Vanderghast, Access MVP
 
Thanks, I'll give it a try now.
Damon
-----Original Message-----
Hi,


Something like:


SELEC PartNo, COUNT(*)
FROM tableNameHere
WHERE PartNo LIKE [PartNo begin by: ] & "*"
GROUP BY PartNo




Hoping it may help,
Vanderghast, Access MVP


Damon Johnson said:
Hi All,
Access 2002 on Win XP Pro

These are the fields I have so far;


Partno Date
PD-123 10/8/99
PD-123 10/8/99
PD-123 11/5/87
SP-32 11/5/89
RF-56 11/5/89
PD-451 10/5/90

I would like to be able to have a query that can
Click to expand...
scroll through the
PARTNO
field and count how many of each part number was sold for a given time
period
I don't want to have to tpye the entire part number, but just type in the
prefix (PD, for example) as a parameter. And it give me how many PD-123's
were sold, how many PD-451's were sold and so on.
I guess the question from the query would be;

Tell me how many PD-*** were sold from 1/1/87 to 1/1/99.

What additional fields and calculations should I include in my query?
Iwant to be able to have a form that a user can input
Click to expand...
all the parameters
in
at once. Then I would like to have the results print out on a report.

Thanks a bunch,
Damon
Click to expand...


.
Click to expand...
 
Back
Top