Hi
I have a database where I can select certain items to view in reports print etc.
What I need is the following

I can currently select any item (in forms) to show in a report by using yes/no select box. Now is what I need is to be able to input into the form the amount of times I need the selection to show in the report.

In other words I want to be able to select and item and also have the option to input how many times I need it to display in a report



does that make sense? and can anyone help me...please
 duplicates.JPG ( 111.74K ) Number of downloads: 5

I don't see from the sample data why the line you mentioned would appear twice. If the idea is that if the user selects 2 the line would appear twice on the report, how are the two lines different from each other? If they are not different, what exactly does it accomplish to have it appear twice?

Hi Bruce first you must excuse me because im new to access, the 2 lines would be the same and the reason I need this information in a report is that they are all sellable items and our customer may purchase 2 (or 3) of the same machine.
The report gives details of power requirements etc that will need to be calculated for all selected machines in the final report.
Does that make sense?

This post has been edited by benclegg: Feb 6 2012, 08:00 AM

Is this an invoice or something of the sort? I don't understand why you would want two copies of a record rather than a quantity of two for a single record. Perhaps it would help if you describe a little more about the real-world situation, and include some information about the table structure and relationships.

At the foot of the report I have some calculations that give me total wattage (power) for the selected machines , this is why I need to show all individual items. In order to do the calculation.

Ok my main database has all aspects of the machines name, weight, supply voltage, power consumption of individual machine. these are some 300 machines in total

Im using a form with a check box to select certain machine I need in the final report
I then have a query showing the selected machines
Then I have a report that shows me individual information for each machine , with a total at the bottom for total power (wattage) for all the selected machine only
I need a way to print out a report that will give me my selected list of machines that may include the same machine more than once

I have a query to select certain machine but don't know of a way to show more than one of the same machine on the final report instead of an amount of the same machine.

Thanks Bruce

This post has been edited by benclegg: Feb 6 2012, 08:30 AM

Just to be clear on terminology, the database is the application you built with Access. That's what Access is: a tool to build database applications, rather than an application itself such as Word or Excel. Perhaps you mean the main table? Or is there only one table?


Then you should be able to add the quantity to each record and do something like this in the footer:

=Sum([txtQuantity]*[txtWattage])

You are selecting the quantity anyhow (on the form that opens the report), so you may as well make it available to the report.

I would think that if they are separate machines they would have different serial numbers, or some way to tell them apart.


It would help to know more about this query. If the other suggestions don't help, please post the SQL for the query.

This post has been edited by BruceM: Feb 6 2012, 08:57 AM