I am currently programming my database through the Microsoft Access program, but have recently been stuck on how to proceed in doing some of the more complex operations I need to accomplish.

I am currently setting up a query to search through my entries and bring up results based on varying criteria. However, I am wondering if there is any way to make criteria based upon another field in the table.

i.e. Say I have a [Table 1] with two data sources in it, say a [Date] and a [Value].
I want to sort the [Value] only if the [Date] is between certain times or I want to ignore the entry and not sort the [Value] if the [Date] field contains an invalid argument. How would I go about doing this?

Thanks for any assistance you may provide.

Brett Beckett
[email protected]