Search results

Hi All I am unable to modify the data within the following Query. Is this because there are multiple table joined together? Is there a way around this? Once i receive the data that i retrieve, then i would like to modify them. SELECT subtable.prodid, subtable.name, customers.forename FROM...

Hi All I have a problem with the LOOK UP tab in the Tables Design View. I want to lookup a column from a table called PRODUCTS that has the information in column 2. However, when i open my table, the combo box drop down list always has the values of the FIRST column in it. How can i get...

Fantastic George, it works perfect now. Its a shame that Access doesnt give a warning about trust settings, it would have saved alot of time for me. Anyhow, thanks

Yes, when i press the red !, the table still is the same - no records have been added to it. I dont understand why. p.s. i dont get no error messages either

Hi George Thanks for your reply. Im trying to learn SQL so i can use it with VBA. I am using the statement mention previously into the SQL view. I run the query and nothing happens. Im wondering what im doing wrong?

Hi this still doesnt work. how do i execute this? currently im pressing the datasheet view button, is this correct?

Hi All Im trying to add new records to the 'age' table, but it wont work, what am i doing wrong? INSERT INTO age ( age, letter ) VALUES ('39', 'Z')

Hi All I have the following query that brings back data greater than 01/02/2008. However, its reading it in American Format i.e. mm/dd/yyyy In my table I have it in the UK format i.e. dd/mm/yyyy. I want the query to return the results in? I know that its easy just to change the query to...

Hi All How can i incorporate all Letters that names.id <> left(forename,1) SELECT names.id, count(left(forename,1)) as count FROM customers, names WHERE names.id = left(forename,1) GROUP BY names.id at the moment it returns A 1 B 3 E 5 but i want it to show all the values, i.e. A 1 B...

Fantastic. I did what you said and it appeared that in the customers table i had Age as a Text type instead of a number, and in the other table the age was a number type. Anyway, it works perfect.' But, one thing, how important is it that the two fields that are being related in the WHERE...

Hi I am getting a type mismatch error. If i execute the following statement it runs fine, but when i add the where clause it stops running. SELECT forename, surname,letter FROM customers, table1

Hi All The following statement will not execute. Can someone tell me what im doing wrong? Im trying to build a relationship between the two tables to get back specific results. SELECT forename, surname, letter FROM customers, table1 WHERE table1.age = customers.age Thanks

Many thanks Wayne

Hi All Can some tell me what im doing wrong. Im trying to bring back Any field that begin with A or B using the IN Statement. Thanks SELECT country, name, amount FROM tblcountries WHERE Name IN ('A*','B*'));

Thanks Bob, I will go to your website now.

Thanks Bob, its just that i bought a Microsoft Book Access 2003, and it says you can do it. But i have only got 2002, so thats probably why i guess. Also, im a Pro a Excel including VBA programming, so i was wondering which application would you say is more difficult to master Excel or Access...

Hi All I have Access 2002 and I want to know how i can have the data sheet view and SQL view open at the same time in a Query. This would make it easy for me to learn SQL whilst i populate the data sheet view of the query. Thanks

Ok thats great. It works now.

Hi All I have two atbles - both have a column called CustomerID. Im trying to enforce Referential Integrity between the two but it wont let me. 1) Can someone explain the benefit of this 2) Why doesnt it allow it - message says (Data voilates Referential Integrity rules, there may be...

Hi All I have two tables and I have numerous textboxes on my form. Im trying to link the text boxes to each column within my tables. It works fine for one table as i choose the table from the Data - Record Source, but it wont let me choose two tables to link to the Form. I have even tried...