Calculating for Nexus

Wade, I decided to try your table & related data, though I'm not a CPA or accounting person. But Iiked Blake's response & need the practice with relations in QB.

I found a .csv link (actually I copied and pasted, so see my two images because you will probably want to change 2 or 3 fields data types). If you don't want the GPS coordinates you can take out, though much of my work is geographic, so I left them in.

https://developers.google.com/public-data/docs/canonical/states_csv

Note the 4th field I changed the type form #record to text. Not sure if I could have left this as #record as this is the unique and key field? This data has District of Columbia & Puerto Rico, so it is also 52 states as I believe you want. 


​​

------------------------------
Bob T.
------------------------------