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...

I have a word document with a table of 6 exact cells on a full page table. In those cell areas I have been printing tickets with a list and a mail merge and updating labels. I call to an excel list of 1-2000 and then I generate all the pages through the Finish and Merge option. This all works perfect. I get 2000 individually numbered tickets to print...however...I then have six tickets printed on a page of paper with ticket numbers 1, 2, 3, 4, 5 ,6 then the next page has 7,8,9,10,11,12. This is fine but I then have to cut and stack these tickets in groups of six and at that point none of the numbering is sequential. The tickets are basically random.


The partial sums themselves form a sequence {\displaystyle (S_{N})_{N\in \mathbb {N} }} , which is called the sequence of partial sums of the series {\displaystyle \sum _{n=1}^{\infty }a_{n}} . If the sequence of partial sums converges, then we say that the series {\displaystyle \sum _{n=1}^{\infty }a_{n}}  is convergent, and the limit {\displaystyle \lim _{N\to \infty }S_{N}}  is called the value of the series. The same notation is used to denote a series and its value, i.e. we write {\displaystyle \sum _{n=1}^{\infty }a_{n}=\lim _{N\to \infty }S_{N}} .

This will work OK for a small set of data, but the more data there is, the more intensive the subquery becomes, and it must be called repeatedly for each row. This is one of those rare cases where doing it in VBA is faster than doing it in SQL — after all, row numbering is fundamentally iterative, not set-based which just goes against the grain of what SQL was designed to do – solve a problem in a set-based fashion, non-iterative fashion.
I want to have textbox with 2 columns with footnotes running across the bottom of those columns in one column. ID CS3 footnotes can’t handle this. So I have added fake footnote refs in the doc. using this idea. Now the footnotes themselves I can create in another text frame and use this idea again to create them and then manually place them at the bottom of the page. The only problem however with this is the FN options carrry across the whole doc. right? So even if I create a second doc for the footnotes themselves with different options and then later paste it into the main doc it’ll get messed up right?
Angie, have tried your method; however, I encountered what I surmised was a limit on the amount of characters allowed in that “Enter formatting for number” box: for instance, I can only type as far as “Request for Productio” (excluding quotations)- additional text and codes delete and default back to the incomplete phrase “Request for Productio”. Seems to have a default of 26 characters – anything exceeding that is deleted. The phrase “Request for Admission” completes, but am unable to include anything after that phrase of 26 characters. Not sure why that is, but that’s what I run into when I attempt using the multi-list option.
we have printed AP checks using the check number from 0000000001 to 0000000006, but we havent posted those batches. we have only one checbook. Now can we restart the check number from 000001. Then do we need to delete the previous batches for checks printed. What is the best approach in this regard. Thanks in Advance, Arun. In the Post Payables Checks batch window (Transactions > Purchasing > Post Checks), choose the batch in question, then select Reprint Checks from the drop-down list. Enter 000001 for your starting check number. You will also need to go ...
If you are thinking of using sequential numbering, please give our printing experts a call for helpful advice on how to best set up your artwork. We offer ready to use templates for the most common types of forms including invoice templates, statement templates, work order templates and purchase order templates. Just upload your logo and contact information and let us know how you would like to number your forms.
×