Re: save table records from select tempquery

Thank You for Your input!
Append query help is right choice for my case. This can help.
No, I don't need edit data right in this table, but I keep in my mind
this point to next designs.

What is making most of trouble for me right on current moment?
I looking virtually to results I wished to achieve (ordered to me from
my accountant's room) and trying understand best design solution
points for this.
Picture, I trying achieving, is more alike crosstab, just more complex
on this.
So, deeper I digging, this looks more and more complex for me.

Might be experienced Access gurus can help me with pointing me on
design?

Initially I have on hand nine department tables organized on same
manner as others are.
A rows there is ledger numbers, columns is months.
A result in tables is departments planned amounts to corresponding
months.

Now I need rearrange to call those datas like crosstab:
rows stay the same, columns now should be department codes, but
filtered selection of datas should be made by time periods which can be
those same from month's columns or even complex like aggregated
quarters or half years amounts.

More or less I managed this picture via my select query (see sample
code on my earlier post), sum total aggregations and union queries.
But what if our finance analyst desired more?
- to calculate intermediate ledger group totals and input those results
next to ledger number groups as well?

There I filed :(
My screen form recordsource select query is ~10000 characters long and
I see I can double this character total count if I try achieving
desired screen result on same design manner!
Is this normal length of Query? I looked in Access specifications list
than not, but I am not sure for another - because I let this utility to
bookkeeper's room for later adjustments if they desired. I believe
they need buy then some "nutcracker" for selected edit task.
This is why I looking for another design idea, but out any for today.
Might be selecting and writing calculated inputs to TmpTable in small
portions can let me chances to call again and easy calculate running
sum totals or recall selected aggregated totals as necessary for later
grand total formulas?
Might be gurus seen the same and can point directions for me from
experiences?
Highly appreciate inputs in advance!
Rgrds -
Ainars.

Larry Linson wrote:
"A_M_IS" <aimis@xxxxxxxxx> wrote
> I will try this right now, but does this run correct in case when I need add
> datas in small portions, more than only one time?

No, "MakeTable" Queries, just as the name suggests, make an entirely new
Table.

To _add_ data to an existing Table, check Help on Append Queries.

To _change_ data in existing records of an existing Table, check Help on
Update Queries.

Larry Linson
Microsoft Access MVP

.

Relevant Pages

  • Re: Calculate a percentage using 2 different query totals
    ... (The Totals) ... combine the 2 Queries, the solution was obvious. ... Enter the appropriate expression from your field headings in the Query ... Well, Duane, this little exercise has been quite and experience. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Query Design View is Slow to Open
    ... same query takes about 20 minutes to open in datasheet view. ... took only seconds to open in both design view and datasheet view. ... The troublesome queries are based entirely on local tables (i.e. no ... HOUSEHOLD_PersonalInfo opens slowly in design ...
    (comp.databases.ms-access)
  • Re: Is this join valid?
    ... > complex set of tables and queries, but I've boiled down the behavior ... you describe a problem with the Design View that really should not ... affect what happens when running a query from ASP. ... > the SQL view after creating the query in Design View. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Getting a total control to find totals for last 7 days via a q
    ... A different query will be needed that groups on ... these other two queries. ... how would i translate that into an unbound control on my form? ... But this returns the totals for All dates, and not the last 7 days, but if i ...
    (microsoft.public.access.queries)
  • Re: Help Designing a Query to Count Classes
    ... SELECT Class_Status, Countas TheCount ... So I can use DSum to create a calculated field in the same query John ... I can design a query that gives us the total number of classes ... -- Select View: Totals from the Menu ...
    (microsoft.public.access.queries)