I am currently reading up on this, but wanted others input on it as well.
I am trying to create a report for pricing history for an item. I am going to have a form with a text box, then use the value entered in the text box passed into some VBA as a string to search my product table to return all products matching the entered value. So a user could enter "LCA" an all items containing (I will probably do starting with) "LCA" will be returned. I then want to show all pricing for that item to populate the report. So every match of "LCA" will appear on the report along with that records price.
At the very top of the report, I would like to have a lowest, highest and average then the details would be all instances of the item and its price. This report will almost never be printed, so an argument could be made to just make this a form, but I could foresee someone wanting to print just the first page. So with that in mind, I think a report would be a better fit.
Would I just use text boxes and put formulas in them? Such as Min, Max, Avg?
I am trying to create a report for pricing history for an item. I am going to have a form with a text box, then use the value entered in the text box passed into some VBA as a string to search my product table to return all products matching the entered value. So a user could enter "LCA" an all items containing (I will probably do starting with) "LCA" will be returned. I then want to show all pricing for that item to populate the report. So every match of "LCA" will appear on the report along with that records price.
At the very top of the report, I would like to have a lowest, highest and average then the details would be all instances of the item and its price. This report will almost never be printed, so an argument could be made to just make this a form, but I could foresee someone wanting to print just the first page. So with that in mind, I think a report would be a better fit.
Would I just use text boxes and put formulas in them? Such as Min, Max, Avg?