Records duplicated based on field

[dskulman]

I have a subscription database that shows the # copies someone wants sent to them.



I want the query to create a record for EACH copy they want.

For some reason, the people that create the mailing labels say they can't use the # copies field, that I MUST output a record for each copy instead.

I don't know how to do this - CAN ANY BODY OUT THERE HELP ME?

Thanks - your humble servant
Bytesizegal

[orange]

How do you output records now?

Do you use vba?
(You must adjust with your table(s) and field names)

You could do something like
...
Dm NumCopies as Integer


Open RS("SELECT Person, address, CopiesRequired")
do WHILE NOT rs.eof
numCopies = CopiesRequired
For x = 1 to NumCopies
Write an output records for this client
next
rs.MOVENEXT

Loop

(untested, but should give idea of approach)

[dskulman]

I am running a query:

SELECT Subscriber_File.State, Subscriber_File.Zip, Subscriber_File.Subscriber_ID AS [Unique], Subscriber_File.ChKey, Subscriber_File.Last, Subscriber_File.First, Subscriber_File.Street, Subscriber_File.Address2, Subscriber_File.City, Subscriber_File.ExpDate, Subscriber_File.NumOfPapers, Subscriber_File.AcctRec_Code, Subscriber_File.Title
FROM Subscriber_File
WHERE (((Subscriber_File.ExpFlag)<>"Y") AND ((Subscriber_File.Subscriber_Type)="P")) OR (((Subscriber_File.Subscriber_Type)="B"));

Then I have a button on the switchboard that outputs the result to an Excel file and attaches it to an email message.

Can you tell by the SQL code in the query above how to create a module or something I can run from a macro from the switchboard to do this?

I am not much of a coder. The above code was the SQL view of the select query.

Thank you!

Donna

[orange]

It appears that Subscriber_File.NumOfPapersn is the number of copies for the
Subscriber_File.Subscriber_ID AS [Unique]

I suggest you should get more familiar with your situation. You will need to understand the data you are working with.
As for Access and some basics including vba, I recommend you watch the videos and read some of the text and examples here.

http://www.accessmvp.com/strive4peace/

Post back as necessary, but "working through some examples" is the best experience.