Receipt No.

[xion.hack]

Hello. I am making a report that has a Receipt No. The Receipt No has to start at 10200 and continue going up as I print. How can I do that? Thanks!

 

[HiTechCoach]

Hello. I am making a report that has a Receipt No. The Receipt No has to start at 10200 and continue going up as I print. How can I do that? Thanks!

I normally do not create a receipt number in the report. I would have the receipt number calculated and stored in the tables. This way you have a record of the receipt number and can reproduce the report.

 

[boblarson]

I normally do not create a receipt number in the report. I would have the receipt number calculated and stored in the tables. This way you have a record of the receipt number and can reproduce the report.

Amen to that!

 

[xion.hack]

For my purposes, I just need it in the report. How can I?

 

[gemma-the-husky]

what about the next report - what does that start at?

 

[xion.hack]

It should start with the next number

 

[xion.hack]

Im not using forms, just the tables and the reports. Can anybody help me?!

 

[HiTechCoach]

Im not using forms, just the tables and the reports. Can anybody help me?!

Since you arew n lot using a form, then you can:

1) manually enter the Receipt numbers in a field in the table

0r

2) in a code module, write a function to create a receipt number and store it in the table
- you can manually call this function
- add VBA code to the report's on open event to call the function

If it were me, I would use a form for data enter that automatically generates the receipt number when the data is enter.

I will see if I can find a code example ...

 

[HiTechCoach]

All the examples I have use a form.

Here is one I would recommend:

UtterAcess.com - How to Create an Incrementing Record Number

I have attached it here for your convenience ...

 

[Mike375]

Im not using forms, just the tables and the reports. Can anybody help me?!

If you are going to develop your data base to any extent I would strongly suggest using forms. If you can make a Report you are aleady part of the way there as Reports and Forms are kissing cousins.

 

[gemma-the-husky]

so if your first report has numbers 10200 to 10220 say, then for your next report to start at 10221, you HAVE to have this info available somehow - either ask for it, or store it a table, or on the registry etc etc

 

[thatlem]

Why not just add the autonumber to the report header? That way it will track back to the entry and by placing in the header, you avoid going through the field in data entry....