counting from two queries

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

Guest

as part of my job, i have to issue items to people. sometimes these items
will be on long term and sometimes on short term. in the short term table
there is a field for item in which any item from the items table can be
added. in long term there is a separate field for each item, one yes/no field
for each of the items available.
the items available are more or less the same for long term or short term. i
have created two separate queries to calculate the number issued in long term
and for short term. however due to the two different types of field i am
unsure how to combine the two together. it is probably very simple, but what
i need is a query where the item sum in one query is added to the item sum of
another query where the item name is the same.
i am not great at access, so the simpler the answer the better. if you want
anything explained further let me know.
thanks
adrian
 
I believe your issue is your table structure where "there is a separate
field for each item". What happens if you want to add another long term
item? Is it possible to normalize your long term table?

I'm not sure I would have two separate tables for this.
 
its easier to have two tables because long term loan can be for several years
whereas short term is only for a maximum of four weeks. the current system
means that only certain items are available on long term. it would be too
complex to try and make them both the same structure because it is easier to
see exactly what items a person has out long term, whilst any item can be on
short term, i.e. some items that might not always be found on short term.
thanks
adrian
 
Even if you think you need two tables, they should both be normalized. There
are very few exceptions to properly normalizing your tables.

--
Duane Hookom
MS Access MVP
--

adrian said:
its easier to have two tables because long term loan can be for several
years
whereas short term is only for a maximum of four weeks. the current system
means that only certain items are available on long term. it would be too
complex to try and make them both the same structure because it is easier
to
see exactly what items a person has out long term, whilst any item can be
on
short term, i.e. some items that might not always be found on short term.
thanks
adrian
Click to expand...
 
Back
Top