Schmals (TechnicalUser) Nov 26, 2002
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....![[morning]](/data/assets/smilies/morning.gif "[morning] [morning]")
![[turkey]](/data/assets/smilies/turkey.gif "[turkey] [turkey]")
heidi
ps- i couldn't figure out how to reply to your question... so i started a new thread!![[ponytails]](/data/assets/smilies/ponytails.gif "[ponytails] [ponytails]")
Ecniv (Programmer) Nov 26, 2002
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]#
Schmals (TechnicalUser) Nov 26, 2002
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!!
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
ps- i couldn't figure out how to reply to your question... so i started a new thread!
Ecniv (Programmer) Nov 26, 2002
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]#
Schmals (TechnicalUser) Nov 26, 2002
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!!
