Printing a Custom Report!

[chongo]

I am attempting to create a report that will allow me to select which records I want printed. Filter down myselection. what is the Calculation field?

for example:

I have many aircraft with different tail numbers and each one fueled by one of two companies. ASIG or AVFuel(Signature). I am attempting to create a report that will allow me to select every record from a given date range (which I already have setup and works great.) but want it to present only from one fueler or the other. right now it gives me every aircraft and every fueler all mixed. The second issue is not every record contains the name of the fueler writen exactly. some say ASIG,asig,SIG,SFS,AVFUEL,SFS/, etc... I have the long list of keywords used. I would be willing to change each one if needed. But for right now cant figure out how to get my report to filter down to the select fueler.

if(Fueler=EXACT (SFS,FSS,etc...keywords here))

what would be more along the lines of the proper calculation field I need? Fueler is a defined feild but after this will no longer be a text box , it will be a drop down..lol dont want to repeat this. too many records to go in and change. looking for an alternative route. please any help would be appreciated. thanks all who take the time to read.

[IdealData]

The vote is academic as you can only upgrade to 8.5 now.

Firstly, get all your records corrected so that there are only the 2 entries. It's a lot quicker than you think. Do repeated find and replacement for all the wrong entries, replacing with the correct entry. Then create a value list to only offer the correct entries and finally use the value list as the only entry method for the "Fueler" field.

Your report needs to be sorted by "Fueler" and can only possibly produce 2 listings when the data is corrected.