counting question

[ali zaib]

can we use countif or sumif in access

[Robeen]

Where are you wanting to use these?

Could you give an example of what you want to achieve with those functions?

If you want to use them in a Query - you could research the IIF function that is commonly used in Access queries.
I believe you can achieve what you need with IIF.
I have not come across sumif or countif in Access.

[ali zaib]

sir i want to count the total issue parts in jan and total amount of parts
i face another problem when i sorting to month its start from april i mean a to z
but i want to start from jan and end at dec

[Robeen]

If you sort by month - then if you have data from Jan of 2010 and 2011 - you will get all those in your Jan sort.
Is that what you want?
Of course - you can put a criteria in to only select records for a certain year . . .

If you want to sort by month - you will have to use a month number [Jan = 1, Feb = 2, Mar = 3 . . .] rather than the month name. That way all your records will sort by the month.

[RayMilhon]

I normally use 2 columns for date sorts the first in date format to sort by and the second to format the date "mmm yyyy" For display. If the query is a group by Then depending on if the criteria is Jan 1 through Dec 31 Or a different period that can have multiple years I sor by month([datefield] or I use 2 columns the first is Year([datefield]) the second is Month([datefield]).

[Robeen]

Good one, Ray! I'll have to remember that the next time I need to do this.
Didn't think of using different portions of the same date field to do my sorts on!
Thanks!

[RayMilhon]

No problem Robeen, My brain is like a comet once every decade or so it passes by close enough for me to use it.