Hi, As a new user to excel I am thinking of setting up a data base of my music. The total number of tracks is in excess of 70,000. I have seen a simple solution using excel which would be ok but I'm not sure if I can have 70,000 rows in one work sheet. A friend has suggested access which I am not familiar with and don't know if this will allow 70,000 entries. Can anyone please tell me what the maximum numbers are in both access and excel 2003. Cheers Glinty Max in Excel 2003 is 65536 (in one sheet) whereas Access only limit is your memory -- Regards, Peo Sjoblom ...

This tip was very helpful. Now I have been able to automatically number dozens of examples in a linguistics paper, and as I revise the paper and insert new examples between the existing examples, the numbering is automatically adjusted. Now the next step is how to use bookmarks for the references to the examples in the text of the paper. The references need to point to specific examples, and need to be automatically adjusted when the numbering of examples is adjusted. Any ideas on how to do this?


There’s an old Steve Martin joke about how to make a million dollars which starts, “First, get a million dollars…” That’s the key to this trick, too: First, get a bunch of numbers. Here’s a file with 1,197 numbers in it. Now import or paste those numbers into a thread so that the numbers appear in the right place. If you need two matching numbers, just import it twice.
I have been generating 150-400 page reports with multiple lists in tables. Word's auto numbering would only go so far in applying sequential numbering but then it just stops and I could not use it any more. I had to manually type in the numbered list which was quite annoying and very time consuming. Then I came across your Word Tip. Awesome! It worked. Thanks so very much.
Hi All, I am working on a YTD Sales report. I would like to know if I can create a cell in a query that will be a squential number. Starting with 1 on up. If so how would I do this? Report would look something like: Num Customer YTD Sales 1 Bobs Sales 495,000 2 Denny's 395,000 3 Biffs Supply 390,000 4.... -- Matt Campbell mattc (at) saunatec [dot] com Message posted via http://www.accessmonster.com You can use a text box in the report: Control Source: =1 Running Sum: Over All -- Duane Hookom Microsoft Access MVP "mattc66 via AccessMo...
Using this script… no. While I use the data merge feature of InDesign often, I avoid the “multiple records” feature, but I typically prepare one record on one page, output the resulting file to PDF and then let the imposing software take care of the page imposition. If page imposition software is something that you don’t have, there is an alternate technique that requires preparing one record on a page, and then using the multipageimporter2.5 script to import them onto a larger sheet. Here is the link to that article: http://colecandoo.com/2011/10/28/theres-more-than-one-way-to-cut-and-stack/
Hi everybody. I am having a problem with a query that I am working on. I have a table containing customer names, trade dates, and dollar amounts. Customers can have multiple trades on the same day, sometimes even the same dollar amount. I want to have the table sorted by name, date, then dollars so the query pulls everything in from lowest/earliest to highest/latest. I was trying to make a query that pulled in the customer name and trade dates, then added a new column called "Row" that had the record number. I want the query to show all names and dates, since there are ...
If you know in advance that you need outline numbering for your paragraphs, you will want to choose the correct format from the Bullets and Numbering dialog box. Applying one of the preset formats to a paragraph or paragraphs that are already bulleted or numbered applies it to the entire list. There is a specific tab for outline numbers — the Outlined Numbered tab.
Hi All, I am working on a YTD Sales report. I would like to know if I can create a cell in a query that will be a squential number. Starting with 1 on up. If so how would I do this? Report would look something like: Num Customer YTD Sales 1 Bobs Sales 495,000 2 Denny's 395,000 3 Biffs Supply 390,000 4.... -- Matt Campbell mattc (at) saunatec [dot] com Message posted via http://www.accessmonster.com You can use a text box in the report: Control Source: =1 Running Sum: Over All -- Duane Hookom Microsoft Access MVP "mattc66 via AccessMo...
How do I set up the basic template for text numbering in Word 2008 for the Mac? Here is what is driving me nuts: I want to generate numbered lists - lots and lots of them. The first level numbered lines will have second level under them in many cases, also numbered and indented below the first level. The second level will also have third level under them, intended some more and also numbered. This "sort-of" works fine. It USED to work excellently. Here is what I do. I click the Numbering button in the Bullets and Numbering palette. The line indents and a 1) is aut...
Hello Bruce, I seem to be having a different problem altogether. I created my ticket in word using logos and text boxes as needed, ticket looks great. I followed your very clear instructions but when I did the Finish & Merge I got this message, "You cannot include DATA, NEXT, NEXTIF, or SKIPIF fields in comments, headers, footers, footnotes or endnotes." I then click on OK and get this, "A field calculation error occurred in record 1. Bruce any help would be much appreciated. Thank you!!
CK Note: Word 2007 - 2013 interface has an different automatic numbering scheme which I have been told is much less subject to corruption. Microsoft Word 2010 Bible by Herb Tyson, MVP. However numbering is still very imperfect in these later versions. I still recommend following Shauna Kelly's step-by-step instructions (see above) if setting up numbering in a template or in a document likely to be heavily edited. If you start without doing this and end up with "spaghetti numbering," fixing it will be a very large chore!
CK Note: Word 2007 - 2013 interface has an different automatic numbering scheme which I have been told is much less subject to corruption. Microsoft Word 2010 Bible by Herb Tyson, MVP. However numbering is still very imperfect in these later versions. I still recommend following Shauna Kelly's step-by-step instructions (see above) if setting up numbering in a template or in a document likely to be heavily edited. If you start without doing this and end up with "spaghetti numbering," fixing it will be a very large chore!
Law firms use numbered lists daily to prepare contracts, pleadings, letters and memos. Word makes activating and customizing numbering fairly straightforward. You can create simple numbered lists, such as A, B, C and 1, 2, 3. You can also customize these lists to setup specific numbering styles for your firm and practice group. Multilevel lists such as I, A, 1 are handled through Word's Outline Numbering feature, which is explained later in this chapter. Many firms rely on outline numbered lists to draw up contracts and pleadings. Like numbered lists, outline numbered lists can be customized.
Instead of working harder than you need to, insert a one-column table with as many rows as necessary to accommodate your list. Then, using Word's numbering feature, number that column. Finally, convert the table to text. The resulting list is a fixed numbered list, so you'll have to live with its limitations; when you can do so, this method definitely beats most alternative solutions.

When the “Current Page Number” placeholder sits on a master page, every page to which you assigned that specific master page will display this variable – the number will change automatically on every page. If you change the style assigned to the placeholder on the master page (let’s say you set it to bold), all page numbers will update to that style (all numbers will become bold).

×