Search results

Novice user here. I have created a database with tables,queries,forms and reports. I'm now trying to create a webpage that will run the reports i have created. At the moment i'm the only user that will run these reports (via webpage) so the database is on my computer. I have created a data...

Eureka!!!! Thank you all. Much appreciated.

No luck Ken. The Update Query seems to only allow you to update based on a value entered in the "update to:" column. It doesn't prompt you for a Table name like the Append Query does. :(

The Append just adds new records to my table. I need to update the existing records in the 2nd Table using the Name field as the link between the Tables. Sorry if i sound confusing.

Thanks Ken. I don't think i phrased my question correctly. Let me try again. I have 2 tables: 1st Table = Name , Age , Weight , Height , Skin type 2nd Table = Name , Location , Sex , Age , Weight , Height , Skin type The 1st Table contains data in all 5 the fields while the 2nd Table only...

I have created a database with 2 tables. I need to transfer data from one to the other. There is one field that is common to both tables. Please help me. Thanks in advance.