Recent content by MKaprielian

Hi I haven't done much with manipulating SQL in Access. My query is: SELECT qry_2800_Package_Rollup.*, qry_5000_Selected_Product_Codes.* FROM qry_2800_Package_Rollup INNER JOIN qry_5000_Selected_Product_Codes ON qry_2800_Package_Rollup.PFC = qry_5000_Selected_Product_Codes.PFC_CODE; My Where...

I haven't been able to figure out how to grab the query and add the additional filtering info without altering the saved query. An example of doing this would be helpful.

I have searched the forums and found some scenarios that seem similar to mine but I can't see how to apply them to my situation. My forum search was "WhereCondition for DoCmd.TransferSpreadsheet" I have code that calls the DoCmd.OpenReport in a loop passing different a different WhereCondition...

Thank you for the sample code. Been away on vacation, I look forward to seeing if I can make this all work. Thanks Mark

Hi Thank you both for your advice. Do you have sample code available that shows how to do this ? Thanks Mark

Hello Using Access 2007 or 2010 I have an Excel file containing links to an Access query. The Access database process the data and the Excel spreadsheet graphs the data and publishes it a web page upon exit. Currently my process to update the web pages produced by Excel is as follows...