Search results

Excellent!!! Thanks for everyones help, I've got exactly what I needed now Sorry for posting the question in tables and reports, I wasn't sure where the problem lay and wasn't sure whether my tables or report needed changing! Thanks again :)

If I keep the quantity as a numerical field then and use 0 to represent "any" is there any way to display 0 as the word "any" on my report? I'm not sure if this is possible in Access, but I think an IF formula would achieve what I need in Excel. The problem is the report creates a current price...

Ok, I've integrated it into my query but it still doesn't sort the records as I need them. I've checked the datasheet view of the example you created and that doesn't sort them out numerically either... They are still appearing as text 100 1000 150 200 2000 Thanks for your help so far!

Thanks for your help but i'm unsure how to use this. Which parts of the formula do I need to change to relate to my tables and fields? Also do I enter this as a new field or does it become the criteria for my quantity field?

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

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

Excellent! Thanks alot for your help. This problem has been driving me mad for ages I thought a simple solution was close!!!!

The products are tied to the customer by CustomerID in the product table. When I expand the combo box the product name and the Customer ID is displayed. I need to be able to filter the results of the combo box to only display thoses products with the same CustomerID as the CustomerID selected...

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

If it helps I think what I need to do is filter the results of my combo box to only include those products which are assigned to the customer displayed. the filter would then need to update the combo box as the records were navigated. I just included more detail in the first passage incase...

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

It's ok I've sorted it... Thanks for your help :-)

It sounds like the simpler solution recommended by Dana should work. Each recipient could receive the same newsletter, it doesn't need to be personalised. How do I export my recipient list into a CSV file thou? The list is in the form of a query at the moment. Thanks for your suggestions.

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

Cheers Alexei, I've got no problem with waiting till you are free Thanks for all your help Jim :D

I've simplified my database as much as possible to reduce the file size The database should open on the Orders form, where the problem occurs. As you'll see when you click on the drop down box in the subform all labels are listed. Ideally I would like only those assigned to the customer...

I'm not clued up on SQL, Where do I use this code? I've tried modifying it so it refers my table names and inserting it into the row source of my exciting comb box but it didn't work, is it part of visual basic? Do I paste this exactly as it is? Sorry if this question sounds simple, but I...

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