Recent content by dewsbury

Greetings from Dublin! This must be so easy but I can't figure it out. I have one table with fields of employee number, employee name , address, phone number. I want a new FORM where I key in the employee number and THEN the employee name is displayed automatically. What properties do I give...

Hi, I am sure this is easy! I an very familiar with relationship databases but new to access. I want to create a new table based on the result of a query. E.g. in the Northwind database I want to query the customer table and create a new table with only the customer name and city in it. All...

Thanks for your help. (I am a relatively experienced user of Informix Sql). I had hoped it was possible to put more than one SQL statement in an Access SQL script. Since this is apparently not possible how do I achieve more sophisticated SQL matters. E.g. on a monthly basis I want to run a...

Hi, This is probably a fairly basic query... I am familiar with SQL in general but new to Microsoft Access. I want to do multiple commands within one query but cannot. Simple example: Select * from file1 where name1="bob"; Select * from file1 where name1="tim"; I get an...