Query / Calculations for 3 tables

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

Guest

to all..

I have three orders tables that I use and need to set up some extensive
calculations for all of these tables.. all the tables have the same fields
they are just for different types of orders (ordernumber is an autonumber
field).

I don't want to have to set up three queries with the same calcuations on
each.. is there an easier way that anyone can help me with?

an easy way to join the tables then perform my calculations?

Thanks,

Brook
 
I have three orders tables that I use and need to set up some extensive
calculations for all of these tables.. all the tables have the same fields
they are just for different types of orders (ordernumber is an autonumber
field).
Click to expand...

Why not just make one table out of the three with one additional field to
identify the Order Type?


Tom Lake
 
I would like to do that... but I don't know how..

tbl1 - Sample Orders - format "SPL-" 0000
tbl2 - Stock Orders- format "STK-" 0000
tbl3 - Custom Orders- format "CUS-" 0000

What type of field would I need to create, so that the table knows what type
of order and how to use the autonumber format?

Brook
 
Brook said:
I would like to do that... but I don't know how..

tbl1 - Sample Orders - format "SPL-" 0000
tbl2 - Stock Orders- format "STK-" 0000
tbl3 - Custom Orders- format "CUS-" 0000

What type of field would I need to create, so that the table knows
what type of order and how to use the autonumber format?
Click to expand...

You have a separate field where you store the string "SPL", "STK", "CUS" and
provide a control on your form where the user makes this entry.
 
I am still confused on how to incorporate this into an autonumber field with
three types of order numbers.

Brook
 
Brook said:
I am still confused on how to incorporate this into an autonumber
field with three types of order numbers.
Click to expand...

You don't. AutoNumbers "do what they do" and are not suited for use any time
you care about the values in any respect other than they are unique.

If one of your requirements is that you want each type to have its own sequence
of numbers apart from the other types then you cannot use an AutoNumber, but
most here would argue that even without that requirement the use of an
AutoNumber is a bad choice. There are numerous strategies for implementing an
incrementing number without the use of AutoNumber. If you do a search in these
groups you will find lots of hits explaining them.
 
Thanks for the information... I am researching the abililty to use an
incremental numbering instead of autonumber.

But once I do that, I will still need help setting the table/form/query up
so that I don't have to use three queries/tables.

Brook
 
Back
Top