Generating a specific report

T

tam

Can a single specific record based on two different fields "school" and "date
of action" be opened in a REPORT using a command button?


The DB in question is to be used by non technicals and I need make it as
simple as possible. One finger click to get the exact record they need. It
must be in report becasue the specific record will then be emailed to another
department in rtf.
 
R

Roger Carlson

T

tam

Hi Roger

I have looked at your suggestion. However, I do not see how it can work.
You examples are based on single occurrence data field (SS#).

There will be a number of records for each school in the tables, from which
I need to generate reports. These will be sorted by date of visit or date of
report (depending on which action is being completed.) The forms are all set
and the data goes into the correct tables as entered.
I thought I could set up a "go to last record" query based on a school query
and then have a command button open that specific record in a report which
can then be emailed onward to another department. I can't figure out how to
set it all up.

I'll ask my husband to help me with the conundrum this weekend. He is a VB
and Access lecturerer. He says it only needs relatively simple programme to
run.

Thanks anyway.

Tam
 
Top