I print a report of order detail from the order form with a button, which is
OK, but the strange thing is, the order of the products printed is just the
opposite from that of the order detail subform, e.g, if there are 3 products
in subform ordered by product number as "1001", "1002" and "1003", then what
is on the paper is: "1003", "1002", "1001"¡£
What is the problem? Many thanks in advance.
Paul 2 1190
Open the report in design view.
Open the Sorting And Grouping dialog (View menu).
In the dialog, enter the name of the field you wish to sort by.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Paul T. Rong" <et***@hotmail.com> wrote in message
news:N7*********************@news.chello.at... I print a report of order detail from the order form with a button, which is OK, but the strange thing is, the order of the products printed is just the opposite from that of the order detail subform, e.g, if there are 3 products in subform ordered by product number as "1001", "1002" and "1003", then what is on the paper is: "1003", "1002", "1001"!#
It works. Thanks, Allen.
"Allen Browne" <Al*********@SeeSig.Invalid> дÈëÏûÏ¢ÐÂÎÅ
:41**********************@per-qv1-newsreader-01.iinet.net.au... Open the report in design view. Open the Sorting And Grouping dialog (View menu). In the dialog, enter the name of the field you wish to sort by.
-- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org.
"Paul T. Rong" <et***@hotmail.com> wrote in message news:N7*********************@news.chello.at...I print a report of order detail from the order form with a button, which is OK, but the strange thing is, the order of the products printed is just the opposite from that of the order detail subform, e.g, if there are 3 products in subform ordered by product number as "1001", "1002" and "1003", then what is on the paper is: "1003", "1002", "1001"!#
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: intl04 |
last post by:
I am getting strange print-related error messages when trying to
create (not print!) reports. For example, when I click 'new' to create
a report then choose 'design view', I get an error message...
|
by: Martin Joergensen |
last post by:
Hi,
I've encountered a really, *really*, REALLY strange error :-)
I have a for-loop and after 8 runs I get strange results...... I
mean: A really strange result....
I'm calculating...
|
by: Ron |
last post by:
Hi,
I know Access allows for easy construction of a report setup to print labels
from a table/query, etc. I've done that one. It works pretty well for what
I need.
However, is there an...
|
by: John Smith |
last post by:
Hello, I have 7 different crystal reports that need to be collated.
Since I want to end up with a page of each (which all together make a
single report), I created a blank main report and then...
|
by: Brad Pears |
last post by:
I have a vb.net 2005 application and am using the print preview screen. This screen has a printer icon on it that the user can use to print the document currently being viewed. It uses the default...
|
by: Brett |
last post by:
I have an ASP.NET page that displays work orders in a GridView. In that
GridView is a checkbox column. When the user clicks a "Print" button, I
create a report, using the .NET Framework printing...
|
by: Deceneu |
last post by:
Hi everyone, this is my first post so please bear with me.
I have the following situation: i have a local report that needs to have two "versions": one for viewing in the report viewer (with all...
|
by: Glenn |
last post by:
I am writing a program for field work that will use a receipt
printer. I need to be able to adjust the page settings prior to
printing depending on how much needs to be printed. I have been able...
|
by: it0ny |
last post by:
Hi guys,
thanks I am fairly new to this forum so I hope I chose the right place to post this question.
I try to make my program printout a deposit's report. I created a class to store the...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
| |