look for certain data on three different fields in a query

J

Julio

Hi There I am very new to Access, I've read most of the forums and I have not
been able to find an answer to my question, which I am pretty sure it is very
easy one for your guys.
I've got a table with contains patient, resport day 1, report day 2, report
day 3, and report day 4 fields
Date 1 is a data entry field days 2,3,4 are calculated based on this date,
using macros this fields are placed as data field into their corresponding
table.
I am printing reports from the dates based on months using Expr1:
DatePart("m",[1stProgressReport:]) and my criteria is Like [Enter Mo 1st
Progress Report], nut to obtain the dates (months) from all different dates I
created 4 diff queries called 1st progress report, 2nd.... etc, and I have to
enter the values 4 times for the query to give me the month in question. Is
there a way just enter the criteria value once and then do the search through
each query or the table?
I was thinking more like an Input variable that would carry the value to the
next field and so on.
Does any of this makes any sense ?

Thank you for any advise.

El_antofa
 
K

KARL DEWEY

You can enter it once in a form that remains open and then reference the form
object in each query as criteria like --
[Forms]![YourForm]![YourTextBox]
 
J

Julio

I am sorry, would you be so kind to give me a little example of how ?, I
don't quite understand what you mean.


KARL DEWEY said:
You can enter it once in a form that remains open and then reference the form
object in each query as criteria like --
[Forms]![YourForm]![YourTextBox]

Julio said:
Hi There I am very new to Access, I've read most of the forums and I have not
been able to find an answer to my question, which I am pretty sure it is very
easy one for your guys.
I've got a table with contains patient, resport day 1, report day 2, report
day 3, and report day 4 fields
Date 1 is a data entry field days 2,3,4 are calculated based on this date,
using macros this fields are placed as data field into their corresponding
table.
I am printing reports from the dates based on months using Expr1:
DatePart("m",[1stProgressReport:]) and my criteria is Like [Enter Mo 1st
Progress Report], nut to obtain the dates (months) from all different dates I
created 4 diff queries called 1st progress report, 2nd.... etc, and I have to
enter the values 4 times for the query to give me the month in question. Is
there a way just enter the criteria value once and then do the search through
each query or the table?
I was thinking more like an Input variable that would carry the value to the
next field and so on.
Does any of this makes any sense ?

Thank you for any advise.

El_antofa
 
K

KARL DEWEY

Create a form with the unbound textbox to enter your criteria for the reports.

Put command buttons on the form to run your reports. Have each query used
for the reports refer to the unbound textbox on the form.

In the design view grid enter the criteria under the field. The criteria
will look like this but with your form name and the name of your unbound
textbox --
[Forms]![YourForm]![YourTextBox]

Make sure it is identical by copying and pasting it in your queries.

Julio said:
I am sorry, would you be so kind to give me a little example of how ?, I
don't quite understand what you mean.


KARL DEWEY said:
You can enter it once in a form that remains open and then reference the form
object in each query as criteria like --
[Forms]![YourForm]![YourTextBox]

Julio said:
Hi There I am very new to Access, I've read most of the forums and I have not
been able to find an answer to my question, which I am pretty sure it is very
easy one for your guys.
I've got a table with contains patient, resport day 1, report day 2, report
day 3, and report day 4 fields
Date 1 is a data entry field days 2,3,4 are calculated based on this date,
using macros this fields are placed as data field into their corresponding
table.
I am printing reports from the dates based on months using Expr1:
DatePart("m",[1stProgressReport:]) and my criteria is Like [Enter Mo 1st
Progress Report], nut to obtain the dates (months) from all different dates I
created 4 diff queries called 1st progress report, 2nd.... etc, and I have to
enter the values 4 times for the query to give me the month in question. Is
there a way just enter the criteria value once and then do the search through
each query or the table?
I was thinking more like an Input variable that would carry the value to the
next field and so on.
Does any of this makes any sense ?

Thank you for any advise.

El_antofa
 
J

Julio

Thank you very much I'll be trying that today, I appreciate your help

KARL DEWEY said:
Create a form with the unbound textbox to enter your criteria for the reports.

Put command buttons on the form to run your reports. Have each query used
for the reports refer to the unbound textbox on the form.

In the design view grid enter the criteria under the field. The criteria
will look like this but with your form name and the name of your unbound
textbox --
[Forms]![YourForm]![YourTextBox]

Make sure it is identical by copying and pasting it in your queries.

Julio said:
I am sorry, would you be so kind to give me a little example of how ?, I
don't quite understand what you mean.


KARL DEWEY said:
You can enter it once in a form that remains open and then reference the form
object in each query as criteria like --
[Forms]![YourForm]![YourTextBox]

:

Hi There I am very new to Access, I've read most of the forums and I have not
been able to find an answer to my question, which I am pretty sure it is very
easy one for your guys.
I've got a table with contains patient, resport day 1, report day 2, report
day 3, and report day 4 fields
Date 1 is a data entry field days 2,3,4 are calculated based on this date,
using macros this fields are placed as data field into their corresponding
table.
I am printing reports from the dates based on months using Expr1:
DatePart("m",[1stProgressReport:]) and my criteria is Like [Enter Mo 1st
Progress Report], nut to obtain the dates (months) from all different dates I
created 4 diff queries called 1st progress report, 2nd.... etc, and I have to
enter the values 4 times for the query to give me the month in question. Is
there a way just enter the criteria value once and then do the search through
each query or the table?
I was thinking more like an Input variable that would carry the value to the
next field and so on.
Does any of this makes any sense ?

Thank you for any advise.

El_antofa
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top