sub-form to link using a range of values

[Guest]

Hello,

Is there a way to link sub-form records to the master-form whereby the link
falls within a range of values?

Example: I'm looking for offsite lab procedures that have a [service_date]
that occurred either on or in-between the hospital [admit_date] and
[discharge_date] fields. So, (somehow) display the lab records where
[service_date] >= [admit_date] AND [service_date] <= [discharge_date]

I was envisioning the master-form having unique records for each patient
stay with the fields for their med. rec. number, admission date and their
discharge date. The sub-form would have all the lab records and link using
the med. rec. number and where the service date is equal to or between the
admission date and discharge date.

Thank you in advance,
John Lehmus
Portland, Maine

 

[Guest]

Put the [admit_date] and [discharge_date] as criteria in the query for the
subform.

 

[Guest]

Hi Karl,

How would the linking be done? Would it still work with the range ie: admit
date 5/30 and discharge date 6/2 and the lab procedure was done on 6/1?

Regards,
John_Lehmus
Maine, USA

~

Put the [admit_date] and [discharge_date] as criteria in the query for the
subform.

--
KARL DEWEY
Build a little - Test a little

Hello,

Is there a way to link sub-form records to the master-form whereby the link
falls within a range of values?

Example: I'm looking for offsite lab procedures that have a [service_date]
that occurred either on or in-between the hospital [admit_date] and
[discharge_date] fields. So, (somehow) display the lab records where
[service_date] >= [admit_date] AND [service_date] <= [discharge_date]

I was envisioning the master-form having unique records for each patient
stay with the fields for their med. rec. number, admission date and their
discharge date. The sub-form would have all the lab records and link using
the med. rec. number and where the service date is equal to or between the
admission date and discharge date.

Thank you in advance,
John Lehmus
Portland, Maine

 

[Guest]

The forms Master/Child links on the PatientID or "their med. rec. number."
--
KARL DEWEY
Build a little - Test a little

Hi Karl,

How would the linking be done? Would it still work with the range ie: admit
date 5/30 and discharge date 6/2 and the lab procedure was done on 6/1?

Regards,
John_Lehmus
Maine, USA

~

Put the [admit_date] and [discharge_date] as criteria in the query for the
subform.

--
KARL DEWEY
Build a little - Test a little

Hello,

Is there a way to link sub-form records to the master-form whereby the link
falls within a range of values?

Example: I'm looking for offsite lab procedures that have a [service_date]
that occurred either on or in-between the hospital [admit_date] and
[discharge_date] fields. So, (somehow) display the lab records where
[service_date] >= [admit_date] AND [service_date] <= [discharge_date]

I was envisioning the master-form having unique records for each patient
stay with the fields for their med. rec. number, admission date and their
discharge date. The sub-form would have all the lab records and link using
the med. rec. number and where the service date is equal to or between the
admission date and discharge date.

Thank you in advance,
John Lehmus
Portland, Maine

 

[Guest]

Good Morning Karl,

Thank you again. By linking only on the PatientID (or m.r.n.) we will see
all lab procedures before and after this particular admission. Maybe the
sub-form could be based upon a query that could filter-out the before and
after records?

Thoughts??

Regards,
John Lehmus
Maine, USA

The forms Master/Child links on the PatientID or "their med. rec. number."
--
KARL DEWEY
Build a little - Test a little

Hi Karl,

How would the linking be done? Would it still work with the range ie: admit
date 5/30 and discharge date 6/2 and the lab procedure was done on 6/1?

Regards,
John_Lehmus
Maine, USA

~

Put the [admit_date] and [discharge_date] as criteria in the query for the
subform.

--
KARL DEWEY
Build a little - Test a little


:

Hello,

Is there a way to link sub-form records to the master-form whereby the link
falls within a range of values?

Example: I'm looking for offsite lab procedures that have a [service_date]
that occurred either on or in-between the hospital [admit_date] and
[discharge_date] fields. So, (somehow) display the lab records where
[service_date] >= [admit_date] AND [service_date] <= [discharge_date]

I was envisioning the master-form having unique records for each patient
stay with the fields for their med. rec. number, admission date and their
discharge date. The sub-form would have all the lab records and link using
the med. rec. number and where the service date is equal to or between the
admission date and discharge date.

Thank you in advance,
John Lehmus
Portland, Maine