Search results for query: *

It created a circular reference but that name wasn't important so I just simply changed it to "Cost". Problem solved. Thanks to everyone.

sorry, "Expr1001

Interstingly enough, it does work, but somehow looses track of the fact that the field was actually called "Costperlb". Comes back as "Exp1001".

Sorry, I led you astray. The calculated field is Costperlb. I previously tried: format([Costperlb],"####.###") But, this returns a "missing operator" error.

Have an issue with decimal places. Have a query with that looks like this: Select [MasterOrder] as Orderno, Costperlb from COSTDATA where MasterOrder > 0 Union Select [Order2] as Orderno, Costperlb from COSTDATA where Order2 > 0 Union Select [Order3] as Orderno, Costperlb from COSTDATA where...

Thanks a bunch. Was simply just simply the fact that "order" numbers were a numberic field, so just changed the criteria to >0.

I think you're on the right track. Tried some union queries, but kept getting duplicates. I did try what you suggested and it makes sense to me, but getting a "data type mismatch", so I'm working through it.

Didn't get a solution the first time so thought I would try again. Have a table that looks like this: MasterOrder Order2 Order3 Order4 Costperlb 111111 222222 333333 444444 .088 123456 456789 .109 777777 888888...

Ok, in one query called COSTDATA I return the following based on table where the data is entered: DATE MASTER ORDER (Alias for Order 1) ORDER 2 ORDER 3 ORDER 4 ORDER 5 ORDER 6 TOTAL WT FREIGHT COST COST PER LB (caculated field within the query-FREIGHT COST/TOTAL WT) The flat file I need would...

Let me give you a little more detail. Per say shipment has 5 orders own it. The 1st order on the shipment becomes the master ID (simply for reference on a master BOL) and there are 4 other orders. One piece of information that is common to the whole shipment is the total freight cost (we only...

I have an Access table that maintains a history of our shipments. Within each record (shipment)there 6 fields that may or may not be used to reference orders filled on that shipment. All of the data is currently being pulled into a query to do some calculations for doing analysis various cost...