PDA

View Full Version : Adjustment in Access?


AsleepATheWheel
03-Dec-2003, 10:43 PM
Hi,

Does anyone know which table in Access the information on adjustments is located? I've looked around quite a bit and can't find it.

Cheers,

Paul

Ben
04-Dec-2003, 03:09 PM
Hi Paul

The Description field is sProductDescription in the OrderDetail table and the Explanation field is sCancelMessage also in the OrderDetail table.

Ben

AsleepATheWheel
05-Dec-2003, 09:39 AM
Cheers,

Paul

Jan
05-Dec-2003, 10:23 AM
You can tell that it is an adjustment entry because the product reference is ":::::"

Regards,