Generating a specific report

[Guest]

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.

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "PrintOneLabel.mdb" which illustrates three ways to do this.
Don't be put off by the name. A label report is just like any other report
and the process will work the same.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

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