calculate days in month

[PankajBanga]

how can i calculate number of days in current month using access query

 

[pbaldy]

How about:

Day(DateSerial(Year(Date()),Month(Date())+1,0))

 

[PankajBanga]

thanks

Bingo, worked like a treat