look for certain data on three different fields in a query

[Guest]

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

 

[Guest]

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]

 

[Guest]

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

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

 

[Guest]

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.

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

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

 

[Guest]

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

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.

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

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