A
annysjunkmail
Hi,
This would be a great help if it can be solved.
I have 4500 applications for funding.
Each application must meet max 6 conditions to receive funding.
Applications are stored in tblApplication and conditions are stored in
tblConditions.
I have created a query that shows Applications & conditions but my
problem is that I get multiple applications due to multiple conditions.
A workaround would be if the query could be set up in such a way that
it displays the 6 conditions as columns, display unique ApplicationNo's
and add a Yes under relevant column if conditon detected, or blank if
not detected.
Grateful for expert help please.
Tony
This would be a great help if it can be solved.
I have 4500 applications for funding.
Each application must meet max 6 conditions to receive funding.
Applications are stored in tblApplication and conditions are stored in
tblConditions.
I have created a query that shows Applications & conditions but my
problem is that I get multiple applications due to multiple conditions.
A workaround would be if the query could be set up in such a way that
it displays the 6 conditions as columns, display unique ApplicationNo's
and add a Yes under relevant column if conditon detected, or blank if
not detected.
Grateful for expert help please.
Tony