Search results

I tried that, but that didn't work. I had 8019 results and 3 had the same origin and destination. I expected to see 8016, when I did you suggest. for some reason, it omit everything that have that city name. for example it omit Jackson to baltimore, because destination city have baltimore in...

Pbaldy, below is my SQL. If the destination is the same as my origin, then I don't want to see that data. I got the origin right but I don't know how to omit the data where destination is the same as the origin. SELECT DF_Bills.Locn, DF_Bills.Carr AS SCAC, DF_Bills.Mode, DF_Bills.Pro AS...

Somebody help. I have 2 columns, one is OriginCity and the other is DestinationCity. I want to filter out where origincity is like destinationcity. for example. I have origin "Baltimore" however, if I have a destination "Baltimore" I do not want to see it in the results. Is this possible.

You guys are the best. thank you very much!!!

DK, I'm not sure if this work on mind, I've already have a select, where on my qeuery. for Example, this is my select statement that I currently have. SELECT TMS_Cleaned_Data.Week, TMS_Cleaned_Data.Equipment, TMS_Cleaned_Data.[Origin City], TMS_Cleaned_Data.[Destination City]...

OK, Let me try it.

You guys see what I'm talking about?

OK, Your DB gave me the same error. In the design veiw of your query put this criteria in the last column CPM.... Between 1 and 3

it's too big to upload, is there another option?

can I send my db to you?

Yes I was able to download it. I was only able to look at the SQL code and not the interface mode. fields in the query

It doesn't seems like you put any criteria in for the CPM_Less_Fsc_Acc. try puting "between 1 and 3

Medea, the popup is referencing to the "ACC" field.

the "ACC" field is just summing three fields together. The formula reads, "stop charge" + "Tarp charge" + "overwidth charge"

Yes it does

I've done all of that. everything works find, until I put the criteria in field5

Please Help!!! Something as simple, yet the hardest to figure out. Field1 is: "Total Shipment Charge" Field2 is: "FSC" fuel Surcharge Field3 is: "Distance" Field4 is: "ACC" Accessorial however, this field is a formula ( ACC: IIf(IsNull([Allocated Overwidth Charge...

the parameter I enter is "Between 1 and 3", I only wants to returns value where cost per miles is above $1 and under $3.

Thanks guys, this formula works great!! ACC: IIf(IsNull([Allocated Overwidth Charge Cost])=True,0,[Allocated Overwidth Charge Cost])+IIf(IsNull([Allocated Stop Charge Cost])=True,0,[Allocated Stop Charge Cost])+IIf(IsNull([Allocated Tarp Charge Cost])=True,0,[Allocated Tarp Charge Cost])...

Please help!!! The following formula is what I use to add fields, however; when I refresh my data in excel, I get an undefined "nz". the formula works in access, but I can't seem to get my excel to retrieve the data? what am I doing wrong? ACC: (CInt(nz([Allocated Overwidth Charge...