Search results

The fields' name won't actually be [fixed name] + [increment number] though :( I just called them F1, F2 etc... due to confidential problem. There are no rules / patterns for field names. What I need is something completely dynamic and does not rely on field names at all :( I think it can only...

Sorry I should be more clear >.< Query 1 and 2 pull all fields from Query 0 based on Date condition. Query 1: SELECT DISTINCT [Query 0].* FROM [Query 0] WHERE ((([Query 0].Date)=[Forms]![Home]![Date1])); Query 2: SELECT DISTINCT [Query 0].* FROM [Query 0] WHERE ((([Query...

The two queries 1 and 2 pulled data from query0. Query 0 is built based on selection from a form. Here's the code for query 0: For Each ctl In Me.Controls If ctl.ControlType = acCheckBox Then If ctl.Value Then strSQL = strSQL & "[" &...

But the fields in the queries will change dynamically so that won't work?

Hello everyone! I have two select queries with identical structures, joined on a key field. I want to compare the two, and extract the keys of the records with differences into another query / table. For example: i.imgur.com/yLxFywh.png (sorry I don't have enough post count to insert image)...