Re: SQL & VB

Tech-Archive recommends: Speed Up your PC by fixing your registry


"cnlai" <cnlai@xxxxxxxxxxxx> wrote in message news:4536C54C.A7AEF4A@xxxxxxxxxxxxxxx
Is it possible to generate a recordset of running numbers (ie 1, 2,
3...) using SQL statement ?

I am using MDB file.


When I display a report (Datareport), I want to number the records
starting from 1.

Often my record source is an SQL statement. Currently I have to create a
table to hold records for reports, and an additional field to hold the
running number. Before I display a report, I have to enter a running
series in that field. I think it ia quite a chore.

Is there a better method ?


Does your current method work? If so, stick with it.

This doesn't mean there isn't a better way to achieve the same result, but to provide help in that, we'd need to know much more information about your program, the database, your code, etc.

--
Mike
Microsoft MVP Visual Basic

.

Relevant Pages

  • RE: Splitting an Access Database into fe/be-bcuz db too large 1.6
    ... record source property only to find out that I might have to put them all ... Private Sub Form_Unload ... A few small images on forms and/or reports generally works ok. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Cant Add Fields to Form
    ... Look at the Record Source property of the form. ... the SQL statement or the saved query before they will be visible to the ... "Jeff Miller" wrote in message ... Hoping I'm posting to the right newsgroup. ...
    (microsoft.public.access.forms)
  • =?UTF-8?B?UmU6IEJhc2luZyBhIGZvcm0gb24gU1FMIGFzIG9wcG9zZWQgdG8gYSA=?= =?UTF-8?B?dGFibGUgb3Igc
    ... If the SQL statement that you are passing to the forms record source is not updatable then the data in your form will also not be updatable. ... A pass-through query sends commands directly to ODBC databases, such as Microsoft FoxPro, using commands that are accepted by the server. ...
    (microsoft.public.access.formscoding)
  • Re: Critique of Robert C. Martins "Agile Principles, Patterns, and Practices"
    ... make sure that a well structure SQL statement was used against a ... well-normalized database. ... All our reports have been implemented as stored procedures and have been meticulously crafted to perform well and balance to other reports. ...
    (comp.object)
  • Re: Calculations on report...
    ... I would rather not guess which of these are controls on reports or fields in ... a report's record source. ... The first check is to see if there was an RRSP contribution. ...
    (microsoft.public.access.reports)