Simple Report Number

[Accessosaurusrex]

My apologies as I am no VBA programmer. I am simply trying to add a report number to a header on a report. The report number should sequentially change each time the report is generated. I have followed about two days worth of effort based on the other submissions on this website and have been unsuccessful. Most of them point to adding a text box and in the box have it =1 then go with an overall running value. That works great if I were numbering the records in the report but I am not.

I simply want to create a report and have it number itself in the header. I have created a table called ReportNo and a field within called RptNo. I just don't seem to be able to get the table to update with the latest number once the report is run.

Thank you for any help you can give me.

 

[pbaldy]

In the same code that opens the report:

CurrentDb.Execute "UPDATE TableName SET FieldName = FieldName + 1"

 

[Accessosaurusrex]

Well that was embarrassingly simple. I don't think I have seen that in any of the other posts on here, but the screen may have gone blurry after a lengthy search... That is my story and I am sticking to it.

Thank you very much for your help.

 

[pbaldy]

No problemo, and welcome to the site by the way!