Hi,
I am new here and so desperate to ask anybody here to help me fix my database.
I need to create a report to count my Subjects if they only have the following date conditions:
#1
StartDate: with date
EndDate: blank
and any Subjects with
#2
StartDate: with date
EndDate: today's date or future date
I created a formula in my Query but i'm having errors:
Expr1: IIf([StartDate]<>"" And [StartEnd]="",1,0)
The above formula is just for #1 and it's already not working. I don't know how to create a formula for #2 or how to create formula for both
Please help!!!
Thanks,
netchie
P.S. I am using Access 2007
I am new here and so desperate to ask anybody here to help me fix my database.
I need to create a report to count my Subjects if they only have the following date conditions:
#1
StartDate: with date
EndDate: blank
and any Subjects with
#2
StartDate: with date
EndDate: today's date or future date
I created a formula in my Query but i'm having errors:
Expr1: IIf([StartDate]<>"" And [StartEnd]="",1,0)
The above formula is just for #1 and it's already not working. I don't know how to create a formula for #2 or how to create formula for both
Please help!!!
Thanks,
netchie
P.S. I am using Access 2007