Print text based on criteria

  • Thread starter Thread starter Darren H via AccessMonster.com
  • Start date Start date
D

Darren H via AccessMonster.com

Hi all I hope you can help me.

I have a Query based on two tables to pull the information i need. For each
disposal advice there can be many Consignmentnumbers so it is on a one to
many relationship. What i want in the query is another column to show
"single" or "multiple" depending on the number of Consignmentnumber per
disposalAdvice. For example below

Disposaladvice(PK) Consignmentnumber(PK) Third column
Need to show
123 ABC
Single
987 XYZ
Multiple
987 LMN
Mulitple

How would i go about programming this preferably as simply as possible
(minimal sql please)as im no expert

Thanks in advance
Darren
 
Sorry that table didn't come out too well here it is again

Hi all I hope you can help me.

I have a Query based on two tables to pull the information i need. For each
disposal advice there can be many Consignmentnumbers so it is on a one to
many relationship. What i want in the query is another column to show
"single" or "multiple" depending on the number of Consignmentnumber per
disposalAdvice. For example below

Disposaladvice Consignmentnumber Third column Need
(PK) (PK)
to show
123 ABC
Single
987 XYZ
Multiple
987 LMN
Mulitple

How would i go about programming this preferably as simply as possible
(minimal sql please)as im no expert

Thanks in advance
 
Back
Top