POPULATE SUMMARY WITHOUT VB CODE

[AwolAtHTR]

Fri 14 Jan 5

well Duane needs HELP with an Access issue:

HOW TO PREPARE A SUMMARY TABLE
WITHOUT WRITTING (& debugging) VISUAL BASIC CODE?

I have done this many times with VB but wanted this table
to be ONLY by MicroSoft Access processing.

oh, the system structure is:

A. Input from HX4 detail records for EVERY race
B. Output to Profile summary table for EACH DAY
C. Rules for assigning race records to different Groups, A, B, etc

doing C. with a query is tedious for all twenty-two (22) subgroups
BUT, condition satisfied: Data is ready without VB code

My problem is: How to populate the Profile table?

I recall using PASTE-APPEND and PASTE-SPECIAL the last time I tried
a variation of this problem and it worked!!

but, WHEN to use PASTE-APPEND or -SPECIAL, I never did really know
it just WORKED so, I used it.

ok, I feel I have said enuf or maybe not enough?

-------------------
repeat: ANYONE know the simple trick to get Access to populate
another table with ONLY one entry for many entries in OTHER table.

duane

[Donnie]

Duane--
do a maketable query. go into query design view, open the table with the many fields, choose the field you want, go up to the word "query" on the menu and change to maketable. Run query, pointing to appropriate "new" table. Hope this is what you were looking for!

[AwolAtHTR]

thanks Donnie for your attempted help.

this helped me becauze usually I use copy and paste with data and structure
to create the INITIAL table. then go in and slash-and-delete fields that are
not needed in the summary table.

the answer was UPDATE-TO

my original problem was to update TODAY with data in the old/initially set up file.
this is found on the simple Query View window, and click UPDATE to set up
and WHEN you run the query, the Parent table of the Parent-Child is updated.
just took a few Try-This queries and bingo, there it was again

so, that was the trick that I forgot

HOWEVER, a new twist that I have not found the MicroSoft method for Update.
In ralational data base terns, this is the field type of Child-Parent-Update.
With my old PACE language at WANG, this was a piece of cake, do OFTEN!
well, I agree that Access is only an attempt at a 4GL language
yes, PACE made the list of ---close to a real relational data base tools----
aaah, sure, probably an example buried in SAMPLES.MDB
---BUT, have you ever TRIED to mind something you with half the answer?
-----so, if someone knows where samole is found then a note would be appreciated.

BUT, where is the Method with Access 20

expect for curiousity, I am at the point of saying, does NOT MATTER
do it with a quick and dirty Visual Basic program.

thx again Donnie,

Duane

[Donnie]

Duane-
From your note I gather you are currently using Access 2.0...correct? I gave instructions for Office XP....my bad!

[AwolAtHTR]

aah Donnie, that was '--not bad--

BUT, good news that what works for Office XP, works in Access 2.0

sure, looking back instead of forward

yes, your instructions were correct
and, there is probably more power that Office-XP has that the
old Access 20 does not have. Like maybe an easy field property
to perform the '...count the childern..' for this parent.

but that would not be enough motivation for me to convert the
subsystems that I have working with Access 2.0 into Office-XP

Duane