I have written an Access database to track the accounts of a small trader
which works successfully. The customer has now asked me to include an
additional feature which is described as follows:
A box of assorted goods is purchased for a price and that box is then sorted
and the individual goods are sold, the problem is collecting all the
individual prices together and calculating the profit/loss on the initial
purchase price for the box. this profit/loss will appear in the amendment
form for each item and the original box.
Because I hadn't catered for this scenario originally my profit/loss box
shows a total loss for the original box and a total profit against each item
in that box that is sold.
I want to be able to reflect the running profit/loss for the box against
each individual component and keep it continually updated, the only way I
have found to do it so far is to generate a report and show it that way.
George 4 1651
I think you'll find that using a report is by far the best way to accomplish
this.
HTH
- Turtle
"George Steward" <go*****@clara.net> wrote in message
news:10****************@putney.uk.clara.net... I have written an Access database to track the accounts of a small trader which works successfully. The customer has now asked me to include an additional feature which is described as follows:
A box of assorted goods is purchased for a price and that box is then
sorted and the individual goods are sold, the problem is collecting all the individual prices together and calculating the profit/loss on the initial purchase price for the box. this profit/loss will appear in the amendment form for each item and the original box.
Because I hadn't catered for this scenario originally my profit/loss box shows a total loss for the original box and a total profit against each
item in that box that is sold.
I want to be able to reflect the running profit/loss for the box against each individual component and keep it continually updated, the only way I have found to do it so far is to generate a report and show it that way.
George
I agree but how do I get the results from the report back onto the form?
"MacDermott" <ma********@nospam.com> wrote in message
news:sA*******************@newsread1.news.atl.eart hlink.net... I think you'll find that using a report is by far the best way to
accomplish this.
HTH - Turtle
"George Steward" <go*****@clara.net> wrote in message news:10****************@putney.uk.clara.net... I have written an Access database to track the accounts of a small
trader which works successfully. The customer has now asked me to include an additional feature which is described as follows:
A box of assorted goods is purchased for a price and that box is then sorted and the individual goods are sold, the problem is collecting all the individual prices together and calculating the profit/loss on the
initial purchase price for the box. this profit/loss will appear in the
amendment form for each item and the original box.
Because I hadn't catered for this scenario originally my profit/loss box shows a total loss for the original box and a total profit against each item in that box that is sold.
I want to be able to reflect the running profit/loss for the box against each individual component and keep it continually updated, the only way
I have found to do it so far is to generate a report and show it that way.
George
Design your application so that this information is available from the
report, not the form.
"George Steward" <go*****@clara.net> wrote in message
news:10****************@dyke.uk.clara.net... I agree but how do I get the results from the report back onto the form?
"MacDermott" <ma********@nospam.com> wrote in message news:sA*******************@newsread1.news.atl.eart hlink.net... I think you'll find that using a report is by far the best way to accomplish this.
HTH - Turtle
"George Steward" <go*****@clara.net> wrote in message news:10****************@putney.uk.clara.net... I have written an Access database to track the accounts of a small trader which works successfully. The customer has now asked me to include an additional feature which is described as follows:
A box of assorted goods is purchased for a price and that box is then sorted and the individual goods are sold, the problem is collecting all the individual prices together and calculating the profit/loss on the initial purchase price for the box. this profit/loss will appear in the amendment form for each item and the original box.
Because I hadn't catered for this scenario originally my profit/loss
box shows a total loss for the original box and a total profit against
each item in that box that is sold.
I want to be able to reflect the running profit/loss for the box
against each individual component and keep it continually updated, the only
way I have found to do it so far is to generate a report and show it that
way. George
It is already - the customer wants the information on the form she uses to
update the entry such as when there is any chargeable work done on the item
and when it is sold. These must reflect in the profit for the box as a
whole.
"MacDermott" <ma********@nospam.com> wrote in message
news:CA******************@newsread1.news.atl.earth link.net... Design your application so that this information is available from the report, not the form.
"George Steward" <go*****@clara.net> wrote in message news:10****************@dyke.uk.clara.net... I agree but how do I get the results from the report back onto the form?
"MacDermott" <ma********@nospam.com> wrote in message news:sA*******************@newsread1.news.atl.eart hlink.net... I think you'll find that using a report is by far the best way to accomplish this.
HTH - Turtle
"George Steward" <go*****@clara.net> wrote in message news:10****************@putney.uk.clara.net... > I have written an Access database to track the accounts of a small trader > which works successfully. The customer has now asked me to include
an > additional feature which is described as follows: > > A box of assorted goods is purchased for a price and that box is
then sorted > and the individual goods are sold, the problem is collecting all the > individual prices together and calculating the profit/loss on the initial > purchase price for the box. this profit/loss will appear in the amendment > form for each item and the original box. > > Because I hadn't catered for this scenario originally my profit/loss box > shows a total loss for the original box and a total profit against each item > in that box that is sold. > > I want to be able to reflect the running profit/loss for the box against > each individual component and keep it continually updated, the only way I > have found to do it so far is to generate a report and show it that way. > > George >
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Mathew |
last post by:
I am looking to write a program with Microsoft Visual Basic 6 that
writes out to the com port. After the inital Connection. I will be
connecting at 9600, 8 data bits, with hardware flow control. ...
|
by: Mark Kamoski |
last post by:
Hi Everyone.
What is the real difference between writing a Sub versus writing a Function
with no return value?
It seems to me that both of these would need to compile to the same IL, so
it...
|
by: David |
last post by:
Hi all,
I am having a few questions today.
Anyway,
I want to create a class file, within the class file, I want to have
functions that can give you optional paramaters...
Such like...
|
by: MgGuigg |
last post by:
Hello all, This is my first time posting a question to this forum, so here is
hoping I am following protocol. I am scraping the rust off my old Basic
programming skills, and have just recently...
|
by: Bruce D |
last post by:
I have two methods to write to the database. The first one saves the file
to disk the re-reads it and then inserts it. This way works...at least I'm
able to read the image when I retrieve it....
|
by: esakal |
last post by:
Hello,
I'm programming an application based on CAB infrastructure in the
client side (c# .net 2005)
Since my application must be sequencally, i wrote all the code in the
UI thread.
my...
|
by: nexus024 |
last post by:
I am trying to write a program that will continuously sniff eth0 for a specific UDP packet thats being sent to a specific destination IP, alter the data of the packet, and finally transmit it to the...
|
by: Barry Flynn |
last post by:
Hi
I am working with a VB 2005 program which has been converted from VB6.
It writes data out to a flat file, with code like the following line
WriteLine(riFileNo, "Hist", lsAssetID,...
|
by: mcc99 |
last post by:
Amazing, I surfed around to find a simple utility that could list files recursively from a given top folder down through it, writing out the path and filename in simple \path\file_name form, without...
|
by: ashjas |
last post by:
Hello,
I have run this logic on turboc++ 3.0 and it is working fine on it but
its not running on msvs2008 c++.
i am not able to assign the value like this *temp=*main,where main and
temp are char...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
| |