M
markmarko
On our Sales Order Entry Form, I've built a comprehensive 'filter' based on
concatenating strings into the WHERE of sql, which is then used as the
recordsource for the table, thereby 'filtering'. (I did this since some of
the criteria that's being filtered on is in subforms and other related tables
that aren't directly involved with the Sales Order form). I'll refer to this
as the Recordsource-Filter.
Now I need to build an append (make table) query, that makes a record in a
temp table, one record for each Sales Order, and then totals various
Quatities for various Sales Products (from tblSalesDetails) into appropriate
columns. This temp table will then be exported into an excel spreadsheet to
provide to our client.
I have built the Make-Table Query. Currently, it uses all the Sales Order
records. I need to somehow combine that query with the Recordsource-Filter
so that I can use the Recordsource-Filter to narrow down the list of jobs to
send through the Make-Table Query.
The sql of the Make-Table Query is already tremendously complex, and the
Recordsource-Filter sql is somewhat complicated as well...
And thoughts on how to go about this?
concatenating strings into the WHERE of sql, which is then used as the
recordsource for the table, thereby 'filtering'. (I did this since some of
the criteria that's being filtered on is in subforms and other related tables
that aren't directly involved with the Sales Order form). I'll refer to this
as the Recordsource-Filter.
Now I need to build an append (make table) query, that makes a record in a
temp table, one record for each Sales Order, and then totals various
Quatities for various Sales Products (from tblSalesDetails) into appropriate
columns. This temp table will then be exported into an excel spreadsheet to
provide to our client.
I have built the Make-Table Query. Currently, it uses all the Sales Order
records. I need to somehow combine that query with the Recordsource-Filter
so that I can use the Recordsource-Filter to narrow down the list of jobs to
send through the Make-Table Query.
The sql of the Make-Table Query is already tremendously complex, and the
Recordsource-Filter sql is somewhat complicated as well...
And thoughts on how to go about this?