Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.basic.visual.misc > #1190
| From | colmkav <colmjkav@yahoo.co.uk> |
|---|---|
| Newsgroups | comp.lang.basic.visual.misc |
| Subject | run queries with date parameters and storing results in new tables (BEST WAY) |
| Date | 2012-06-07 06:35 -0700 |
| Organization | http://groups.google.com |
| Message-ID | <0ed72be6-5a01-4ecd-bdfe-38506aed8020@s9g2000vbg.googlegroups.com> (permalink) |
What is the best way to approach my problem: I want to run a series of Access SQL queries (currently 13) eg qryRule01 and store the results in tables of the similar name eg tblRule01. I also wish to use a date parameter which will usually be the previous days date. How best is it to do this? Currently the queries run fine on themselves when I hardcode the date to =date() in the SQL queries but when I try to use VBA and run the queries and return the results to a new table using “SELECT * INTO…” and use parameters for the dates I get overflow errors. What’s the neatest way to solve this? Colm
Back to comp.lang.basic.visual.misc | Previous | Next — Next in thread | Find similar | Unroll thread
run queries with date parameters and storing results in new tables (BEST WAY) colmkav <colmjkav@yahoo.co.uk> - 2012-06-07 06:35 -0700
Re: run queries with date parameters and storing results in new tables (BEST WAY) "Ivar" <ivar.ekstromer000@ntlworld.com> - 2012-06-07 15:13 +0100
Re: run queries with date parameters and storing results in new tables (BEST WAY) Deanna Earley <dee.earley@icode.co.uk> - 2012-06-07 15:48 +0100
Re: run queries with date parameters and storing results in new tables (BEST WAY) colmkav <colmjkav@yahoo.co.uk> - 2012-06-08 00:40 -0700
csiph-web