Date Parameter problem (2nd Post)

[Norma]

I am only posting this again because I did not get any responses the
first time I posted it. Excuse me for being redundant here but I can't
figure this one out.

Original Post:
I am trying to make a query pull data from between the dates I enter
in the parameter but also look back 'in time' to see where 2 other
fields have null values, and only pull data into the query if those 2
fields are null prior to the beginning date of my parameter.
The reason for this (to help make this a little clearer)is to pull
production into a query if it is a 'new' for the month. That is, never
run before the dates entered. I have 2 fields that I am looking at to
see if it is a 'new' product, those fields are hours and cases.
Any help would be greatly appreciated!

Thanks,
Norma

[Wayne Morgan]

Try a Calculated Field in the query.

Field: Expr1:[Table1].[Field1] Is Null And [Table1].[Field2] Is Null And
[Table1].[DateField]<[Parameter Statement]

Criteria: True

--
Wayne Morgan
MS Access MVP
"Norma" <nj**********@suscom.net> wrote in message
news:20**************************@posting.google.c om...

I am only posting this again because I did not get any responses the
first time I posted it. Excuse me for being redundant here but I can't
figure this one out.

Original Post:
I am trying to make a query pull data from between the dates I enter
in the parameter but also look back 'in time' to see where 2 other
fields have null values, and only pull data into the query if those 2
fields are null prior to the beginning date of my parameter.
The reason for this (to help make this a little clearer)is to pull
production into a query if it is a 'new' for the month. That is, never
run before the dates entered. I have 2 fields that I am looking at to
see if it is a 'new' product, those fields are hours and cases.
Any help would be greatly appreciated!

Thanks,
Norma