Search results

Thank you very much

Thank you for that info Still I am a but lost as the what I should do to get the required result

This will be hard coding the date, I am selecting the current financial year , active period with a yes select

Period come from below

Apologies, I change to below When I run the query, I only get June and July 2022 as a result

Hi all, I need to filter a query with periods from another table I only want to see the transaction from and to period My formula does not seem to work Below is the result of the query before filtering Query1 Query1 Period Total Sales (UGX) Total Purchase (UGX) Period1 Year From Year To...

Amended, Thank you so much

Thank you This seem to work like a charm

Hi Sonic8, you are correct, you are on the right track here I removed the dot from the equation and the type mismatch error disappeared I received a exchange outcome for the fist time now Only, the result is now value of 973585 and should be 217.973585 or 217,973585 So I will have to play...

Thank you for your assistance The code was given indented , also same in my DB, not sure why when I copy and past the code it does not have the indentation, apologies But the code supplied by arnelgp in the DB in post 22 is the full code supplied and was copied as is. Attached again

The form has no vale The immediate window gives an output Below is where I call the function, post 34

I am using the code in post 22 I dont get any values displayed when hovering over sret The output on the form is blank

Debug.Print sRet gives me a value of 216.502297 I assume the error is with StrToDdl

I did the breakpoint as advised I get the error in: I also get the same error when I open the DB that arnelgp sent me

Hi all, I have a query to calculate my total sum stock on hand I then have a second query where I sum all the product together to get a 1 line per product I then link this query in an update query Seems like Access does not like to have a linked sum query in an update query Any way around this?

I get the same error when I open the DB you sent me as well

Hi Arnelgp, I am still struggling with the error as mention in a previous post Could you please advise what I should be looking out for?

Hi all, Is it possible to send a message to all users signed in to a specific DB, also to have the message pop up then a user signs in. I suppose it could be as simple as to write the message into a table and repeat it for all active users Not sure how to have the message pop up once sent to...

Yes thank you Pat All seems to be ok now The temp data is when a new purchase order is raised then transferred to the transactions table I will take the PK on all tables in consideration and adapt Thank you all for the advise