Search results
-
L
group by year, not month and day
Hi, Ive forgot how to group by only year....:mad: In my query I want to sum all data from ex 2009. But the date are set 2009-01-02... how do I split the date? So in my table I have data från 1966-2009 with several data on each year. I want to group them together by year so that i can get... -
L
How do I use enter key instead of tab?
I made a form in Access 2007. When entering data in a column I want to be able to press the enter key and jump to the next column (or row). But when I try it the data I just added disappear. But with the tab key it works to add data and then move to next column but like I said, instead of using...