Search results

Success!...Not that I used a junction table but at least you got me thinking. I first made a distinct recordset of each item in TableOne. I opened another recordset of TableOne as SQL query filtered on the first item in the distinct list and got the record count. The record count gave me the...

Thanks Doc Man... I'll do the homework on the junction table but even with a table that shows the link, how would you step through TableTwo ensuring I don't recount the first match on item A. Somehow I have to mark TableTwo so I can skip over that item and look for another match on the next...

Hello, I am looking for help on how to use code to match certain items in two tables. But I need to track which item matches the item in the other table. For example I have TableOne that has fields; TableOne_ID(AutoNumber), Item(txt), and TableTwo_ID(Integer). TableTwo has...

I've been dabbling at Access for years so I guess it’s time to become a bit more professional at my projects... this site should help! I live near St. Louis Mo., enjoy helping small businesses with office automation/integration. Thanks to all who keep this forum going… great resource...