Report Number

[cfobare79]

I have created a report. Every time the report is generated I would like a report# to be shown. I would like it to be displayed like this: OSC-20150404-001 so that the first 3 characters is the AgencyID followed by the date and then the sequential number of the report for that day. I also would like to find out how I can save my query results that created the report. Thank you very much for your time.

[ranman256]

You would need a table to track the report for each day..
agcy
date
rptCount. (Integer)

increment the count each time you print. Read the Agency off a form.
Another box to assemble them all...
txtRpt = cboAgcy & format(txtDate,"yyyymmdd") & "-" & txtCount

[cfobare79]

I'm not sure how the data from the report will populate the Table. I also am not sure where you put the formula.