Results found from selecting data

P

Pendelfin

There maybe a really simple solution to this but I have had no success trying
various things in Excel and Access.

I have around 50 reports, each with varying numbers of fields. What I would
like to acheive is a system where I can select the fields I require and it to
show me which report contains those (and maybe other) required fileds.

Please can someone think of a way to create this. I have fairly extensive
Excel knowledge, but only limited Access skills.

Many Thanks in advance.
 
P

Pendelfin

The reports are generated in SAP and I have a list in Excel of all the
reports and their fields. These reports don't change maybe a new one is
added aoccasionally so this data can be dumped into any system
 
D

DL

As I have more knowledge of Acess than Excel I would use the former, how you
would proceded depends on how many fields are in each report and how many
unique fields there are.
All you would be effectively doing is querying on selected criteria to
produce the result (report)
 
Top