G
Guest
I have a query that is returning results and records from various tables and
I need to set up some type of conditional expression or something that will
provide the results I need. The fields I am working with contain:
BrTp - this field contains records like B, F, A
BOD - this field contains records like RU, RV, N1
LT - this field contains numbers - 1,2,3,4,etc...
Inv - this field also contains numbers anywhere from 0 to greater than 250
I need to look at each of the first 3 fields just the way they are and
identify say if BrTp = B and BOD = RU or RV and LT = 3......
The Inv field is different. If, let's say Inv = 12 then it will fall into a
range of 11-30. If Inv = 5 then it falls into a range of 5-6. I have sets
of ranges in Excel that corresponds with any number that the Inv field could
have.
So with the above 3 criteria met if the Inv = 5, then those 4 requirement
together will return say, 77, the results of which I have in an Excel file.
Picture this data in small mini graphic tables in excel where the BrTp and
BOD tell you which graph to look at, then the LT is across the Y axis, the
Inv ranges are down the X axis and the resultant numbers are within the graph.
I hope I have explained this accurately enough, but it is a bit complex to
describe.
Any help would be greatly appreciated
Thanks
I need to set up some type of conditional expression or something that will
provide the results I need. The fields I am working with contain:
BrTp - this field contains records like B, F, A
BOD - this field contains records like RU, RV, N1
LT - this field contains numbers - 1,2,3,4,etc...
Inv - this field also contains numbers anywhere from 0 to greater than 250
I need to look at each of the first 3 fields just the way they are and
identify say if BrTp = B and BOD = RU or RV and LT = 3......
The Inv field is different. If, let's say Inv = 12 then it will fall into a
range of 11-30. If Inv = 5 then it falls into a range of 5-6. I have sets
of ranges in Excel that corresponds with any number that the Inv field could
have.
So with the above 3 criteria met if the Inv = 5, then those 4 requirement
together will return say, 77, the results of which I have in an Excel file.
Picture this data in small mini graphic tables in excel where the BrTp and
BOD tell you which graph to look at, then the LT is across the Y axis, the
Inv ranges are down the X axis and the resultant numbers are within the graph.
I hope I have explained this accurately enough, but it is a bit complex to
describe.
Any help would be greatly appreciated
Thanks