I am doing a conditional search to find certain records within a table based on date and other criteria, that works fine, however, I then want to do a second conditional search using one of the fields I found in the first search, in my example, it is a cost code in the format of xx-xx-xxx, I want to find another field in the table based on this "matched" cost code field, however, I am looking for it in a different format, the last three characters are different and it is in a differnet date range.  I tried using a Left({cost code} ,6) & "001" to get the original cost code, but ending in 001 which I get, but when I try to do a second conditional search using that "new" cost code, it only checks the data range from the first search. 

 

Can anyone offer assistance.

 

Thanks, Mike

 

I have a Job that runs for say a two year period.  My report runs on a specified week enter through a prompt.  I need to pull several fields to get charges made this week tied to a cost code and a transaction type.

 

OK, now, after I have that, one of the calculations I need to make requires that I use an "estimate" amount that was entered at the beginning of the job and tied to the base cost code xx-xx-001.

 

So, if in the first conditional search that runs from 5-19-07 thru 5-26-07 I find that one of the cost codes that had a charge against was 25-11-360, I need to take that cost code (that was used in that week span) and find the cooresponding estimate cost code 25-11-001 that could have been a year or so earlier.  I cannot pull ALL cost codes ending in 001 because only a few may have had charges that one week.

 

I hope that clears it up a little bit, if not, maybe I can try to post the relevant formulas.

 

Thanks, Mike