Search results

I haven't turned PM off, guess it is because I am still under 10 posts, Thanks for trying

Seems like I have ground to a halt then. Thanks for trying to PM it would have been useful Gary

Namliam, really appreciate your help, it is so hard to explain. It is quite possible that the same supplier or customer will appear in the database numerous times. I only want to pull out the stock currently held, and where it was purchased from. I would like to be able to show you the DB so you...

I understand what you are saying, but the stock number only ever refers to one item, never multiple (Each item has a serial number, and is unique). The purpose of this DB is to accept the item into stock, and if sold not to show it in the current stock levels. Potentially, the same item could be...

You are right about the naming convention, this database would have to be re-written from scratch, something I intend to do when I know that all the aspects of it work. The purpose of the query is to show current stock along with the person / company it was purchased from. It may well be that...

Please have some patience with me as I am a newbie. I have tried to apply the criteria as you have suggested, and the results are correct. The query returns all the single entries. However If I try and now add Customers details, address etc to that query, I immediately get the second entry added...

Thank you for your suggestion and the additional reading with regards Access convention, been looking for something like that for a while. Unfortunately work beckons for the next day or two, so will come back to you with my results as soon as I can, Thanks again

Thanks for the welcome, even with a little bit of politics, a little bit of satire. When do we vote to see if we want to let them stay ? lol

I have built a database that shows the purchase of items that have serial numbers, and so are unique. The database shows the purchase oe each item, and subsequent sale, including "Date In" and Date Out". Each "item" however has a unique transaction reference (Stock No.) I would like to be able...

Hi all, Just like to say I wish I had discovered this forum weeks ago, have already learnt an awful lot from the posts already. I have been building databases, for a year or two, but I am self taught, everything from a book or the web. I have to admit that SQL is something I have no experience...