Hello. I'm trying to work with expanding the query for OrderDetailQ, connected to OrderDetailF. The aliases I need are: extprice, totalpartslabor, totaltax, and subtotal. And it seems that the only one that's causing trouble is totalpartslabor which would be the sum of extprice. So, in the column after extprice: [quantity]*[unitprice] I have the column for TotalPartsLabor. For that column I have TotalPartsLabor: Sum([Extprice]) But it doesn't work when I have that in there. What am I doing wrong? Thanks in advance.
Kevin Robertson
@Reply 2 years ago
You will need to perform that calculation to the Form Footer of the OrderDetailF.
Richard shows this in his Invoicing video.
George JakesOP
@Reply
2 years ago
Thank you Kevin. I did take that approach before trying it like this. It does work great. But the problem that I saw in doing that is that the although the figures are there, in the form, when the record is open via that form, the values aren't saved to the record anywhere. I would think that would be important to save these for historical records. Would a goal like that require a totally different approach? Or is that goal met by this appraoch, and I'm not aware of it? Thank you.
It's not necessary to save values that can be calculated on the fly. But yes, if you want to do that, it's definitely possible but will involve some VBA. I actually have a video coming out on this exact topic soon. Stay tuned.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
