B BlindPro Registered User. Local time Today, 05:33 Joined Jun 16, 2012 Messages 40 Aug 4, 2012 #1 Hi, I have a query with 3 Column DLookup Function, the query is 'make-table' Type, and when i run it, all Dlookup columns will be null
Hi, I have a query with 3 Column DLookup Function, the query is 'make-table' Type, and when i run it, all Dlookup columns will be null
P plog Banishment Pending Local time Today, 07:33 Joined May 11, 2011 Messages 12,060 Aug 4, 2012 #2 This sounds bad for a lot of reasons. Why do you have Dlookups in a query as opposed to bringing into the query the datasource those Dlookups are looking into? Why are you using a MAKE TABLE query out of this data as opposed to a SELECT query?
This sounds bad for a lot of reasons. Why do you have Dlookups in a query as opposed to bringing into the query the datasource those Dlookups are looking into? Why are you using a MAKE TABLE query out of this data as opposed to a SELECT query?
B BlindPro Registered User. Local time Today, 05:33 Joined Jun 16, 2012 Messages 40 Aug 5, 2012 #3 because the query based on alots of other queries, and for make db fast, last query result move to a new table.
because the query based on alots of other queries, and for make db fast, last query result move to a new table.
B BlindPro Registered User. Local time Today, 05:33 Joined Jun 16, 2012 Messages 40 Aug 5, 2012 #4 All My problem is Just this, If you know other solution I don't create make-table query
