473,320 Members | 1,876 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Assistance with Posting Multiple Payment Activity

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
Nov 12 '05 #1
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

Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
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
0
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...
5
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...
1
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...
1
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...
0
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...
4
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...
0
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...
1
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...
0
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...
0
isladogs
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...
1
isladogs
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...
0
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...
0
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...
1
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)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
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....
0
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.