Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
decimal places
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...- cruiser01
- Thread
- Replies: 8
- Forum: Microsoft: Access Other topics
-
Merging data with a query
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...- cruiser01
- Thread
- Replies: 3
- Forum: Microsoft: Access Other topics
-
Merging data within a record
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...- cruiser01
- Thread
- Replies: 4
- Forum: Microsoft: Access Other topics
