Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Microsoft Access 2003 database

Microsoft Access 2003 database

Microsoft Access 2003 database

I have created a database for tracking xray exams with (2) tables one for Patient info and one for Exams for the patient. I have also created a basic report for printing log book pages with the patient ID, date of exam, patient name, exam, and date of report. What I would like to do is print the report by the month of  the exams. Example I would like to print a report to include just a particular month say 10/01/2006 through 10/31/2006. Is there a way to do this in the report format. I know I can set up a query but I cant seem to print that info in the report.

RE: Microsoft Access 2003 database

There is a forum for Access teports:
Microsoft: Access Reports Forum

What is the problem? Selecting the data or including the selection in a header?

RE: Microsoft Access 2003 database

no I cant get the data that I want in the report I want to be able to select a certain date rage for the report on a monthly basis

RE: Microsoft Access 2003 database

How do you want this to happen?
- You can use parameters in a query;
- You can use a form to enter the dates and have a query pick up the range;
- You can open an existing report with a date range as a Where statement;
- you can do all of the above with a month number, rather than a date range.

There may be more, but I can't think of them at the moment.

RE: Microsoft Access 2003 database

I would like to try using your 2 examples you stated

You can use a form to enter the dates and have a query pick up the range;
- You can open an existing report with a date range as a Where statement;
 that would help alot thank you very much

RE: Microsoft Access 2003 database

These two are alternatives, if you have one, you do not need the other.

Let us say that you have a an unbound form called frmForm, which has two text boxes called txtStart and txtEnd, both formatted as dates.

Option 1
Let us say that in additon to frmForm, you have a report called rptRepotOn and on frmForm you have a command button called cmdPreview. The code behind cmdPreview would be:


Private Sub cmdPreview_Click()
    stDocName = "rptReport"
    DoCmd.OpenReport stDocName, acPreview, , "[Date of Exam] Between " & Me.txtStart & " And " & Me.txtEnd
End Sub

[Date of Exam] is the name of the field that holds exam dates.

Option 2
Create a query from the table you wish to use for a report and add:

Between Forms!frmForm!txtStart And Forms!frmForm!txtEnd

To the criteria line of the form, under the exam dates field.

Fill in the form and open the query. If all is well, use this query to build a report. The report will only work properly when the form is open.

You will find a great deal of information, if you visit the Access Reports forum that I mentioned in my first post.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close