Search results

Thanks a million for both your replies, I have decided to go with Allen Browne scenario regarding DSum() The problem I have is that the Dsum works but does not do an individual count for each product e.g. Total Quantity: DSum("[On_Hire_Quantity]","tblOnHire","[Supplier_Name]='Dungiven' or...

I am trying to complete a calculation to keep track of stock in a yard, If Stock is purchased it gets added to quantity in stock if ordered it gets removed from quantity in stock Briefly In After Update of [Purchase_quantity] field I tried the following code. IIf ([Supplier_Name]="Yard"...

I have a form that automatically appends a record to a different form if criteria is reached, As all forms are on a tab control How do I get the appended form to update with new record on click of tab. Many Thanks

That was great worked 100% Many! Many! Thanks

I am looking to have a pop up message on the opening of a form if a field end_date = Todays Date but no matter how i try it will not check field and find todays date. Message box working without condition, Can anyone out there please inform me of correct code for this to work. Many Thanks