access help for parameter values! 1

[Schmals]

hello everyone,
i have created a report in access and i have included parameter values for the dates. when i open the report, it asks for the beginning month, ending month; then beginning year, ending year. i have the month in one column, and the year in another column, but it is in numberic form (01-12 for month and 00-99 for the year). i have the columns in the query setup as text.
the report runs great when i am just doing 1 year (01,09 and 02,02), but when i tried to run a report for 09,09 and 01,02 it just gave me sept 1-30; it isn't realizing that i need a yearly report and not just that month. i am assuming that there should be some kind of validation rule?? if anyone has any suggestions, that would be great!!!
thanks!!

 

[Ecniv]

How are you filtering on the dates?
I ask because if you are using two columns you are probably not getting the results you want.


...Where #01 [monthField] [yearfield]# Between #01 [parammth01] [paramyr01]# and #01 [parammth02] [paramyr02]#


Vince

 

[Schmals]

vince,
I am actually copying the tables from d-base III into access. then creating a query from 4 different tables, but no filtering. i just have the one column that has text 01-12 and the other column is text 00-99. i am not positive that it actually restricts 01-12 or 00-99, that might be part of the problem, but i think the other part is that since it is just text, it isn't reading it as a year "value".

also, where would i put this?? in the table? (i assume?)
...Where #01 [monthField] [yearfield]# Between #01 [parammth01] [paramyr01]# and #01 [parammth02] [paramyr02]#

thanks for all your help....
heidi