(Msg. 1) Posted: Wed Oct 28, 2009 4:05 pm
Post subject: how to make name table and purchase table join and get data of sales? Archived from groups: microsoft>public>access>tablesdbdesign (more info?)
Dear All
Thanks to this forum I have made some headway. Again I am stuck.
table1 with 50 names and staff code.
table2 with 100 items, price and stock.
With the forum guide managed to make a table3 with one field as lookup
field to enter names, and items.
What is required is
1. an input form where, you select a name in combo box with all the
items exhibited plus text field to enter the quantity purchased.
2. once all the quantities for the items purchased is entered against
all the names, to make a report to show all the names and the total
amount against their names.
3. at least give some links so that I can read and figure out.
(Msg. 2) Posted: Thu Oct 29, 2009 10:13 am
Post subject: Re: how to make name table and purchase table join and get data of sales? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Consider reviewing the Northwind database that comes with Access. It sounds
like you are building an order-tracking system... so you might want to look
for templates at Microsoft and other on-line sources...
Regards
Jeff Boyce
Microsoft Access MVP
--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.
Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.
You can thank the FTC of the USA for making this disclaimer
possible/necessary.
"captgnvr" <captgnvr.40s79c.RemoveThis@thecodecage.com> wrote in message
news:captgnvr.40s79c@thecodecage.com...
>
> Dear All
>
> Thanks to this forum I have made some headway. Again I am stuck.
>
> table1 with 50 names and staff code.
>
> table2 with 100 items, price and stock.
>
> With the forum guide managed to make a table3 with one field as lookup
> field to enter names, and items.
>
> What is required is
>
> 1. an input form where, you select a name in combo box with all the
> items exhibited plus text field to enter the quantity purchased.
>
> 2. once all the quantities for the items purchased is entered against
> all the names, to make a report to show all the names and the total
> amount against their names.
>
> 3. at least give some links so that I can read and figure out.
>
> Please help.
>
> brgds/captgnvr
>
>
> --
> captgnvr
> ------------------------------------------------------------------------
> captgnvr's Profile:
> http://www.thecodecage.com/forumz/member.php?userid=1072 > View this thread:
> http://www.thecodecage.com/forumz/showthread.php?t=148846 >
(Msg. 3) Posted: Thu Oct 29, 2009 3:05 pm
Post subject: Re: how to make name table and purchase table join and get data of sales? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
D/Jeff
Thanks for the tip. Actually I am stuck with how to make the third
table using two tables as I have mentioned; one with names and their
code and the other table with various items and price.
For example I make the third table using names code and products code
and price, the difficulty is I do not want to put one look up field for
names and one lookup field for purchase items. If I do so then I have
to enter each record for a particular person and click items list and
click one. Instead I want to have it in such a way, the name of the
person when clicked, to appear all items and its prices and a text field
to enter the quantity and another text field to show the total amount of
purchase so that I can take a report print out with names and total
amount for deductions in their wages.
I really than you for assistance and I have been waiting for three days
for some guidance.
(Msg. 4) Posted: Thu Oct 29, 2009 3:05 pm
Post subject: Re: how to make name table and purchase table join and get data of sales? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
If you are saying that you're considering using a lookup data type directly
in the table, stop now! In fact, if you are trying to do this directly in
the tables, stop sooner!!
Access tables may look like spreadsheets but they aren't. Access tables
store data, Access forms display data.
If you haven't already done so, look into how to use forms (and queries) in
Access.
Regards
Jeff Boyce
Microsoft Access MVP
--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.
Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.
You can thank the FTC of the USA for making this disclaimer
possible/necessary.
"captgnvr" <captgnvr.40txx3.RemoveThis@thecodecage.com> wrote in message
news:captgnvr.40txx3@thecodecage.com...
>
> D/Jeff
>
> Thanks for the tip. Actually I am stuck with how to make the third
> table using two tables as I have mentioned; one with names and their
> code and the other table with various items and price.
>
> For example I make the third table using names code and products code
> and price, the difficulty is I do not want to put one look up field for
> names and one lookup field for purchase items. If I do so then I have
> to enter each record for a particular person and click items list and
> click one. Instead I want to have it in such a way, the name of the
> person when clicked, to appear all items and its prices and a text field
> to enter the quantity and another text field to show the total amount of
> purchase so that I can take a report print out with names and total
> amount for deductions in their wages.
>
> I really than you for assistance and I have been waiting for three days
> for some guidance.
>
> brgds/captgnvr
>
>
> --
> captgnvr
> ------------------------------------------------------------------------
> captgnvr's Profile:
> http://www.thecodecage.com/forumz/member.php?userid=1072 > View this thread:
> http://www.thecodecage.com/forumz/showthread.php?t=148846 >
(Msg. 5) Posted: Thu Oct 29, 2009 5:42 pm
Post subject: Re: how to make name table and purchase table join and get data of sales? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
On Thu, 29 Oct 2009 18:04:18 +0000, captgnvr <captgnvr.40txx3 RemoveThis @thecodecage.com>
wrote:
>Thanks for the tip. Actually I am stuck with how to make the third
>table using two tables as I have mentioned; one with names and their
>code and the other table with various items and price.
>
>For example I make the third table using names code and products code
>and price, the difficulty is I do not want to put one look up field for
>names and one lookup field for purchase items. If I do so then I have
>to enter each record for a particular person and click items list and
>click one. Instead I want to have it in such a way, the name of the
>person when clicked, to appear all items and its prices and a text field
>to enter the quantity and another text field to show the total amount of
>purchase so that I can take a report print out with names and total
>amount for deductions in their wages.
Use a Form based on the names table, with a Subform based on the junction
table. On the subform you can have a combo box selecting the items from the
products table.
See the "Orders" form in the Northwind sample database for an exact analog of
what you're trying to do.
--
(Msg. 6) Posted: Fri Oct 30, 2009 2:05 am
Post subject: Re: how to make name table and purchase table join and get data of sales? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
D/Jeff & John
Thank you for the response. Will stop using the lookup field in the
table and will read up 'orders' in Northwind.
When I am making the third table by using name field from name-table
and one item field from item-table and price field, it changes the
name-field name in table3.
Anyhow will study more as suggested and wl get back.
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office Other