You should be able to use the Aviation query as a guide for each of the categories. What exactly is your confusion?
You should be able to use the Aviation query as a guide for each of the categories. What exactly is your confusion?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Well I see that you have true true false in the field box , that should be typed for every yes/no field right, but the number of True, true false changes depending on the number of yes no field i have?(that is what i dont get)
if the answer is no then it is easy i think
You would need a similar expression as shown for every yes/no field included in query. The Aviation group just happened to be the smallest set of yes/no fields.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
i will try it thursday, thats when i go to the office again
i will let you knwo how i did
thanks so much!
ey bro thank you so much ! it reall works,
Quick question, what about if i want to show all the project regardless of market subsector?
Thanks
For anyone, this issue is resolved , just copy the sql coding and math it to yours in the Query Design View
this is Solved Thank you !