L
LC
Hello,
I have built a single table Access database, which has
the three following types of information:
- number of items identified: number, two digits only (no
decimals);
- format of items: box with the following "text"
possibilities: small, medium, large, extra-large;
- price of items: tick box (one for $5.00, one for
$10.00, one for $20.00).
The primary key for each form is, simply enough, an
automatically incremented number.
I would be extremely grateful if anyone could give me the
step-by-step "recipe" to create the following types of
querys, of increasing difficulty (to me, anyway!).
1. Query enabling me to know the distribution of formats,
i.e. how many forms regard items that are small, medium,
large and extra-large?
2. Same query as above, but in which the data regarding
the number of items identified in each form is multiplied
by each format.
For instance, if there are two forms with small-sized
items, one form with 3 items and the other with 4 items,
I would like to know automatically that there are 7 small
items in total (and "x" medium, "y" large, etc.).
3. Same query as above, but in which the number of items
in each form would multiply by the price.
Continuying the previous example, if the first "small-
sized items" form regards 3 items with the "$5.00" tick-
box cheched and the second form regards 4 items with
the "$10.00" tick-box checked, I would like to know that
the total amount of money for all these items is (3 x 5)
+ (4 x 10), i.e. $55.00!
I am really new at this game and am fully aware of the
time it may take my benefactor to answer these questions,
so thank you, thank you ever so much in advance.
Also, English is not my first language, so I hope my
questions can be understood.
In the hope to get an answer,
Sincerely,
LC.
I have built a single table Access database, which has
the three following types of information:
- number of items identified: number, two digits only (no
decimals);
- format of items: box with the following "text"
possibilities: small, medium, large, extra-large;
- price of items: tick box (one for $5.00, one for
$10.00, one for $20.00).
The primary key for each form is, simply enough, an
automatically incremented number.
I would be extremely grateful if anyone could give me the
step-by-step "recipe" to create the following types of
querys, of increasing difficulty (to me, anyway!).
1. Query enabling me to know the distribution of formats,
i.e. how many forms regard items that are small, medium,
large and extra-large?
2. Same query as above, but in which the data regarding
the number of items identified in each form is multiplied
by each format.
For instance, if there are two forms with small-sized
items, one form with 3 items and the other with 4 items,
I would like to know automatically that there are 7 small
items in total (and "x" medium, "y" large, etc.).
3. Same query as above, but in which the number of items
in each form would multiply by the price.
Continuying the previous example, if the first "small-
sized items" form regards 3 items with the "$5.00" tick-
box cheched and the second form regards 4 items with
the "$10.00" tick-box checked, I would like to know that
the total amount of money for all these items is (3 x 5)
+ (4 x 10), i.e. $55.00!
I am really new at this game and am fully aware of the
time it may take my benefactor to answer these questions,
so thank you, thank you ever so much in advance.
Also, English is not my first language, so I hope my
questions can be understood.
In the hope to get an answer,
Sincerely,
LC.