Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Aggregate Information

Status
Not open for further replies.
goslincm

goslincm

MIS
Joined
May 23, 2006
Messages
292
Location
US
I am working with one table that has a field indicating: FiscalYearEndMonth, UnitName, LocalUnitType.

I need to get a summary information by fiscalyearendmonth and localunittype.

I'm not certain how to get this aggregrate information.
 
Sort by date Sort by votes
can you provide some sample data and expected results? Do you want to count the number of LocalUnitTypes or is that something that needs to be summed?

Leslie

In an open world there's no need for windows and gates
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

datajockey123
  • Locked
  • Question Question
Note / Information box with date and time stamp for each entery
Replies
2
Views
963
dhookom
dhookom
TheresAlwaysAWay
  • Locked
  • Question Question
Using Domain Aggregate expression in Update Query
Replies
12
Views
643
TheresAlwaysAWay
TheresAlwaysAWay
qqp
  • Locked
  • Question Question
Aggregate function error in query
Replies
11
Views
726
JordanSanders
JordanSanders
Triacona
  • Locked
  • Question Question
you tried to execute a query that does not include the specified expression as part of an aggregate
Replies
13
Views
709
Triacona
Triacona
shaunacol
  • Locked
  • Question Question
using a query to extract information from a text field
Replies
8
Views
407
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top