Sequential number in a query

[mattc66 via AccessMonster.com]

Hi All,

I am working on a YTD Sales report. I would like to know if I can create a
cell in a query that will be a squential number. Starting with 1 on up. If so
how would I do this?

Report would look something like:
Num Customer YTD Sales
1 Bobs Sales 495,000
2 Denny's 395,000
3 Biffs Supply 390,000
4....

 

[Guest]

You can use a text box in the report:
Control Source: =1
Running Sum: Over All

 

[mattc66 via AccessMonster.com]

Not sure I understand. I don't want to do it on a report. I'd like to do it

You can use a text box in the report:
Control Source: =1
Running Sum: Over All

Hi All,

[quoted text clipped - 8 lines]

3 Biffs Supply 390,000
4....

 

[Guest]

My suggestion was based on your comment "Report would look something like:"

If you want this outside of a report, you must identify a unique field that
provides the numbering order. Then you can use this field in a subquery or
DCount() expression.

--
Duane Hookom
Microsoft Access MVP

Not sure I understand. I don't want to do it on a report. I'd like to do it

You can use a text box in the report:
Control Source: =1
Running Sum: Over All

Hi All,

[quoted text clipped - 8 lines]

3 Biffs Supply 390,000
4....

--
Matt Campbell
mattc (at) saunatec [dot] com

Message posted via AccessMonster.com