|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Numbering Table Lines in AccessHow do I add line numbers to a Make Table in Access?
Is there a function that I can add to the make table query that will number the lines automatically? *** Sent via Developersdex http://www.developersdex.com *** Not sure what a "make table" is, but see if http://www.aspfaq.com/2427
helps. Show quote "Lesley Doody" <leslie.do***@ge.com> wrote in message news:%23xJDjZxgFHA.3936@tk2msftngp13.phx.gbl... > > > How do I add line numbers to a Make Table in Access? > Is there a function that I can add to the make table query that will > number the lines automatically? > > *** Sent via Developersdex http://www.developersdex.com ***
FYI:
Access calls this a "Make Table Query": SELECT [some columns] INTO Foo FROM Bar (But, of course, in Access, the syntax is really strange) -- Peace & happy computing, Mike Labosh, MCSD "Mr. McKittrick, after very careful consideration, I have come to the conclusion that this new system SUCKS." -- General Barringer, "War Games" Hi
If this is only for display purposes then your Front End application should be assigning this number. John Show quote "Lesley Doody" wrote: > > > How do I add line numbers to a Make Table in Access? > Is there a function that I can add to the make table query that will > number the lines automatically? > > *** Sent via Developersdex http://www.developersdex.com *** > Wazup with all the MS Access quations here lately? Try posting to one of the
many microsoft.public.access* groups. Show quote "Lesley Doody" <leslie.do***@ge.com> wrote in message news:%23xJDjZxgFHA.3936@tk2msftngp13.phx.gbl... > > > How do I add line numbers to a Make Table in Access? > Is there a function that I can add to the make table query that will > number the lines automatically? > > *** Sent via Developersdex http://www.developersdex.com *** Good point, I was assuming they were in Access, and calling the query from
SQL Server... I guess I shouldn't make such bold assumptions. :-) Show quote "JT" <some***@microsoft.com> wrote in message news:OpPb2zxgFHA.3540@TK2MSFTNGP12.phx.gbl... > Wazup with all the MS Access quations here lately? Try posting to one of > the > many microsoft.public.access* groups. Perhaps she is querying or linking from SQL Server, but "Make Tables" and
"Table Lines" sounds like something peculiar to the MS Access designer. Show quote "Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message news:ulEtx6xgFHA.3788@tk2msftngp13.phx.gbl... > Good point, I was assuming they were in Access, and calling the query from > SQL Server... I guess I shouldn't make such bold assumptions. :-) > > > > "JT" <some***@microsoft.com> wrote in message > news:OpPb2zxgFHA.3540@TK2MSFTNGP12.phx.gbl... > > Wazup with all the MS Access quations here lately? Try posting to one of > > the > > many microsoft.public.access* groups. > > > Perhaps she is querying or linking from SQL Server, but "Make Tables" and Not to beat a dead horse but, arguably, a Make Table could just as easily be > "Table Lines" sounds like something peculiar to the MS Access designer. created from a linked query than internally, in fact more likely I would guess, since why would you need to make a table from a table that is already there. And "Table Lines" is a misnomer in any database, so I wouldn't say that it indicates or precludes any specific platform. IMHO. A > Wazup with all the MS Access quations here lately? Try posting to one of You should just quickly eyeball all the *wildly OT* stuff in > the > many microsoft.public.access* groups. microsoft.public.access. I wouldn't be surprised if Access guys post here just so their question doesn't get lost among all the posts about internet service, modems, device manager, word, excel, Adobe Acrobat, etc in the access group. That place is a freakshow. :-) -- Peace & happy computing, Mike Labosh, MCSD "Mr. McKittrick, after very careful consideration, I have come to the conclusion that this new system SUCKS." -- General Barringer, "War Games" Access is to SQL Server what Jerry Springer is to Firing Line.
Show quote "Mike Labosh" <mlab***@hotmail.com> wrote in message news:Oyw39AygFHA.3940@tk2msftngp13.phx.gbl... > > Wazup with all the MS Access quations here lately? Try posting to one of > > the > > many microsoft.public.access* groups. > > You should just quickly eyeball all the *wildly OT* stuff in > microsoft.public.access. I wouldn't be surprised if Access guys post here > just so their question doesn't get lost among all the posts about internet > service, modems, device manager, word, excel, Adobe Acrobat, etc in the > access group. That place is a freakshow. :-) > -- > Peace & happy computing, > > Mike Labosh, MCSD > > "Mr. McKittrick, after very careful consideration, I have > come to the conclusion that this new system SUCKS." > -- General Barringer, "War Games" > > > Access is to SQL Server what Jerry Springer is to Firing Line. LOL! OK, you got me on that one! That remark is practically a sig-block!-- Peace & happy computing, Mike Labosh, MCSD "Mr. McKittrick, after very careful consideration, I have come to the conclusion that this new system SUCKS." -- General Barringer, "War Games"  |
|||||||||||||||||||||||
Other interesting topics