Recent content by redlich23

I was wondering if someone could help me with an issue. I have a form that contains a sub form. The sub form is a list of records that meets a time interval + or minus a specific time (Designated by the user prior to opening the main form). I also have two fileds called Min Price and Max Price...

This worked perfectly but now I need to compare the DMIN and DMAX numbers to a value on the main form. I need to do this for all 1127 records in the record set. Obviusly I dont want to click through all records one by one. Is there a way to run a query to do this?

perfect that worked! Thanks so much!

The subform is based on a query. I was looking at the DMin and DMax but I tried several variations and was unable to get a appropriate ansewer. I put a text box on the main form and used the following as the control source but it didnt work. I am sure I am doing something wrong...

I was wondering if someone could help me with a min/max issue. I have a form that also contains a subform. The sub form is displaying all records from a master table that are 10 min before and 10 min after the current record on the main form based off a field called time. This works fine...