Search results

A massive thank you, :) really couldn’t have visualised the table design and agree I have plenty to be getting on with as regards implementing all the required changes. Once I’ve worked my way through this lot, I’ll repost the table design (inc relationships) as a actual database so you can...

CJ_London, thanks for the fast reply. Its back to the drawing board then, can I ask a few more pointers (literal instructions, truth be told) before I make another mess of things and end up back on the forum? Firstly, agreed on the report, if I can get the main form up and running I’ll be...

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...

Thank you, you nailed it first day. Great reply, thanks again :D

Thanks for reply, I'll be both correct and specific in next post

Thanks, I'll take a look at your changes and see if I've more of a prob now.

There is defo a query called purchase orders summary. Please have another look

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...

I'll try that Galaxiom and let you know how I get on, any idea why I have to insert into footer, not just run it inside my main table srtuctured query summary form

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...

got it, subtracts date delivered from current date, >90 days, not displayed.

Thanks, justification for maintaining all data makes sense. But can you tell me how to hide records after they are set as "y" in the delivered field? Thanks

SOS, final question on this. Each record in the order form has a 'delivered' field, which is just y or n in table properties. For data maintenance I'd like the record to be automatically deleted from the database when delivered is set to y. Is this straightforward to achieve or does it involve...

Thanks SOS, thats it sorted! whilst you're in the prob solving mood, perhaps you can shed some light: I have a form with a conditional format which highlights in colour the one field that is active for the expression being 'true'. is there anyway of making the entire record highlight in colour...

Can you explain more in really dumb terms for me please? Remove current date completely from table and just run query like you suggest? BTW,Thanks for the quick reply

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...