i need to build a crystal report that show the total sum of employee's absence per month and per year in a row. it means that i have to count the sum of one field twice based on the period time. meanwhile i have to do it at once since i have to put both values in a row.
i've tried to do it from VB
6.0 and access the database with the SQL commands n ADODB connection. but i guess i can't do
SELECT COUNT(field) .... WHERE (conditions) 2 times in 1 access at a time.
Can anybody please give me a help or clue or another way, i just need both values to show up in a row
thx before :) :)