I'm not certain if this is doable in the manner explained below, but
surely there have been others who have done something similar. So
whatever insight and assistance that can be provided will be much
appreciated.
I working with a separate Update Query (well several) that consolidate
various goods from separate tables for access and selection on a
sales/order invoice form. The data which is available is the
TagNo,ItemDescrip, Quantity and Price. Running another Update Query to
post the sold information (SoldDate and PriceSold) back to the
respective tables works fine for single items only, where there is one
SoldDate, one PriceSold and one corresponding IDTagNo.
The problem that I have attempted to resolve is related to Bulk items
where there is one main form/table with two subforms/tables - one for
purchases and one for sales. The Bulk sales are of course multiple
postings. For example the main form contains general information
regarding the product, such as hats, with purchases entered separately
on a subform, and the sales entered on another subform. Of course, the
main form will have a single IDTagNo and of course each entry on the
subforms have another ID number. One of the benefits of running the
Update Query for the single items mentioned above, is that if there
are any changes made it will be updated along with the new postings
the next time it is run. It seems that this cannot work for the Bulk
items because of the subform and multiple postings, or can it? What
criteria could be used?
Any thoughts or suggestions would be welcomed.
Thanks, Dalan 1 1657
Dalan,
I have a hard time understanding your project. Perhaps you can describe your
tables better. We don't need to know the fields necessarily, but we do need
some sense of how the different entities are represented. Without that, it's
difficult to offer query advice.
-Todd Matson
"Dalan" <ot***@safe-mail.net> wrote in message
news:50**************************@posting.google.c om... I'm not certain if this is doable in the manner explained below, but surely there have been others who have done something similar. So whatever insight and assistance that can be provided will be much appreciated.
I working with a separate Update Query (well several) that consolidate various goods from separate tables for access and selection on a sales/order invoice form. The data which is available is the TagNo,ItemDescrip, Quantity and Price. Running another Update Query to post the sold information (SoldDate and PriceSold) back to the respective tables works fine for single items only, where there is one SoldDate, one PriceSold and one corresponding IDTagNo.
The problem that I have attempted to resolve is related to Bulk items where there is one main form/table with two subforms/tables - one for purchases and one for sales. The Bulk sales are of course multiple postings. For example the main form contains general information regarding the product, such as hats, with purchases entered separately on a subform, and the sales entered on another subform. Of course, the main form will have a single IDTagNo and of course each entry on the subforms have another ID number. One of the benefits of running the Update Query for the single items mentioned above, is that if there are any changes made it will be updated along with the new postings the next time it is run. It seems that this cannot work for the Bulk items because of the subform and multiple postings, or can it? What criteria could be used?
Any thoughts or suggestions would be welcomed.
Thanks, Dalan This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: CHRIS ALOZIE |
last post by:
NIGERIAN TELECOMMUNICATION LIMITED.
FEDERAL SECRETARIAT COMPLEX,
GARKI, ZONE II
ABUJA.
E-MAIL: chrisalozie@uboot.com
DATE:16th August 2003 REF:rf/ntl-fgn
|
by: Jimmy |
last post by:
Hi,
I have a (multi-tier) XML document and a XSL transform file (that is
meant to transform the XML into a flat structure so I can insert the
data into a database table).
I have reached a...
|
by: Charles A. Lackman |
last post by:
I am working on a application that has many custom made dlls. Actually, for
this app each dll is a different form. I am able, with no problem to
reference and instantiate them to use their public...
|
by: Rolan |
last post by:
I'm using Access 97 and need some assistance in sorting out a proper
DSum expression. It relates to a subform (sfrmCost) from which I'm
wanting to extract the grand total of any and all data rows...
|
by: Dalan |
last post by:
I'm not certain if this is doable in the manner explained below, but
surely there have been others who have done something similar. So
whatever insight and assistance that can be provided will be...
|
by: Rolan |
last post by:
I know what I want to do regarding the average cost for inventory, but
need some assistance to sort out some of the details to finalize an
inventory table and query. Essentially, the information is...
|
by: tudyfruity18 |
last post by:
I'm suppose to write an applet that contains two buttons Investment calculator and Loan Calculator. When the Investment Calculator button is clicked, a frame appears in a new window for calculating...
|
by: UWALAKA |
last post by:
>
FROM THE
DESK OF DIRECTOR GENERAL
F.M.A LAGOS
EMAIL, dranthfiles1@indiatimes.com
Good Day,
I Dr.ANTHONY UWALAKA presently I am the director general of finance in the federal ministry of...
|
by: sudhaMurugesan |
last post by:
Hi all,
I 've created an xsl file to create an excel Workbook with multiple worksheets, thro' xslt. My code works fine for sheet1. Sheet2 was created but has no data. So please help me to fill...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
| |