I would like to create a summary screen with data from several separate queries that are not directly linked to each other.
On my main form I have several subforms and sub-subforms, with each specific data types and handling and writing this data into seperate tables. With the queries I isolate this separate data based on various criteria, one is based on most recent date, other on a yes/no, etc. but there is no real relationship between the returns of the query.
I would like to offer the user a summary screen on start-up where he can see this specific data resulting from each separate query to have an overview of these results.
Is this possible in access ? And if so, how do I do it?? I tried a few things already, like setting the recordsource for each separate field to a field in each specific query, tried some things with me. in the beforeupdate etc. but this doesn't seem to work
On my main form I have several subforms and sub-subforms, with each specific data types and handling and writing this data into seperate tables. With the queries I isolate this separate data based on various criteria, one is based on most recent date, other on a yes/no, etc. but there is no real relationship between the returns of the query.
I would like to offer the user a summary screen on start-up where he can see this specific data resulting from each separate query to have an overview of these results.
Is this possible in access ? And if so, how do I do it?? I tried a few things already, like setting the recordsource for each separate field to a field in each specific query, tried some things with me. in the beforeupdate etc. but this doesn't seem to work
