PC Review


Reply
Thread Tools Rate Thread

Re: crosstab

 
 
Duane Hookom
Guest
Posts: n/a
 
      18th May 2010
Typically you don't need to create a new table. Just use queries unless
there is some compelling reason why you can't.


--
Duane Hookom
MS Access MVP


"Mickey" <(E-Mail Removed)> wrote in message news:2010051718170216807-oik@mecom...
> Hi,
> New to Access and have inherited a database at work, I need to create some
> crosstab queries and am unsure if I would be better off creating a new
> table from a query to hold the data for the crosstab query or is it okay
> to run a query and then use a crosstab query on that first query?
>
> The crosstab query appears to work fine when using the initial query as a
> source but can someone advise me if that is okay to do?
>
> Thanks,
> Mickey
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating Crosstab Reports from Crosstab Queries vincelts@singnet.com.sg Microsoft Access Reports 4 25th Feb 2007 02:04 AM
To Crosstab or not to crosstab OMS Microsoft Access Queries 12 31st Oct 2006 06:58 PM
Crosstab form based on Crosstab query? Penny Microsoft Access Forms 1 31st Mar 2006 07:36 PM
Crosstab query with criteria, dynamic columns and crosstab report question joshblair Microsoft Access Queries 5 13th Jan 2006 10:34 PM
To crosstab or not to crosstab ... That is the question Tom Microsoft Access Queries 1 9th Sep 2003 01:32 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:05 AM.