Search results

My database contains an Orders form from which the user can select the customer who is placing the order via a lookup. The database also contains a Product form from which the user is able to select the customer, using a lookup, and enter the product name. Products are exclusive to individual...

My database contains an Orders form from which the user can select the customer who is placing the order via a lookup. The database also contains a Product form from which the user is able to select the customer, using a lookup, and enter the product name. Products are exclusive to individual...

Nothing as complicated as that... We sell labels to several customers so each customer has their own unique ranges (each customer has several ranges). When I said the items can have very similar names I meant the range name eg Christmas Labels. The Labels are stored in the label table by the...

My database contains an Orders form, from this form the user can select which customer has placed an order using a lookup from the Customers table. The Orders form also contains a subform, named OrderDetails on which the order details are entered. From this subform the user can select the item...

Yet again you solve my problem! I'm not bothered if theres a tidier way, it works and thats good enough for me! Thanks again :D

Damn it! :mad: Seems it hasn't worked as well as I thought The date displayed is correct for every customer but I can no longer add records to my Customers table using the form. I have traced the problem and it appears on the 2nd query where the max order date is displayed with the...

Cheers DBL thats sorted the problem out! Thanks again :D

I think this should work for you in a select query FieldName Total: Sum((Abs([FieldName]))) Hope it helps Jim

My database contains an orders table and a customers table. Each time an order is placed a different order date is entered. I need the most recent order date to be displayed on the customers form. I originally attempted to do this using an update query but was advised to just display the most...

Thanks for the advice and I'm sure it would work if I could write it properly! I've never used DMax() before, I've had a go but the same date displays for every customer, the date displayed is the last order date of any customer, i.e. it is not specific to the individual customer...

My database contains, amongst other items, a companies form and a orders form. I have a field on my order form to insert the order date. On the Customers form I have a filed called date last ordered. I need to be able to fill the date last ordered field with the most recent date from the...

Excellent!!! :D Thanks for your help.

Hi I need to use my database for a mail merge to create labels. The problem is that my contact details are entered into two seperate tables through a form and a subform. My Customers form has a contacts subform to allow me to enter contact details for more than one employee per customer. I...

Cheers Namliam, thats done the trick!

I have a form to note how new customers hear about the company I work for, the form is just a list of options with yes/no checkboxes. I want to create a query to count the number of each option to be able to then create a graph from the totals I have tried to use the count option but this...

The Report is already based on a totals query, each order is actually made up of seperate items within a category so the query totals these seperate items and displays the total for each order date. What I need to do is then use these totals to create monthly totals. This would be required if...

I have created a report to display total sales values for each month, the original orders are entered using the actual date, e.g. 03/08/2004. The report runs off a query which lists each individual sale, I have then attempted to group each sale into a monthly sales total. I have been able to...