Re: sequential query record numbering

I was too quick on the answer. This returns the record number from the
table, not sequential in my query. D'oh!

-JS

"DevourU" <devouru@xxxxxxxxxxx> wrote in message
news:G0Rbf.11398$7h7.5665@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>I figured it out!
> tick: DCount("field1","ABC Table","field1 <='" & [field1] & "'")
>
> -JS
>
> "DevourU" <devouru@xxxxxxxxxxx> wrote in message
> news:9mQbf.9572$BZ5.7009@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>> Viewing a query will show record number and total records in the record
>> navigator. Can I show the record numbers in the record itself? I have no
>> uniqueid to work with. I just need to have a
>> autonumber/sequential/incrementing column. Help? TIA
>>
>> -JS
>>
>
>


.

Relevant Pages

  • Re: Query returning multiple rows
    ... >I have a query that returns back rows that have multiple entries for a given ... >UniqueID Name Date ... Prev by Date: ...
    (microsoft.public.sqlserver.mseq)
  • Query returning multiple rows
    ... I have a query that returns back rows that have multiple entries for a given ... UniqueID Name Date ... Prev by Date: ...
    (microsoft.public.sqlserver.mseq)
  • Re: Identifying fields out of order
    ... Click on "Create Query in Design View" ... tblSeq AS Prev, tblSeq AS Next; ... Our SQL now would look like: ...
    (microsoft.public.access.queries)
  • Query based on Column Index
    ... I have attached the sql to a query that I have developed. ... regarding the TraitHistory fields. ... Prev fields from my table and update the query. ... query determine the Curr and Prev based on their position in the table. ...
    (microsoft.public.access.queries)
  • Re: Multiple field query
    ... > I need a query that will give me single column list produced from all 20 ... > the opeation fields. ... EdS ... Prev by Date: ...
    (microsoft.public.access.queries)