How to get a specific number for the current month?

[Ronald Mcdonald]

Is there a way to look at only data from a specific month? It's June now so let's say I want to look up only data from June without having to hardcore the number 6 or letters "June" in my query. How would I go about doing this?

Another question would be how can I convert this to a number to multiply the numbers in my data with?



So I want to retrieve only data for the current month, June, and then multiply numbers associated with that data with the number of the month for June (that is, 6). How would I go about doing this?

Thanks

[pbaldy]

WHERE Month(YourDateField) = Month(Date())

But I assume you need year in there too, else you'll get data from last June too.