Recent content by deanm5

  1. D

    Parameter Make Table Query-passing the table name - HELP!

    This query pulls data from several different tables based only on the dept number [DeptNo]. I export the results of the query to a separate table for each record so that I can then spin through the list of tables and export the data to a excel template file that is pre-formatted. Each of these...
  2. D

    Parameter Make Table Query-passing the table name - HELP!

    Because, I am running this query through code and loop through a recordset of 129 records. Each record is a dept number that feeds the query and with the results, produces a table that I need to save. If I do a form field, then I have to enter the dept numbers by hand. Running this and...
  3. D

    Parameter Make Table Query-passing the table name - HELP!

    hello, I have created a make table via a parameter query. The parameters are defined correctly and I am prompted each time to enter them. the DeptNo does work as my query is filtered based on a value entered, but when I enter the tablename parameter, the make table query always saves the...
Top