Search results

using Access 2010 Hi guys, My aim is to create a customer price quotation form and accompanying report for printing the customer quote. Thus far I’ve created two tables with a one to many relationship (one customer can have many orders). Please see attached. I think this part is sound...

This is an easy one guys, but damned if I can get it working: Im trying to run the following calculated query: Total Value on Order: =Sum([Purchase Price]) In the 'Purchase Order Summary Query' see attached database (2010), I want to sum the total of all purchase prices together so I know the...

Im trying to run the following calculated query: Total Value on order: Sum([Purchase Price]) I want to sum the total of all the purchase prices together so I know the total value on order. I keep getting an error: "You tried to execute a query that does not include the specified expression...

I have a query that is used to calculate job order status in days. It subtracts 'due date' from the 'current date', which is auto completed in table properties, date(). This query is simply used to display which jobs are more urgent than others for production, and are then colour coded using a...