Recent content by beachy

Hi, I currently have a SOP database which holds all of my customer discount information. The discount information is broken down into three different tables due to the data being incompatible. As a result I have generated three different reports which has a different page for each customer...

Thanks David that works for the group of products but it would not work with the other 2,800 products! If there is a similar function where I dont have to specify the number of characters and it will pick up the first group of number between to groups of text? And then sort correctly?

Thanks I will have a look now!

You are indeed correct a mix of metric and imperial. I am beginning to think that it could be very complicated to sort. I have in the past I have used the =var[] function to sort out the access sorting system but obviously this cant be used in this situation. Is there another function which...

You could repost it as an mdb could you? I have only got Access 2003 on my current machine!

Hi David thank you for your responses. Unfortunately I cant split the field as I have over 3,000 products in my database and they all follow individual patterns! I cant always keep the dimentions at the end of the product name!

Yes it is all one field, It is the product title only.

Hi, I am battling with the access sorting on a combo box. I know that on a text field access sorts on the first number rather than the whole number. As a result on my products combo box the results are displayed as: Solid American White Oak Flooring - Nature Grade - 100mm x 19mm Solid...

Thanks for the welcome! Your example looks perfect just gonna take it apart to see how it works! Many thanks!

Hi everyone, Sorry to ask a question as soon as I have joined but I am really stuck with a timber stock program I am developing. Basically each pack of timber is assigned a four digit ID no. using access autonumbers. We now want to develop the stock system further so that each board is...