Display Query field in form?

[June7]

Combo/list box RowSource can be an SQL that will show only distinct values, like:


SELECT DISTINCT fieldname FROM tablename ORDER BY fieldname;

If only want 1 month there are ways to set up query and criteria so user doesn't have to enter two full date values. They could just pick a month from a combobox list.

[Ray67]

How can i do it by month and year? The user would only have to pick Month and year.

[June7]

Variety of approaches. Can choose month from combobox and enter year in textbox (or choose from a combobox list). Then code would build the begin and end dates. The end date is always trickiest because not every month has same number of days. But as I just learned, DateSerial handles that nicely.

consider m = the name of month control and y = name of year control

BETWEEN DateSerial(y, m, 1) AND DateSerial(y, m+1, 0)