Recent content by ptaylorc

Database structure: I have a large dataset, a query which filters those data records, and a form that displays the data (and also allows the user to adjust the query filter parameters). I need to create an additional filter which simply selects a pre-determined subset of the records. I.e. a...

That would be great, thank you! I've attached a simplified copy of my database (the original contains more query steps, but the filesize is huge). For your reference, the basic structure is this: 1. Two tables are imported (TableA and TableB). 2. TableA_ValidRecords and...

Hi Lagbolt, thanks for your response! I have so far only created queries, never forms. I tried creating the mainform and subform as you suggested, but I'm having difficulty. If I use the form wizard, selecting the keys from the main query and corresponding fields from the two tables, I get...

Hi, I'm fairly new to access so please forgive my inexperience. I have two tables (A and B) from different data sources, and each table has it's own primary key (Access assigned autonumber). Records are matched between the two tables based on certain fields, but occasionally there are matching...