I have the similar problem: I need to make many Queries and Report for 5 branches, 45 sub-branches and 3 segment with top 10 and bottom 10 items, which means 45 x 3 x 2 = 270 different queries, wowww
I created Query based on proposed solution from:
http...
hello folks, my first question
I am new in Access and I recently figure out that calculation field can be worked out by Iif formula.
Formula in my case works fine, it does as I want:
Iif(Budget=0;"No BudgeT";Act/Budget)
But I would like to format these results (where there is some number...
Moderate knowledge of Excel VBA and new recently in Access due to business requirements (one course passed)
Need and want to know so much about database and Accesss