I am quite confused about this any help would be greatly appreciated
I have raw data that does not contain any state data but has user ID's
I maintain a user table that allows me to write queries
tblUsers
UserID State Team
ABS NSW Motor
DEF QLD Home
SET NSW Home
tblRawData
My Raw Data
UserID Sales
Query is easy
SELECT Sum(SALES) FROM tblRawData INNER JOIN tblUsers ON [tblCaseloads].[User ID]=[tblUsers].[USERID]
Group By Blah blah blah
However sometimes the users change teams so I want to add a column to my users id call exclude date. The results of that person should not be counted after a date
but how how can I count the data
SELECT Sum(SALES) FROM tblRawData INNER JOIN tblUsers ON [tblCaseloads].[User ID]=[tblUsers].[USERID]
Group By Blah blah blah
Where Something here...
I have raw data that does not contain any state data but has user ID's
I maintain a user table that allows me to write queries
tblUsers
UserID State Team
ABS NSW Motor
DEF QLD Home
SET NSW Home
tblRawData
My Raw Data
UserID Sales
Query is easy
SELECT Sum(SALES) FROM tblRawData INNER JOIN tblUsers ON [tblCaseloads].[User ID]=[tblUsers].[USERID]
Group By Blah blah blah
However sometimes the users change teams so I want to add a column to my users id call exclude date. The results of that person should not be counted after a date
but how how can I count the data
SELECT Sum(SALES) FROM tblRawData INNER JOIN tblUsers ON [tblCaseloads].[User ID]=[tblUsers].[USERID]
Group By Blah blah blah
Where Something here...
