Create a NEW calculated field that counts the query records

[Gicu]

Have a look at the updated file, I created a temp table (you will need to empty it and re-populate it everytime you need to run the report). Because the autonumbers will be out-of-synch after the delete\append cycles you need to use the ranking query approach to reset them to 1,2,3,... Or you can reset the autonumber seed programmatically after you emptied the temp table, then you can use the autonumber as your TREE_NUMBER: http://allenbrowne.com/func-ADOX.html#ResetSeed



Cheers,

[Gicu]

The query would have criteria as [ENTER PLAN] the user would enter the plan, N-1234 and the report would generate.

Yet on UtterAccess you post this:

If I stored all of these in a separate table instead of the query I wouldnt be able to do the autogenerated method, as how we have it now, its numbered for the one plan N-1234, but this is just one record, I would need it numbered for each plan like that, so If another plan came up, N-4567, and has 1,2, 3 records,

If you run the report one plan at the time than the last quote doesn't apply. And if you want to store all plans in the temp table then the ranking query approach would still work but you would need to reset the numbering for each plan:
https://stackoverflow.com/questions/...rouped-ranking
https://stackoverflow.com/questions/...roup-in-access

Cheers,

[pbDudley]

Thanks for the responses., I will attempt this today
The post from utteraccess, I meant what you stated, that the number would have to be reset for each plan.
Ill see what I come up with and post the answer if I can get it, thanks