Search results

Okay Thanks very much I will try it. UPDATE: IT WORKED!!!!!!!! Thanks. I may have a few more problems so watch this space(!)

I have tried both ways but I am still getting random results. Rather than the two I want I get 8 records once, and the other two times 3. I've changed the word date to order date and the dates are now in american format. This is the last thing I did: INSERT INTO OldOrders SELECT * FROM Orders...

Hi guys. I've just entered this SQL to insert data into another table. INSERT INTO OldOrders SELECT * FROM Orders WHERE OrderID IN (Select Orders.OrderID From Orders INNER JOIN OrdersDetails ON Orders.OrderID=OrdersDetails.OrderID WHERE (Orders.Date Between '01/01/2008' And '01/02/2009') )...

Thanks guys. However I feel access isn't the most user friendly and doesn't help you out well enough when one is in trouble. Thier error messages leave a lot tot be desired. Maybe you can send this feedback back to Microsoft.

Uh huh. Thanks that cleared a lot up and will hopefully ensure me to do things by myself now. The only problem is sometimes I have to get the format correct i.e. where the breackets go, which line etc. This is one of the queries I done with your help. I don't know how it worked but it did...

Yeah I was trying to append it yes. BTW what is the answer to your signature (PORSCHE QUESTION) aswell. It's really bugging me. (LOL).

Yeah it did crap out. Dang.

That seems so simple. I'll try it and thanks very much. But there is no INSERT Into.

So I would have to do: INSERT INTO No_Orders (the table) SELECT Customer ID, Sname, Fname, Address, PostCode, Phone, OrderID FROM Customer, Orders I don't know the next step but I thik I have to do some sort of INNER JOIN. This is getting...

I executed it and it worked. I have now opened thanks but there is no data. I know I haven't specified it but is there a way where you can insert data from different tables using the same DDL statment? CREATE TABLE NO_ORDERS ( Sname varchar(20), Fname varchar(20), Address varchar(30), PostCode...

Okay thanks. I have done what you have recommended. The create table worked but I can't open the query again as it says the table has been made, in this case the No_Orders table. I can open that new table but not the query I made it with.

Hi sir. Thanks for your help. Regarding looking for access help; they all follow the same layout and it goes wrong. I have no spaces while I'm not familiar with String and what it means. Thanks.

I want to practice making queries but it doesn't seem to work. I can do basic SQL, but SQL DDL doesn't work. Same applies for DML although I am following the correct steps. Please help. For example CREATE TABLE. This is what I have done thus far: CREATE TABLE NO ORDERS (Sname varchar(20)...

Thanks Dkinley for your help it has been fully appreciated. It works so thanks for getting me thus far. Thanks also Bob Larson.

So what I have done is correct? However is this normalized? Just in case I want to do a query. Thanks a million.

Hi thanks for the help. Just one thing. When you get rid of the order details ID in the Products table this means the table won't have a one to many relationship. This is what you have told me (hope I'm not wrong): This is what my customer table has when you click on the plus signs. The above...

I've done the second point you have made but the problem still remains in that a different person can't order the same product (e.g. Bread). I'm not fully in understanding of your first point however. How do I relate it and does it allow more than one person to order the same product. Thanks...

Hi. I need some help for my online shopping table prototype. I want to be able to allow data to be entered which shows that customers can buy the same products. I can't do this because the Product ID is a primary key in the product table. So if someone wants to buy a bread say, then the database...