Showing records based on certain date

[mindbender]

I have a database with a main form and 4 subforms. What I am trying to do is have a query button that will return all the records based on the followup date of one of the subforms.

So basically the database will look exactly as it does with all records only it will just sow the ones with the follow up date <= Now()



Thanks in advance

[June7]

Use the query techniques described in your other thread https://www.accessforums.net/access/...rms-34639.html

Apply criteria to the Last Modified Date field.

However, since most of the records don't have a value in this field and if you want those records, include Is Null in the criteria:

<=Now() Or Is Null

[mindbender]

I have found that that does not return the data in the form but as a datasheet. I have found the filter by foirm option but for some reason it will not let you use it on that field...not sure if it is because it uses DMAX or not - any thoughts

[June7]

Don't understand 'does not return the data in the form but as a datasheet'.

The suggested filter criteria seems to work for me.

I do seem to recall filter by form doesn't work with calculated fields.

[mindbender]

Yeah what I did was similar to the Last Modified date you showed me to diplay the Next activity date from the subform onto the main form.....Filter by Form will not work on a field that is not dirently in the table or query that drives the form......go figure . I liked filter by from because it kept what the users sees exactly the same in terms of their UI layout - When I try to use a separate query it returns the results in datasheet view and they cannot enter any updates just view the data

[June7]

Anything involving UNION or GROUP BY will not be an editable recordset.

[mindbender]

ok - so I guess I am out of luck - I wouldn;t have thought it was that unique a thinkg to want to do....but that is why I am not an expert

Thanks