Query Results filter by date (today) in two fields

[LeadTechIG]

All,

I am trying to amend a query that I have used for a long time, that shows me a list of all the assets I have that are ready for sale. What I would to accomplish is to have the results of the query only show me what is NEW to those criteria. Here is the kicker: I have two fields that are updated independently of each other - the date the asset processed at my facility, and another for the date that it passed our product testing if needed. There are NO line-items where those dates are the same.



The three criteria are that the asset read "Finished Goods" under [Asset Status], "Today" under [Date Recorded], and "Today" under [Date Tested].

My concern is that I will amend my query so that the results are just "Finished Goods" under [Asset Status], AND *"Today" under [Date Recorded]* or *"Today" under [Date Tested]* where I need both to be true.

Any help would be much appreciated.

[rpeare]

In your query design you have OR lines under your first criteria.

So the first line of your criteria would read 'finished goods' under asset status and your 'date recorded' criteria would be date() or [Enter the date]
On the second line of your criteria you would have 'finished goods' under asset status and your 'date tested' would be date() or [Enter the date]

Each row represents a different OR, you just have to repeat the static criteria (in this case 'finished goods' in the asset status field) for each row.

[LeadTechIG]

Thank you very much. This solved my problem.

[LeadTechIG]

I have a new additional concern, but I did not think it warranted a new thread. I'm looking to generate a week's worth of information, but I do not know how to go about doing that with TWO date fields. I have a query that results in a single day's worth of information via both date fields, but if I wanted the parameter value to be a business week, how would I go about doing that?

[rpeare]

in your date field criteria put

Between [Enter the Start Date] and [Enter the End Date]

when the query is run the user will be prompted for dates or use a form and reference the start and end date like:

Between forms!frmCriteria!StartDate and forms!frmCriteria!EndDate