Hi Welcome to JustAnswer
Please share your query and database details with me. I will help you out in it
Is there is anyway through with I can see your code and try it out by myself. Can you share your code
Okay, I understood your problem :-
" I need the "Form" to immediately update the Total" :- To do this you need use database trigger. You can set trigger when a new information is added to form. Through this you will be able to fulfill your goal.
"My "Form" does send Total field to "Query" but not in category currency" :- I think this is how every database behaves. Form is sending proper total values to query and it is now responsibility of writer mail merge to display that Total value with proper currency format to make it readable and understandable. Please correct me if I interpreted it wrong.
Alright !!. Please give me your update query.
Triggers looks like this :-
CREATE TRIGGER trigCustomerName
AFTER INSERT ON "Customers"
REFERENCING NEW ROW AS newrow
FOR EACH ROW BEGIN ATOMIC
UPDATE "Customers" SET "CompanyName" = COALESCE(newrow."FirstName",'') || COALESCE(newrow."LastName",''); END
Note that you cannot use TRIGGERS with HSQLDB v1.8 (the default database 'engine' used by Base). You will have to 'split' your database and upgrade to HSQLDB v.2.3.x in order to use TRIGGERS - see tutorial HERE :- https://forum.openoffice.org/en/forum/viewtopic.php?f=83&t=61183
I have never used libre office . Not sure if I will be able to set this up for you. I can help you out in sql queries and other stuff . I have worked on other tools like Oracle,My SQL etc. but don't know much about it. Do you want me to give it a try ?
Or else I can leave this question for other expert
No you do not need to pay if the problem remains unresolved. I am opting out to see if anyone else can work on it ,If nobody picks it up, I will do it.
Hoping for best !
Hi there, my name is***** you attach the Libre Office files to this conversation using the paperclip icon? Then I can look at what you have and tell you what to do to get it to behave the way you want. You might need to "zip" the files before you post them on here. Thanks!
Hi there. On the toolbar where you type responses to me, the very last icon should be a paperclip. Click that and you should be able to attach a file to our conversation.
you're welcome and I'm glad it worked out for you.
Hi there. Do you have another question? Is something not working for you correctly? I think the way we left off last time is that you had figured out your problem on your own?
My schedule is pretty open, let me know what works for you. Can you please upload a copy of the database for me to look at in advance? That will make things much easier. You can upload the database to my Dropbox so it's confidential and nobody else will see it. Use the link below and let me know when it's there: