Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.basic.visual.misc > #1370
| Path | csiph.com!usenet.pasdenom.info!aioe.org!.POSTED!not-for-mail |
|---|---|
| From | Deanna Earley <dee.earley@icode.co.uk> |
| Newsgroups | comp.lang.basic.visual.misc |
| Subject | Re: VBA code to dynamically create an SQL query for Access db |
| Date | Wed, 18 Jul 2012 17:54:22 +0100 |
| Organization | Aioe.org NNTP Server |
| Lines | 27 |
| Message-ID | <ju6pnq$sjk$1@speranza.aioe.org> (permalink) |
| References | <1e0600a4-e7ef-4eff-9001-45c41482ec1b@googlegroups.com> <ju6hrm$7pt$2@speranza.aioe.org> <141ae15f-9c79-44e1-bfef-d894b1f96715@googlegroups.com> |
| NNTP-Posting-Host | rjApkXnSOjrT83QpZ8fKqg.user.speranza.aioe.org |
| Mime-Version | 1.0 |
| Content-Type | text/plain; charset=UTF-8; format=flowed |
| Content-Transfer-Encoding | 7bit |
| X-Complaints-To | abuse@aioe.org |
| User-Agent | Mozilla/5.0 (Windows NT 6.1; rv:13.0) Gecko/20120614 Thunderbird/13.0.1 |
| X-Notice | Filtered by postfilter v. 0.8.2 |
| Xref | csiph.com comp.lang.basic.visual.misc:1370 |
Show key headers only | View raw
On 18/07/2012 16:10, colmkav wrote: >> >> Oh, and multiple tables like that containing the same type of data went >> out of fashion ages ago. >> Why not a simple table as such: >> Client-ID RuleNum >> 1233 0 >> 6725 20 >> 4545 1 >> 6725 7 >> 1233 19 >> > The purpose of the table is that all the rules the client (eg 1233) had breached is summarised in 1 row. ie easy for the customer to read the report. Yes, that's the point of a crosstab query. -- Deanna Earley (dee.earley@icode.co.uk) i-Catcher Development Team http://www.icode.co.uk/icatcher/ iCode Systems (Replies direct to my email address will be ignored. Please reply to the group.)
Back to comp.lang.basic.visual.misc | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
VBA code to dynamically create an SQL query for Access db colmkav <colmjkav@yahoo.co.uk> - 2012-07-18 04:54 -0700
Re: VBA code to dynamically create an SQL query for Access db Deanna Earley <dee.earley@icode.co.uk> - 2012-07-18 15:39 +0100
Re: VBA code to dynamically create an SQL query for Access db colmkav <colmjkav@yahoo.co.uk> - 2012-07-18 08:10 -0700
Re: VBA code to dynamically create an SQL query for Access db Deanna Earley <dee.earley@icode.co.uk> - 2012-07-18 17:54 +0100
Re: VBA code to dynamically create an SQL query for Access db ralph <nt_consulting64@yahoo.com> - 2012-07-18 12:24 -0500
Re: VBA code to dynamically create an SQL query for Access db "Farnsworth" <nospam@nospam.com> - 2012-07-18 15:03 -0400
Re: VBA code to dynamically create an SQL query for Access db colmkav <colmjkav@yahoo.co.uk> - 2012-07-19 01:24 -0700
Re: VBA code to dynamically create an SQL query for Access db ralph <nt_consulting64@yahoo.com> - 2012-07-19 11:00 -0500
csiph-web