Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 06-05-2019, 08:36 AM
zephyrus17 zephyrus17 is offline Generate custom report based on user selection? Windows 10 Generate custom report based on user selection? Office 2019
Novice
Generate custom report based on user selection?
 
Join Date: Jun 2019
Posts: 2
zephyrus17 is on a distinguished road
Default

Quote:
Originally Posted by Logit View Post
Excel vs Access .... kinda like do I buy a Chevrolet or a Ford ?

Having said the above, there will be those who will post their responses here with a list of pros and cons for using each. My personal opinion is Excel will do the job just fine.
To be honest, I am leaning towards Excel if that is the case as I have never used Access. So there's an extra learning curve there in itself.

Quote:
Originally Posted by ArviLaanemets View Post
How it may be done with Excel:
You have a table where all items/reciepes/whatever are registered, along with fields for search criterions. Going with your example - ReciepeName, Country, Type, Class, ...;
Then in another table you have details for those items/reciepes/whatever registered (e.g. Reciepe, Ingridient, Quantity);
You also need a separate tables for every search criterion from 1st table - so you can use data validation lists for entering data into 1st table, and for setting report criterions.
Then in separate sheet you can select criterion values. And on same sheet, or in some hidden one you need a table, where a list of items/reciepes/whatever matching selected criterions from 1st sheet is generated (worksheet formulas will do nicely);
On same sheet where you did set criterions for report, you can also select a item/reciepe/whatever from this generated list (Data Validation again). Based on this last selection, the report is generated (e.g. the name of reciepe, and below it the list of ingridents and their quantities).
Thank you very much for helping. I will need to take some time to wrap around what you've said and to try it out myself.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Generate template-based letter with multiple variables shallaes Word VBA 5 07-12-2018 12:18 AM
Report Containing Multi-Selection Dropdown Donnatoye Word VBA 10 06-20-2018 08:58 AM
Generate custom report based on user selection? Novice to Pivot Table: Need help to generate a report in a predefined format Himansu Excel 2 10-26-2014 03:57 PM
Generate custom report based on user selection? User Form to Automate Entry in report Panzer Word VBA 2 08-22-2012 04:17 AM
Custom Report Templates fervorking Outlook 0 05-25-2011 09:39 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:24 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft