I'm trying to query a table on the date field to give me all records from April. I thought the criteria should be =Month(4). However, none of the records return. I had this working last month, but it was deleted. Anyone know what I'm doing wrong??
thanks but no luck, it's almost like it's not reading the month field as a 4. I've tried a few different ways. I've tried a report with an unbound field that says [date]=month(4) and it just returns all 0's. I've also tried different months, but it gives me the same result.