Dear Brij
According to you, we had tried this things mentioned below;
(1)First Make DataBase According to your Required as
Shown Excel file.
(3)Then make form for entry.
(4)Then make a report .
First I created table in access as per excel sheet formate.and then I
created form for entry.
date received issued Balancestock
11/07/05 100 0 100
11/07/05 50 0 150
12/07/05 0 50 100
(this is execel generated report)
date received issued Balancestock
11/07/05 100 0 100 (I
Calculated like)
Balance=[recived]-[issued]
11/07/05 50 0 50
12/07/05 0 50 -50
(this is acces generated report)
But my query is that for eg. If I have Stock of Cement Opening balance
Qty 100 Nos on 11/07/05 already in received qty coloum and I have
received Qty 50 on Same date my total stock in hand should be 150 but
instead of this it is showing only received qty 50 nos in access query .
And on 12/07/05 I had issued Qty 50 so, my closing stock in hand should
show 100,instead of 100 it showing -50 nos.
Thaniking you
Regards,
Bahadur shah
-----Original Message-----
From: [email protected]
[mailto:[EMAIL PROTECTED] On Behalf Of Brij
Sent: 16 August 2005 13:08
To: [email protected]
Subject: Re: [AccessDevelopers] MS Access query
(1)First Make DataBase According to your Required as
Shown Excel file.
(3)Then make form for entry.
(4)Then make a report .
Brij Here
- This message has been scanned by the DBBCG virus protection system -
------------------------ Yahoo! Groups Sponsor --------------------~-->
<font face=arial size=-1><a
href="http://us.ard.yahoo.com/SIG=12hoi3qkp/M=362335.6886445.7839731.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1124195640/A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/topics/education/digitaldivide/?source=YAHOO&cmpgn=GRP&RTP=http://groups.yahoo.com/";>In
low income neighborhoods, 84% do not own computers. At Network for Good, help
bridge the Digital Divide!</a>.</font>
--------------------------------------------------------------------~->
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
