Suggestions for query design

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a query to be updateable, but than cannot lookup values for several of
the columns.

The query has a user input race finishes in a column. Automatically I need
the points column to be updated. For each finishing position, there is a set
number of points--how can I look points without a join.

Note that I have multiple tables, and joins, for race data, drive info, race
classes, etc. The query is updateable until I add the points table join.

Suggestions? Shouldn't this work?
 
VolunteerWebber said:
I need a query to be updateable, but than cannot lookup values for several
of
the columns.

The query has a user input race finishes in a column. Automatically I
need
the points column to be updated. For each finishing position, there is a
set
number of points--how can I look points without a join.

Note that I have multiple tables, and joins, for race data, drive info,
race
classes, etc. The query is updateable until I add the points table join.

Suggestions? Shouldn't this work?
Click to expand...

Not really. Query datasheets are NOT designed for data entry, or even really
for viewing data.

Create a Form based on your finishes table, and use Combo Boxes on the form
bound to your lookup table (or tables).

Your calculated points should NOT be stored in any table - just calculate
them as needed.

John W. Vinson [MVP]
 
I left out some detail. I have a form with combo boxes, to select the race
date and car class. For the selected race and class, a subform presents the
drivers and allows the results to be input. (I'm weaning a group away from
Excel.) With a user typing in a result, the points need to update
automatically like they were computed--but how to do this--where would you do
this if not stuffing them in the table with the results.

I appreciate your help. And yes, this is volunteer work, but want it to
work well for the upcoming season.

Please ignore my duplicate posting, titling misleadingly "Suggestions for
query design" that was not getting replies.
 
I left out some detail. I have a form with combo boxes, to select the race
date and car class. For the selected race and class, a subform presents the
drivers and allows the results to be input. (I'm weaning a group away from
Excel.) With a user typing in a result, the points need to update
automatically like they were computed--but how to do this--where would you do
this if not stuffing them in the table with the results.
Click to expand...

Two ways:

1. Put a Textbox on the form, and set its Control Source to the expression
which calculates the points.

2. If you want to be able to sort the records on the form by the number of
points, base the Form on a Query. In that query put the expression in a vacant
Field cell to dynamically calculate it.

John W. Vinson [MVP]
 
Back
Top