Invoice +1 in Query for Report

A

andrena

I am running several reports from the same query (I change paramater
within the query then run the report). I want to be able to create a
invoice number and increment it by one every time I run a report. I'
guessing I need to create an entry into the query that does this an
then connect this to the report. What entry do I need to make in th
query? Or how do I go about this?

Thanks In Advanc
 
M

Marshall Barton

andrena said:
I am running several reports from the same query (I change paramaters
within the query then run the report). I want to be able to create an
invoice number and increment it by one every time I run a report. I'm
guessing I need to create an entry into the query that does this and
then connect this to the report. What entry do I need to make in the
query? Or how do I go about this?
Click to expand...


This sounds all wrong to me.

A report or its query is not the place to be setting an
invoice number. This is normally the job of the form where
the invoice data was entered.
 
Top