Report problem continues...

  • Thread starter Thread starter tspies85 via AccessMonster.com
  • Start date Start date
T

tspies85 via AccessMonster.com

Hi...
i have a database about inventory item. in my db, i have dateRegistered field.
Now, i need to cretae a report about all the item registered according to
year. My bos wish to select the year by the user ( using combo box). Do i
need to create another yearfield in my db?or is there a code to just select
record according to year selected just by the dateRegistered field....many..
many..thanks..
 
Create a combo box on a form to select the year. Then create a column in
your query like:
Field: Year([dateRegistered])
Set the criteria to
Forms!frmYourForm!cboYear
 
Back
Top