Automatically create table based on query?

  • Thread starter Thread starter Henro
  • Start date Start date
H

Henro

I hav a query with a lot of calculated fields.
I also want totals of all of these fields. Is there a way to export all the
values in a query to a new table without having to create the table?

Very important to me: I want the values to be put in the new table, not the
underlying calculations!

Thnx for thinking with me!

Henro
 
First I must say that storing the data from a calculation in a database
is almost always very bad design. Unless the results are going to change in
the future and you are trying to capture the results at a specific time, I
suggest don't do it.

As for how, it is very simple, which leads me to believe you don't have
a good understanding of Access and why it is a bad idea.

With the query in design mode, choose "Make Table" from the top line
menu. The Icon should look like two windows with a down arrow on one side,
click on that arrow and one choice will be Make Table.
 
I agree with you, I am not a professional programmer thus looking for the
(for me) fastest en simplest solution.
I have a query that calculates a lot of fields but if I make a copy of the
query and let it sum up all the values it starts talking about subquery's
that are not permitted. That's how I got the idea to make a table. If there
is a better way to do it, I would very much like to hear it!

TIA Henro
 
Hello,

This is very easy. You can change the selection query to a create table
query when you are on the query design vieuw.


Bert
 
I would need to see the query structure you have. Normally it should
not be a problem.
 
Can I send you the query?

Plz?

TIA Henro

Joseph Meehan said:
I would need to see the query structure you have. Normally it should
not be a problem.

--
Joseph E. Meehan

26 + 6 = 1 It's Irish Math


time,
Click to expand...
 
If you have sent me anything e-mail, it may not have made it. I have
some aggressive anti spam. Try making sure the subject line makes it easy
to identify. You may use the same subject line as the subject line for this
newsgroup.
 
OWWWWWWWWWWWW

I am very sorry Joseph, I solved the problem! It was in a field that
calculated Percentages. If there was no data in a record it would show
#Error. This (non)value cannot be exported to a date/time field. I solved it
first by simply using a querycriterium stating 'Is Not Null', then later on
started using =NZ([Value]).

Thnx for your offer, but the problem is solved!
 
Henro said:
OWWWWWWWWWWWW

I am very sorry Joseph, I solved the problem! It was in a field that
calculated Percentages. If there was no data in a record it would show
#Error. This (non)value cannot be exported to a date/time field. I solved it
first by simply using a querycriterium stating 'Is Not Null', then later on
started using =NZ([Value]).

Thnx for your offer, but the problem is solved!
Click to expand...


Glad to here you got it working.
 
Back
Top