Report with Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I create one Database for control my family Blood Pressure that have this structure
Date: Date/Tim
Time: Date/Tim
User: Tex
Systolic: Tex
Diastolic: Tex
Pulse/min: Tex
But I want to create a report that allow me to choice the User and the start and end date, I try creating first one Query but I couldn’t
I don’t have any clue how I can do this in one simple way
Please any advice or help is very welcom
Thank

Fernand
 
Fernando, search the topic "Parameter Query" in Access help. What you will
do is create a select query. In the Date field, instead of entering regular
criteria, enter this:

Between [Enter Start Date] and [Enter End Date] <-- be sure to include the
brackets.

In the User field, enter this: [Enter User Name].

Each time you run the query, Access will prompt you for the information in
brackets. Then create your report based on this query.

DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com

Fernando said:
I create one Database for control my family Blood Pressure that have this structure:
Date: Date/Time
Time: Date/Time
User: Text
Systolic: Text
Diastolic: Text
Pulse/min: Text
But I want to create a report that allow me to choice the User and the
Click to expand...
start and end date, I try creating first one Query but I couldn't.
 
the sample database Northwind, that comes with Access, uses something very similiar to what you want to do. Look at the "Print Sales Reports" on the main switchboard
I would do something like this
create a query (BloodPressureQuery) with all the fields from the table
create a form (ReportInfo) to get user information- include a combo box (UserNames) to list names, a Date Start (DateStart), Date End (DateEnd), and a Print Butto
In the query design view add the criteria [Forms]![ReportInfo]![UserNames] to the 'User' field, add the criteria >=[Forms]![ReportInfo]![DateStart] And <= [Forms]![ReportInfo]![DateEnd] to the 'Date' fiel
set the record source for the report to BloodPressureQuer
This is just an idea- You can get some more ideas from the Northwind sampl
Ale
 
In addition to the advice you've received from others, I'd just like to
point out that you really should combine your Date and Time fields into a
single field (and you definitely should not use Date and Time as field
names: they're reserved words, and using them can lead to all sorts of
problems)

If you do combine them, and find that you want only the date value (for
instance), you can use the DateValue function to return that. There's also a
TimeValue function that will strip off the date, returning only the time.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



Fernando said:
I create one Database for control my family Blood Pressure that have this structure:
Date: Date/Time
Time: Date/Time
User: Text
Systolic: Text
Diastolic: Text
Pulse/min: Text
But I want to create a report that allow me to choice the User and the
Click to expand...
start and end date, I try creating first one Query but I couldn't.
 
Back
Top