Recent content by keith267

Not sure if I'm explaining myself correctly. But it sounds as though your explaining the process to simply export the query as if I went into the database went to the External Data tab and selected Export Excel. this is not the format I want. as explained above I want to direct Excel where to...

Thanks, yes that's what I meant export the query so I can create an excel spreadsheet (report). I do need the IIF statements because when I query the data I need to extract only the data that meets specific criteria. But I will also need to, in other reports sum all the data. three of my query...

Hello, I've created a query (QRY_Neg-Totals) which total a number of table columns (Proposals-Table). One column is all the elements of the proposal (e.g. Labor, Materials, TotalCost, Profit, TotalPrice, etc) another column is what was negotiated (e.g. Labor, Materials, TotalCost, Profit...

Thank you both. Turns out I a typo in my table the one record which was a "Last Update" had "Negotiations" instead of "Negotiation". I appreciate your help.

Not sure how to do that

I'm using the below code to open two different forms depending on two different variables. But the ElseIf statement is not working? My form gives the selection for ProposalVersion of "Original" and "Last Update". "Original" is recognized but "Last Update" is not. Any ideas Private Sub...