Avatar of hgj1357
hgj1357

asked on 

MS Access acoutput reports based on table data

I have table of invoice numbers like this:

BillingInvNum
19-563-00-3
19-570-00-2
19-575-00-5
20-511-00-1
...
I have a report that can filter on any of these invoice numbers and print out said invoice.  I'd like to be able to Output to an RTF file for each invoice number.  ie.19-563-00-3.rtf; 19-570-00-2.rtf etc.

So essentially I need to cycle through the entire (approx 56) invoice numbers and for each one use

DoCmd.OutputTo acOutputReport, "Invoice Complete duplicates", acFormatRTF, "XXX.rtf"

where XXX is the relevant invoice number from the table.

Thanks
Microsoft Access

Avatar of undefined
Last Comment
hgj1357

8/22/2022 - Mon