Complicated Query!!

[Avick]

This is a little complicated so I am not sure t can be done!!!

I have a query that lists 40,000 records with some being sent to label printing
The query breaks the records down so that any record with a Qty greater then 17 will be sent to a second query for a different label to be attached.

I then end up with two Queries
Query 1 is =<17
Query 2 is >17

Records less then or equal to 17 are sent for standard label printing.


Here is my problem:

Any record with a Qty field reading less the 3 or 4 I want them to print 3 or 4 of the same label. For example

Jane doe (Qty 6) this will print 1 Jane Doe label
Joe Bloggs (Qty 3) this will print 3 Joe Bloggs labels

Am I trying to do something that just can’t be done!

When this is complete all information will be exported to a CSV file.

 

[statsman]

You could add a third and fourth query.
Change Query2 to >4
Query 3 would be =3 Or =4
Query 4 would be =1 Or =2

 

[Avick]

I had considered this but I think this would complicate things unnecessarily.

I had considered using an array controlled by a button on a form that would create 3 records out of 1. or 4 records out of 1

What I would like to do is carry out all these calculation then rejoin everything in a new query which in turn will give me my labels or CSV File