RE: seuential numbering in queries
titlepusher
Let's say I have 300 records returned in the query from the underlying table
of 4400 records.
I would like to see each returned record assigned a number starting with 1
and ending with ( 300 in this example)
looking like:
1 smith
2 jones
3 davis
4...
..n
What I am actually doing is just trying to make it easier to visually see
groups of 25 or less.... I have a mass-email routine/form that checks my
database displays the records for me to select and creates one email for the
selected group placing the addresses in the BCC. Some emails come back to me
rejected as spam .. too many as a group. So I thought if I could see the
grouping and then select those in blocks of 20 or so it would at least be
quicker than having to count them individually.
I'm not a coder.. but I can get in and out of it and follow logic trails
and swap variable names etc... but cannot write it and don't do SQL worth a
crap either...
I say this because I know there are probably better solutions to break the
querry down and generate 20 emails of 20 names,instead of 1 of 400, but I'm
certain they are too complex for me, so I figured just counting would suffice.
thanks,
tp
"scubadiver" wrote:
>
> What do you mean by "sequentially number"?
>
> --
>
> The 11th day of every month:
>
> http://truthaction.org/forum/index.php
>
>
> "titlepusher" wrote:
>
> > I have a simple query.. no joins... one table CAN I create a field in
> > the query that will sequentially number and display (temporarily each time
> > qry is run) I don't need to manipulate it... just see it.
> >
> > tx