Search results

Thanks Brian, that works great! I remember learning that a few years back now, thanks for reminding me! Emily

The 3rd scenario sounds like it! How would i create this join? Emily

Cannot seem to find an answer to this, but please point me in the correct way if you know of one! Quite simple i think, but blank mind at moment! How would i use the values in a table/query as the criteria for another query? I believed i could type in [qryOne]![classification] in the criteria...

Im not sure exactly, but there are two or three other databases i believe which use information from this XL spreadsheet, and then maybe 10 people who use each database? Emily

i could not open that test.zip file, my computer will not allow me to at work for some reason. Thanks for the info though, and if i find some amazing way of doing it, i will let you know. Problem is, i have about 3 days until i go back to university, so i'm gonna be in trouble if its not...

hmmm, seems like ive got to a point where im stuck then, as, to be honest, my programming skills are virtually non existent with exception of a few basic bits and bobs! I did think that these headings were going to cause a bit of trouble...i'm going to try and take your advice by producing...

I only need the manufacturer, product, sub-system and part Number. From this excel spreadsheet, you can probably see what the relationships are. Any help would be greatly appreciated Emily

I will upload a copy of part of the excel spreadsheet which i need to import. Is this the data you ment? Emily

I have imported the whole excel spreadsheet into the database. I believe i need a number of queries, which will find each company, and put each product into the product table related to that specific manufacturer. Could anyone give me an idea of the kind of query i will need to do this? Or is...

The EL spreadsheet is updated by a different person for pricing, and is used in a number of other databases and XL spreadsheets. Neileg, the spreadsheet has the correct columns, but nothing else. What would need to be added? emily

The problem is, i need it to be updated every week, and it cannot take too long to do it, is there any other way around this that can be incorporated into the click of a button? Emily

I have a stock control database which i have nearly completed. This has Manufacturer, which is linked to products, which is linked to Sub Product(which also has field partCode). i.e. Manufacturer1 can have 3 products, and each of these products could have 5 subsystems and partcodes. Each...

Brian i have definetely done it now... A few tiny small changes including the main one, changing quantity from text to number did it!!! Oh well, i guess it wasnt as deep as we suspected! Thanks a bunch, Em

i was wrong, its not :(

hey i think its working! i stole a few bits of that SQL and i think its working! Will have to try out a few values and see, but i think its good! Thanks very much for the help, and the quick, indepth replies! You have been great! Hope you enjoyed the footy! Off to finish this db for my dad now...

ok well thanks very much for the help anyway! i will try and sort out the db so i can zip it using winzip 9, and if so, i will contact you. Thanks anyway Brian, you have been a great help! Emily

right here we go, let me try again... qryTotalQuantityAllocated SELECT qryPartCodesAlreadyAllocated.PartCode, Sum(qryPartCodesAlreadyAllocated.Quantity) AS SumOfQuantity FROM qryPartCodesAlreadyAllocated GROUP BY qryPartCodesAlreadyAllocated.PartCode; qryTotalFree SELECT...

hang on, i really think i have done something whilst copying the SQL statements! let me have another go. The problem is, i have the database on a laptop, which is not connected to the net at the moment. So having to work between computers! At work, dont ask...

I have taken the NZ part out again so that it works if not null so the SQL here is without that. query - qryTotalQuantityAllocated SELECT qryPartCodesAlreadyAllocated.PartCode, Sum(qryPartCodesAlreadyAllocated.Quantity) AS SumOfQuantity FROM qryPartCodesAlreadyAllocated query - qryTotalFree...

i have tried to download winzip 9.0 but i cannot find it anywhere anymore! Only 11.1! i guess its not going to be possible! :( Thanks anyway for all the help, Emily