Search results

That's strange, it works for me. Though I did forget to make sure it was the current year if there's more than one stored, in which case you'd need (Month([dateval])=Month(Now())) And (Year([dateval])=Year(Now())) The only other thing is to check that your date format is what you intended - to...

Suppose your date column is called "dateval". Then make a query and put Month([dateval])=Month(Now()) in the select criteria. Should work!

I have a moderate sized table (14000 rows x 25 cols) of scientific data and am doing the simplest query in the world. Select all rows based on a single value in one field (plot no:numeric). Complicated queries like >2000 And < 2500 work fine but Access crashes when I ask for something simple...

The only problem with Tim's solution is that you lose the crosstab format when you make-table from a crosstab query. Very tedious & I generally end up going down the copy-paste route!