Hey guys,
I'm a bit rusty at Microsoft Access, but I've been tasked to create a database through Access for a very small department where I work for but I'm having difficulty creating forms and calculating my Total SUN on the Query "Total Sum of All Items".
I want to have my main access UI Page to have the user choose a fiscal year, dating between April 1 - March 31 of the following year through a DropDown option that would display from Year - Year.
I want to calculate the total amount that has been generated for all items being ordered from a specific date period selected in the dropdown "Fiscal Year" mentioned above also.
I have no idea how to query these functions for all my attempts give errors.
Can someone show me how to make this a bit better?
If someone can help, that would be amazing! I will include the database in an attachment.
Please Find Attachment named "GI3 PROCUREMENT"
Attachment 47940