var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Query join based on Range
I have two table. E.G.
I want to update the Table1.System with Table2.Description based on the AcctNum failing in a Range using AcctMin to AcctMax.
I can't see any obvious way to do this besides writing code to do the update because of a missing relationship between T1 and T2.
Perhaps some of the SQL geniuses here can?
Owner and Manager of
. , Microsoft Access Development Specialists CypherBYTE
Microsoft Access . MCP
And all around nice guy! "Heck it's something understood by accountants ... so it can't be 'that' difficult..."
"...teach a man to code and he'll be frustrated for life! "
FROM Table1 LEFT JOIN Table2 ON (Table1.AcctNum Between Table2.AcctMin and Table2.AcctMax)
This didn't return any results.
SELECT tbl_charter_remittance_data.[Invoice Number], tbl_datech_systems.[System Sh], tbl_datech_systems.AcctStart, tbl_datech_systems.AcctEnd
FROM tbl_datech_systems LEFT JOIN tbl_charter_remittance_data ON (tbl_charter_remittance_data.[Invoice Number] BETWEEN tbl_datech_systems.AcctStart AND tbl_datech_systems.AcctEnd);
I wouldn't expect "Invoice Number" to work, since you earlier mentioned AcctNum. If that's not it, can you post a sample db?
Sorry, thats my mistake, works as it should.