Query - how to show a field in two cols. (year /monthwise)

[blinker]

Hi, All,

i have one table having full year data, what i want is sumup one field with two criterias.

i want to show my data as below

branch full year may04
A 1000 300
B 2000 200
C 3000 500

how can make this query design

or any other way to do this

blinker

 

[Norie]

Try using the Year and Month functions with your date.