Incrementing nrs in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a table with: Id (autonumber), Inv_Nr (text), Amount (currency),
Payment type (text/lookup). Payment type can be Ca, Chq, CC, Comb. I need
to create a query which will bring in ALL (say) cash transactions and give
each transaction a number incrementing from 1, similar to an AUTONUMBER
field. I require the first autonumber field to be present because I need the
transactions to list as they were entered. I need the second set of numbers
to be consecutive so I can then do a calculation on that field tp keep groups
of records together to be sorted in a form.

Any help would be greatly appreciated,

Thanks
 
Returning a sequential number is possible, but rather difficult to perform,
unless you are familiar with VBA, and calling functions from a query.
 
Thanks :(

[MVP] S.Clark said:
Returning a sequential number is possible, but rather difficult to perform,
unless you are familiar with VBA, and calling functions from a query.
Click to expand...
 
Back
Top