Search results

Thank you all - let me try the solutions proposed and revert. :)

So the data is around 30,000 lines, but I wanted the last 30-day, 90,-day, 365-day, etc., so it doesnt need to fetch all the data. Sorry - will try to be more clear... With the simple query, I can only seem to get the sums/averages by date (so repeating InvCodeID). I wanted Each InvCodeID to be...

Hi... Access newbie here... TIA. I have sample data in the following form (dd/mm/yyyy): DateTransaction InvCodeID QtyOut 06/11/2023 YHH308B 2.5 12/10/2023 YHH308B 10 13/09/2023 YHH308B 12 09/11/2023 YHH200A 56 15/10/2023 YHH200A 22 06/09/2023 YHH100F 3 03/11/2023 YHH500F 8 I...

Hi All. Please see attached screenshots. In design mode, I have a vertical navigation control (tabs) and horizontal ones. Yet, when I use form view or layout view in Office 2016 on Windows 7, the left vertical pane disappears, but does not in Windows 10. I am sure it must be a simple setting -...

The field in my form is: in frmNewQuotation user selects currency in dropdown Currency and currency rate in field CurrencyRate which is filled by an inputbox when user selects Tanzanian Shilling as currency. Note that there is only one pair of currency, not multiple, which keeps it simple. In...

Jdraw, Seems you do not understand what I am trying to achieve. Thanks for your help. I will wait if anybody else can assist.

Jdraw, Please ignore how to sort currency. I have that sorted. My question on this forum is how do all the unitprice's on each line item in a subform when i change an option on the main form. Thats it, whether its currency or something else.

The currency rate stays recorded. The issue is not currency rate. This is the issue: each line item has a unit price in USD. After the whole quotation is made, and the user wants to change the currency to TZS, and changes the currency dropdown and insert the exchange rate - say 1usd to 2000tzs...

Not really. For now we only have USD/TZS, and a pop-up asks for today's exchange rate when a user selects the secondary currency. Its manual, but works at our end as rates are provided daily to the salespersons to use as needed. One of the screenshots shows the currency rate below the currency...

Hi jdraw, Attached a few tables relationships. Also took screenshots of how the currency rate is captured. Currency is not live, it is entered by the salesperson on the day of the quote. That rate is what the USD UnitPrice is supposed to multiply with to get the new UnitPrice in Tanzanian...

Sorry, I'm a relative newbie. Could you walk me through this? Or direct me to somewhere i can read-up? Many thanks.

I have created a Quotation form, that has a main form frmQuotationHeader, and subform frmQuotationLineItems. I have a UnitPrice field that is populated on the afterupdate event of the product selection. Ideally I would have solved this issue with an unbound form, but given that I want the price...

Hi. I have a navigation form that has tabbed subforms. Each subform deals with a differently calculated product and quantity, but similar calculated price formula. I cannot use a unbound field for the price, as I need the same price to show up years later, rather a newly calculated price when...

Thank you! This was the issue indeed...

Hi All. My first post here... an Access noob, and learning fast :) I am designing a quotation that has a main form frmNewQuotation, and subforms frmLineItemCurtains, frmLineItemAccessories, etc, all linked by the Quotation Job Number. Each subform computes the unit qty, unit price, and...