creat a new table from Form

  • Thread starter Thread starter var
  • Start date Start date
V

var

Hi

I have a Form with a command which runs a crosstab query and i want to
create a table with the Form output. is it possible to create a new
table from the Form output ......is this possible

any suggestions

var
 
Hi

I have a Form with a command which runs a crosstab query and i want to
create a table with the Form output. is it possible to create a new
table from the Form output ......is this possible
Click to expand...

No; but you can create a Table from the Crosstab query. Base a
MakeTable query on the Crosstab query and execute it.

Note that such a table *will* be incorrectly normalized and probably
SHOULD NOT EXIST; if you're assuming that you must put the data into a
table in order to use it, reconsider this assumption! You can base a
Form (not updateable, but you wouldn't want it to be), Report, or
Export directly on the crosstab query.

John W. Vinson[MVP]
 
Hi John,

thanks you for basics, the problem is i am not able to generate a
Report from my cross tab using a wizard, since the Available Fields
(left had side box) is shown empty...be's of this i am trying to
generate a report from my Form

moreover my query works fine and gives the expected results,what i want
is when the user chooses the Command on the Form it should run the
query and show the final Report.........

i am very new to access, can you pls give me some suggestions to make a
desired Report from a crosstab query............

var
 
thanks you for basics, the problem is i am not able to generate a
Report from my cross tab using a wizard, since the Available Fields
(left had side box) is shown empty...be's of this i am trying to
generate a report from my Form
Click to expand...

Correct. Since the fieldnames in a Crosstab query are unknown until
you actually run the query, the Wizard has no way to build a report.
You'll have to do it yourself - open the crosstab query in datasheet
view and note the fieldnames, and then build a Report using those
fieldnames as the Control Sources for textboxes.

John W. Vinson[MVP]
 
Hi John,

I will try that ..

is there any sources available for me to read and understand some good
basics on these kind of topics, pls pass on me that would be a great
help

thank you

var
 
Back
Top