compare two fields slightly different
Ok, in one table I have the route numbers 03, 04, 05, 06 and so on. In the other table those route start with a 1 so it would be 103, 104, 105, 106 and so on. How would I set it up so that 03 would recognize 103 as the same driver?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Kurt Reinhardt
One other possible suggestion is you bring the data from one table into the report and write a formula against it so that it matches the format of the field from the other table. Then, use the other table in a subreport and link the main and sub from the formula to the field in the subreport. Please note, you generally only want to do this with a subeport in a group, page or report header/footer - not in a detail section, if you can help it.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I am getting this error now
The data types varchar and char are incompatible in the '&' operator.
How do I fix that? I'm using
ON '1' & INVW.Warehouse COLLATE DATABASE_DEFAULT = BTWarehouseHistory.RouteNo
The data types varchar and char are incompatible in the '&' operator.
How do I fix that? I'm using
ON '1' & INVW.Warehouse COLLATE DATABASE_DEFAULT = BTWarehouseHistory.RouteNo
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.