Creating a Sequential Record Number field?
367993
Make the PK column an IDENTITY column.
777528
just extract the 1st one and the rest will follow automatically. It's in-built.
847711
I'm not sure I completely understand your question, but it looks as if you are trying to implement a primary column that will automatically increment.\n\nIn MS SQL Server, this is done using identity specification. Read the following for more information:\n\nhttp://www.dbazine.com/sql/sql-articles/charran7
1156931
I think that Mp3 Advanced Catalog can support such counting. it can organize your music and TAGs
632590
select * from user_sequences
784795
numbering pages beginning from 1 in ascending order
482701
"mode"\n"display digits"\n"float 12" (or however many you want - 12 is the highest)
246287
The field names do not matter. It is the types that matter. For instance, you cannot copy a string (e.g. "abc") to a number field. Also, certain autogenerated fields should not be copied.\n\nI am not sure what you mean by dynamic, but the kind of query you would use looks something like this:\nINSERT INTO Table2 ( Field7, Field8, Field9 )\nSELECT Table1.Field1, Table1.Field2, Table1.Field3\nFROM Table1;
348618
Assuming you already have an autonumber column, open your report in Design view.\n\nMake sure you can see the design toolbox (View --> Toolbox should be checked on)\n\nIn the Detail section of your report, add a textbox (using the textbox tool from the Toolbox) where you would like the record number to show up.\n\nOnce you have drawn your textbox, right-click on it and select Properties.\n\nIn the Control Source field under the All tab, choose your autonumber field from the pull-down menu.\n\nThat should do it.
254134
I believe Access SQL supports the TOP keyword as below.  This will allow you to easily limit the number of records.\n\nSelect TOP field1, field2, field3\nfrom mytable1 m1 left join mytable2 m2\n on m1.field1 = m2.field4\nwhere field1 = 'value'
277641
A relational way of doing this is to create a Cards table with everything BUT set.  Then create a second table named something like Cards_Sets.  This can contain the following fields.\n\ncard name\nset\n\nSo your APPLE would contain one record in the Cards table and 5 records in the Cards_Sets table.   The ORANGE would contain 1 record in both tables and NUTS would contain 1 Cards record and 2 Cards_Sets records.   This is a one to many relationship.\n\nA simple select to display connected data from both tables would be:\n\nSelect * from Cards c, Cards_Sets cs\nwhere c.CardName = cs.CardName
58836
There are several ways you can approach this. I would suggest the quickes way is if you can, to categorize your table alpabetically, then have your search jump to that alphabet number - you can use a bookmark link (using #green) to jump straight to it. Otherwise you could try some kind of JavaScript search, but you would have to know JavaScript to make that work. \nHope this helps.
844755
Well, you did not say what program/version that you're using, so I'll assume MS Word 97.  Please give us more information the next time you ask questions, so we can help you more efficiently and not guess as the attributes of each program may be different between versions and programs.  Someone may even report your question as being not understandable.\n\nField codes: NoteRef field\n\n{ NOTEREF Bookmark [Switches] }\nInserts a footnote or endnote reference mark that you've marked with a bookmark to make multiple references to the same note or to cross-reference footnotes or endnotes. If you modify the sequence of footnotes or endnotes, the new result of the NOTEREF field reflects the new numbering.\n\nInstructionExplanation\n BookmarkThe name of the bookmark that refers to the footnote or endnote reference mark. The bookmark must refer to the reference mark in the document text, not in the footnote or endnote window. If the bookmark doesn't exist, you must create it.\nSwitches\n &#92;f Inserts the reference mark with the same character formatting as the Footnote Reference style or the Endnote Reference style.\n&#92;hInserts a hyperlink to the bookmarked footnote.\n&#92;pInserts the relative position of the footnote or endnote.·If the NOTEREF field appears in the document before the bookmark, it evaluates to "below."·If the NOTEREF field appears after the bookmark, it evaluates to "above."·If the NOTEREF field appears within the bookmark, an error is returned.This switch can also be used in conjunction with the &#92;n, &#92;r, and &#92;w switches. When this is done, "above" or "below" is appended to the end of the field result.\nExample:\n\nThe following text and field appear in a footnote of a document. The bookmark "Brun" marks the footnote reference mark for footnote 3:\n\n"This process is discussed in Brun's new book (see note { NOTEREF Brun } )."\n\nWhen the field is updated, the footnote number is displayed: \n\n"This process is discussed in Brun's new book (see note 3)."\n\nNote   The NOTEREF field replaces the FTNREF field used in earlier versions of Word for Windows. If you open a document that contains FTNREF fields, the fields remain in the document and function correctly.
753480
You should be able to create a field whose value is "=[laterdatefield]-[earlierdatefield]"  Replace the information inside the brackets with your field names.
10408
for this u can do one thing thatu will go database menu and click show sql query and add where\n 'Field name ' = today or now as per as ur requrement.
264388
I would like to be able to do # of answers AND date in a quick fashion.
371570
Yes, one way way you can reset an autonumber in Access is to truncate the table -- which destroys all data in the table.\n\nCreate a query in design view, switch to SQL view and enter this text:\n\nTRUNCATE TABLE tablename\n\nExecute the query using the red exclamation point icon; Access will ask if you really want to do it. Again, truncating will destroy all data in the table! Your structure will remain intact, but the data is irretreivably destroyed.\n\nYou could also do it programmatically if you don't have any records in the table, but if that's the case, TRUNCATE makes more sense.