But now with the changing assignments I don't quite know how to find out which expense goes to which branch. Does the BranchID field of my query have to have If statements for every single vehicle? (If VehID=1 AND StDate<=05/01/2006, BranchID=2, otherwise BranchID=17)
If so, how would I string them all together in one statement properly?
Should have clarified this a bit - I know how to get the right branch number for one vehicle using the Where TransDate Between StDate and EndDate, my question is how to do that efficiently for all vehicles and all expenses listed on the report.
Thanks for any assistance you can offer here!