Hi Richard,
You know when you want to create a query but you can't do all the calculations in one cos Access doesn't like it so you create one query then base the next one on that ...
I'd like to do this on my website but I'm having trouble.
I Dim'd an SQLstr with the initial qry and then based the second one from that string but it throws an error 'can't find'.
I don't want to use stored procedures/queries from the database as i'd like to make the query dynamic depending on the user's input.
Any ideas?
Alex

---

Reply from Richard Rost:

Yes, I know what you're talking about. Sometimes it is just easier to place a query in your back-end database, though. If you need to use parameters and you need multiple queries, you might end up having to use two recordsets to generate your results... or at least one query and a recordset. Without more specifics, I can't be of much more help though.