Dick7Access
Dick S
- Local time
- Today, 12:04
- Joined
- Jun 9, 2009
- Messages
- 4,344
I have a underlining year query with a “like” criteria so user can pick own year for report. Unfortunately we need only the year be entered as we want all months showing for desired year. The data that is being queried is in (mm/dd/yyyy) format typing( yyyy) of course brings up a blank. Where do I go from here? Someone please point me in the right direction.