Solved

How to make CrossTab Query a table

Posted on 2014-12-29
9
117 Views
Last Modified: 2015-01-05
How do you make CrossTab Query  a table
0
Comment
Question by:Jass Saini
  • 3
  • 2
  • 2
  • +2
9 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 40522761
0
 
LVL 30

Expert Comment

by:hnasr
ID: 40522837
Do you mean reverting the cross tab to original table, or creating a make table query?
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 40522874
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
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 40523030
oh maybe you mean this

Select CrosstabQuery .* Into NewTable
From CrosstabQuery
0
 
LVL 35

Expert Comment

by:PatHartman
ID: 40523824
Why are you making a temp table?  Why can't you use the crosstab directly as the RecordSource for the form/report/code?
0
 

Author Comment

by:Jass Saini
ID: 40525931
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
 

Author Comment

by:Jass Saini
ID: 40528288
Hello Pat,

I am using a Crosstab query is that what you are asking
0
 
LVL 35

Accepted Solution

by:
PatHartman earned 500 total points
ID: 40529837
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
 

Author Closing Comment

by:Jass Saini
ID: 40531613
Thanks Pat..I think my boss is agreeing to thing that cannot and should not be doen.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question