need help.. newbie....

  • Thread starter Thread starter marco_pb via AccessMonster.com
  • Start date Start date
M

marco_pb via AccessMonster.com

hi all... I am new in using ms access 97.

can somebody help me? thank you before..
I have a query field name date (dd/mm/yyyy).
I want to input a parameter in form, but not a complete data format..
I want the input is yyyy only.

I really dont know how to figure it out. thank you all for your help.
 
Are you trying to search on the year only?

Method 1:
Add a new calculated field
Field: TheYear: Year([YourDateField])
Criteria: [What Year?]

Assumption:
Your date field contains only a date and not a time component.
Method 2: More efficient, but more complicated to understand
Field: [YourDateField]
Criteria: Between DateSerial( [What Year?],1,1) and DateSerial( [What
Year?],12,31)
 
thank a lot...
It works..
Is it really that simple? how can't i realize..
wow.. I must learn a lot ^^

thank you very much.
 
Back
Top