Recent content by pldd4

Those fields do now exist. It does work i'm just not very experienced with queries/sql, so thought id just ask to see if you could see any downfalls or bugs etc. Regards,

Thanks for that, great help :) Ive had a go myself, seems to work fine. Is there anything you can find in this sql query which could produce bad things!? or not work etc!? ----------------- SELECT [product id] AS Product_Code, (SELECT Nz([OS]) FROM [Product Table] WHERE [Product id]=[order...

Ok ive done those 8 querys, just never done a form like you described. Plz help. I cant attach new db with querys in as its too big zipped. Cheers,

Not to sure what you mean fully with regards to the forms You can email me it on pldd4@aol.com Thanks

ok thanks for your efforts. Eventually i believe the user will enter and view data via forms. But ive not done that at this stage, just wanted a basic working structure first!:rolleyes: So how would you of done this? I'd be interested to know what you'd do whilst trying to keep it as similar...

Hi, Ok heres my database as i first had it before you suggested changing it. It might help to explain it better for you. As you can see in the query Orders_Placed_By_Week this calculates nicely the total number of orders for each product for each week, which is great, thats what i want. But...

ok, 1 - The customer is another company 2 - The company uses weeks, 1 - 4 weeks, its just the way they work. Not my company and thats the way they want it. I know its odd, ive spoke to them about these issues and they just dont like change! 3 - Product ID is completley unique with this...

Sorry try this one. This has the look ups on it! again a rename to a .zip file

Thanks mate. :) Really appreciate it. Hopefully it should be attached. Ive renamed it .bmp Its a zip file so rename it to .zip Cheers

Ok i'll change those. I take it you meant the Production Table not the Product Table? So if i do what you say can we try and sort that query out? Will it then be possible to do it? :)

I completly agree with you. But this is how the company wants it doing. (Friend of family). Theyve been using a similar paper method, as you said the stock goes into a minus figure if an order comes in (this is what they want!!) However you mentioned i was duplicating fields in tables, the...

Can no one help me on this?? :confused: Anything at all will help i''m sure :D Thanks

Hi everyone, Very new here! I'm creating a database to keep track of orders and stock nothing too complicated. Its virtually finished, just one little bit left which I'm not sure how to do. Hopefully someone can help me! :) Database description. I have a Customer Table (Showing customer...