• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 133
  • 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
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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