Search results

This is supposed to update dynamically. The query feeds a bunch of reporting tools and serves as entity list. So as stuff is added to what feeds my tables, the query is supposed to spit out the list without further manual intervention. I don't know how UNION works. Googled it and tried adding it...

Good Morning, apologies, my SQL query skills aren't what they used to be and I'm stuck. I have two linked tables: FPNA Data (Exel) and vwMaster (SQL server) with a variety of information all linked by a common field. I use a left join query that takes all the records from FPNA Data and adds...

I was thinking left join, but when I looked at the SQL I realized that it left joined the wrong way... flipped them around and all is peachy now. Apologies and thank you! :D

Good Afternoon, first off apologies for the noob question... it's been a long time since I've worked with access and clearly I'm rusty. Here is what I'm looking at : Linked table (Excel sheet) "FPNA Data" (376 records) Linked table (SQL server) "vwMaster" (11k records) Both links have a...