473,513 Members | 2,552 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

two options in the same report

23 New Member
Hi

I have a form which has two options invoice number and transaction date .
When I select the first option to display from a table by sorting invoice number and transaction date, after that I need to display the totals for each invoice number as invoice footer.
When I select the second option to display from the same table by sorting transaction date and invoice number , after that I need to display the totals for each transaction date, as date footer.

Is it possible to display both the above options in same report. I am using access 2000.

can anybody help... Please
May 16 '07 #1
1 1210
puppydogbuddy
1,923 Recognized Expert Top Contributor
One way you can do it is by setting the grouping and/or sorting Levels in code in response to selection made in a combobox as shown in the following link:

http://www.fabalou.com/Access/Reports/sortorder.asp
May 16 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
1974
by: George G. | last post by:
I am exporting a report to an Excel file. Whatever options I use for the formatting the results remain the same. I have set the ExcelTabHasColumnHeadings to true and false without any difference. I have set the ExcelUseConstantColumnWidth to true and thenset the width to different values and have seen no changes. The code I am using is shown...
3
2888
by: RC | last post by:
I can't quite grasp the concept of creating custom reports depending upon what options a user picks on a Form. For example, the user clicks on a "Print Reports" button and a Form pops up. On the Form the user can choose to get a report that shows the Box Numbers that are at Warehouse A, Warehouse B or Warehouse C. and then click on the...
2
1372
by: Jean-Claude Bertrand | last post by:
Hello to all .Net programmers! I am a consultant and I create very small application for small enterprise. Most of the time in my application, the number of users is under 5! I still program Windows apllication. Recently, I bought VS.Net (enterprise edition) but I have worries about having to spend more money with additional controls like...
1
2410
by: Stinky Pete | last post by:
Hi, I've been reading, and successfully tested some code referred to in this group, that allows a user to select a printer before printing a report. The code has worked well on single page reports, however I want to expand the logic and I'm getting lost. I've got a form that needs to be printed via multiple reports which print with the...
5
2205
by: consonanza | last post by:
I am working on a report filter form. It has 2 combo boxes (cmboSelectSubject and cmboSelectCategory) to select criteria. Selecting an entry in combo 1 restricts the options available in combo 2. The row source for combo2 is: SELECT DISTINCT tblComplaintCategory.fldComplaintCategory, tblComplaintCategory.fldComplaintCategoryID,...
1
1285
by: Jon1492 | last post by:
I've been trying to figure this out for a few hours now. I have an MS Access 2003 quote configuration tool that produces quotes based on about 100 different controls (including option groups, combo, list and text boxes, etc) that an end-user selects. I imagine that these controls will change in the future, so I want flexible 'what did the...
3
1731
by: jhh100 | last post by:
Hello.. I have Moderate Knowlege in Access but I'm stumped on how to figure out how to get this done.. I'll try to explain I'm trying to develop a access database that will manage engine arrangements for Caterpillar whereas, it would allow a custome to select parts that they want to include on an engine, and not allow customer to select...
0
924
by: =?Utf-8?B?QW5kcmV3?= | last post by:
I have an app( vb .net 2.0) that I am about to get into the reporting portion, the app has an access 2007 db, and have logo file stored in a directory on the computer (to save space in the database). I want to be able to show the logos at the top of the report. Depending on the options selected I want to be able to color code the report (text,...
11
1867
jinalpatel
by: jinalpatel | last post by:
Hello I am a novice to Access/VBA and this is driving me nuts. Any help would be appreciated. I have to create a little application which can print postcards(4"X6") based on following options: Customer Type OrderNumber LoggedDate Location
0
7397
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
7565
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7128
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7543
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5103
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
4759
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3255
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3242
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
473
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.