Drew Wutka
DWUTKA at marlow.com
Fri Jan 19 09:12:22 CST 2007
Not by itself, but you can feed it into a query using a custom function, but you still need an actual table as the recordsource. Drew -----Original Message----- From: Kaup, Chester [mailto:Chester_Kaup at kindermorgan.com] Sent: Thursday, January 18, 2007 9:56 AM To: Access Developers discussion and problem solving Subject: [AccessD] Array as source for query I think I know the answer but in VBA can an array be used as the source data for a query instead of a table? If so how? Thanks. Chester Kaup Engineering Technician Kinder Morgan CO2 Company, LLP Office (432) 688-3797 FAX (432) 688-3799 No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com