Search results

My database contains a table of quotation details. One field specifies quantity. In most cases the higher the quantity quoted the lower the price offered. However in some circumstances a set price is offered regardless of quantity purchased. If I set the datatype for the quantity field as a...

Hi everyone! My database contains two tables. The first table containing customer details and the second table product details. As the products are bespoke they are assigned to a customer (no two customers can order the same product) I have an order form which contains a subform. On the...

My database records order details for analysis. I have created a form to monitor individual trends in orders placed by my customers. As we supply bespoke items each customer has a list of products which they alone purchase, i.e we do not supply stock items, each item is specifically for one...

I simple question I think... My database contains a form and a report. At the moment the report displays the results of every customer in my database. I would like the report to be lauched from a button on my form and filter the results displayed so that it only shows the results of the the...

I have a database that I use to track marketing efforts. Amongst others I have three tables; customers, contacts and marketing activities. At the moment I have two separate forms, one form shows the customer details (the address, tel. number etc) with a subform containing the contact names for...

I want to send an email via Outlook to customers in my Access database. I have created a query to select the recipients. The problem is I don’t want to send a text document I want to send a newsletter. The newsletter can be saved as a pdf, jpeg, tiff etc. I’ve tried using MS Word to solve...

In my database I have a Customer form and a Product form. The products are assigned to specific individual companies as each customer has their own exclusive range. On the Customers form I have a command button which runs a macro to open the Products form. At present the form is opened as a...

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

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

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

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

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

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

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