Search results

Morning, Novice when it comes to tables and designing them, and am looking at a way to create a database that will store all the scripts that i create to help me do things as well as maybe keep version control so that if i modify it i can see the modifications and role back if things go bad, i...

Trying to create a query that will look up a barcode and subtract 1 from the currnet stock levels, i have the exact same sql statement for the adding of stock part from the -1 to a +1 the relised i may need a gap between the "-" and the 1 but it still comes up with the message. Anyone got an...

UPDATE Table1 SET Table1.quantity = [table1]![quantity]+1 WHERE (((Table1.barcode)=[enter barcode])); is this query string rite to add a number to the stock of a certian barcode and what kind of validation can be done to check if the barcode exists?

Hi there, i have a database i am setting up with 4 tables and am trying to think of the best way to input new data into it. All the tables are linked and its all based on printers. When a new printer is brought if it exists in the database then thats cool it just needs a Printer number assigned...

Can anyone look at this pdf and let me know if my relations are correct, i know i haven't marked on if its one to many etc but i just need to know if it'll work?