Beach Access Software
bchacc at san.rr.com
Mon Nov 27 14:19:55 CST 2006
So table one contains the field names of table 2? Rocky P.S. Swing by my office with your laptop and I'll do it for you on the spot (yes I have an ulterior motive). -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bob Heygood Sent: Monday, November 27, 2006 11:24 AM To: Access Developers discussion and problem solving Subject: [AccessD] DAO Fiekd Name String/Variable Hello to the list, I woild like to: 1. get a value from one table as a string 2. lookup the value of a field in a second table where the field name = the value of field in table 1 Using !s if possible. TIA best Bob -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.430 / Virus Database: 268.14.16/552 - Release Date: 11/26/2006 11:30 AM