Question Individual reports

[Burnsie]

This is my last question before my world (well, database) is complete.

I have made a database that records client’s personal details (name, sex, address, DOB etc) and, in a separate table, personal measurements (test date, height, weight, BMI etc).

These are linked by a unique participant number.

I have built a query with a date parameters so I can search those who I have measured between certain dates. I have built a report so I can print those details off.

What I want to do now is have an individuals query/report for each person, meaning I can print off a report with just their test result on so they can take it away with them.

Tell me how more knowledge people....

 

[John Big Booty]

Simply use the ClientID as the criteria for the query that is populating your report.

 

[Burnsie]

Me again....

I get what you’re saying, but I can’t work out how to do it.

I’ve built a query, and, in “design view” in the “criteria” field I don’t know what to write in order to get it ask me for, for example, “surname” or “participant number” as a search parameter???

I’ve managed it with another query, where I searched for results by date. In this query, in the “criteria” field I used “Between [Enter Start date:] And [Enter End Date:]”

Any ideas?

B

 

[John Big Booty]

Perhaps the DB I posted here will get you headed in the right direction. It uses the InvoiceID as criteria for a report, but you should be able to extrapolate and bash it to fit your own needs.

 

[Simon_MT]

You could create a Dialog box and combine both requirements:

Fields for

Client ID
Measurement Dates

Set RequestType AfterUpdate
RequestType I = ClientID M = Measurement
Two Command Buttons Reports or Entry

On your command set up your Criteria and luach your Form or Report.

Simon