• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 139
  • Last Modified:

How to make CrossTab Query a table

How do you make CrossTab Query  a table
0
Jass Saini
Asked:
Jass Saini
  • 3
  • 2
  • 2
  • +2
1 Solution
 
Rey Obrero (Capricorn1)Commented:
0
 
hnasrCommented:
Do you mean reverting the cross tab to original table, or creating a make table query?
0
 
Dale FyeCommented:
Take a look at my article on temp tables.temp tables.  You can simply pass that subroutine the name of your query and the name you want to give your new table.

UpdateTempTable "NewTableName", "CrossTabQuery"
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
Rey Obrero (Capricorn1)Commented:
oh maybe you mean this

Select CrosstabQuery .* Into NewTable
From CrosstabQuery
0
 
PatHartmanCommented:
Why are you making a temp table?  Why can't you use the crosstab directly as the RecordSource for the form/report/code?
0
 
Jass SainiAuthor Commented:
Hello Pat,

My boss keeps changing her mind.  My form was based off the orginal table.  I don't want to change my form..also how do you drop down options in a table or can you not?
0
 
Jass SainiAuthor Commented:
Hello Pat,

I am using a Crosstab query is that what you are asking
0
 
PatHartmanCommented:
You seem to have changed the question.  Crosstabs usually have variable columns but sometimes you can force them to be fixed.  For example, if you always want to show 12 months, you can add a ColumnHeadings property and that will fix the number of columns so even if you don't have data for March, March will still show up where it belongs.  

The second question sounds like you are asking about table level lookups and all I can say about that is DON'T DO IT!!!!!  It results in nothing but trouble once you move into queries and code.  They are only a crutch for people who don't know how to write queries.  Once you know how to write a query, you have no need for them.  All your maintenance is done via forms anyway and that is where you need the combo to be.  NOT in DS view of a table or query.
0
 
Jass SainiAuthor Commented:
Thanks Pat..I think my boss is agreeing to thing that cannot and should not be doen.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now