M
Marco Alting
Hi
I have three queries in a database which depend on each other. It's a
cost-totalling database. It's sort of a Hierarchical query system. In Access
everything works great, in fact using it this way it also works great in my
ASP application. But now we want to be able to select an EntryDate in the
third query which the influences the second and the first query. This can be
done using a HAVING statement in Access, but I want to be able to set the
date from outside the database (preferably an HTML form).
I hope this makes sense, and that someone can help me out here.
I have three queries in a database which depend on each other. It's a
cost-totalling database. It's sort of a Hierarchical query system. In Access
everything works great, in fact using it this way it also works great in my
ASP application. But now we want to be able to select an EntryDate in the
third query which the influences the second and the first query. This can be
done using a HAVING statement in Access, but I want to be able to set the
date from outside the database (preferably an HTML form).
I hope this makes sense, and that someone can help me out here.