Wow...
Yes you should be able to do this, the ease of implimenting it will depend on your database design.
It might really help if you will post your SQL.
Please do so by first clicking on the [CODE/] button first and then pasting the SQL between the [code] tags. Please place each query in its own code block... add a title so that we can follow.
Also haveing the Version of Access your are using and your table design and relationships would be helpful. Something like:
Access2010
tbl_name1:[field1_name](Key, datatype, relatedto); [Field2](properties), [Field3]...
tbl_name2:[field1_name](Key, datatype, relatedto); [Field2](1:M w/tbl_name1, numeric-long, other properties), [Field3]...
at this point we do not need your database itself