Newbie Report Question

[crowdx42]

Ok so I am very new to access, what I have is imported data from excel, from this data I have employee's names as a field and various other fields as stats for the employees. What I want to do is have a drop down list of the employees which the user can select the name and then a report just for this employee will be populated and the user can then print if desired.
I have a report started with the original wizard and modifying this (moving the boxes to where they need to be to replicate the original report from excel).
Anyone got any views on this, what is the best way to get this report from a drop down list? Also by importing the data from excel and then running the report wizard seems to have gotten all but a few required fields into the report, should I calculate these required fields in access or just run a macro in excel to have the data already listed?
All help appreciated.
Patrick

 

[GaryPanic]

check the names of the fields are they numric ie 555 Access is not keen on field names starting with numbers,
as to your drop down list for reports
check the sample database section on this plenty their
howver if its only going to be 1 report assing it to a button

 

[gregoryenelson]

GaryPanic was probably right - if the fields/fieldname are not coming across from Excel it is proably becaue the need renaming to be acceptable for Access.

For your report, there are numbers of ways to do it - one way is:

To run your report: functionally your user should make their selection of employee, this will create a make table query (or alter an existing parameterized Maketable query. The table created will always be of the same structure (only contents will vary - 'fred', 'sue' etc). You can then reliably create a Report on that table.

After you have populated the listbox find the onClick event go to the code window via properties (presumably you dont know VBA code).
So a nice easy accessy macro'ey way would be to use
"Docmd.OpenReport(ReportName, View, FilterName, WhereCondition, WindowMode, OpenArgs)" check Help. in the WhereCondition parameter place you will have to put the employee's name that the user has just selected.
To get the selected name you will have to run some code ... you will have to do
Dim chosenname$
chosenname = ListControlName.ItemData(listindex) ....i think ....
Then you can do the above Openreport(name,,,=chosenname).

BUT, you are starting on a very slippery slope with all this stuff, and it might be wise to get back to your area of speciality pronto. I myself wish that I had never left the fish processing gutting and canning industry.

 

[crowdx42]

Thanks for the help , will have a look tomorrow when I get to work. Been also considering doing this in an excel sheet also, that I can do quite easily.