Access Queries

[Karma31251]

I need to know if there is any possible way to have multiple queries in Microsoft Access to use the same variable to append records. Basically i need the user to be able to specify a Date Criteria ONCE and have multiple append queries pull according to the date specified. Thanks in Advance Make Peace not War Karma

[Arun Immanuel]

Can U kindly explain the scenario more clearly? Regards, Arun Kumar.A

[Dave Kreskowiak]

Multiple result sets will end up in multiple tables in the DataSet. Access doesn't support batch queries, so each query will have to be run seperately.

Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
     2006, 2007