groupby

  • Thread starter Thread starter bruce
  • Start date Start date
B

bruce

I have table including StillageNo and part No. what we
have is inseted of having one stillage no and 8 part no we
have 8 of each.

now they want me to make a query to show just one stillage
no and the 8 part no infornt of it.

i have done group by but in group by you can only find
first and last, is there anyway round of it.
 
Huh?

Did "they" ask you to spell-check anything you write before sending it for
others to read?

Did "they" also ask you to re-read what you wrote to see if it makes sense
to your targeted readers?

Please rephrase your question, remembering that most potential respondents
can't see your set-up and rely solely on what you write!
 
We have a table with two fields, DeliveryNo and PartNo.

Usually you have the DeliveryNo and all the parts No
within that delivery but in this case each record have the
DeliveryNo and one PartNo. So we might end up with couple
of record with the same DeliveryNo but different PartNo.

Now they want me to write a query to just show one of the
DeliveryNo and have all the PartNo in front of it.

Sorry about last MSG having a bad day mates.
 
Make a Form dependent on the query. Put the DeliveryNo in
the Form Header section, and the PartNo in the
Detailsection. Using the form, you can format the results
to appear any way you want it.
-Jim
 
Back
Top