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 IamaSherpa 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
May 23, 2006
292
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
Note / Information box with date and time stamp for each entery
Replies
2
Views
484
dhookom
dhookom
TheresAlwaysAWay
  • Locked
  • Question
Using Domain Aggregate expression in Update Query 2
Replies
12
Views
154
TheresAlwaysAWay
TheresAlwaysAWay
qqp
  • Locked
  • Question
Aggregate function error in query 1
Replies
11
Views
233
JordanSanders
JordanSanders
Triacona
  • Locked
  • Question
you tried to execute a query that does not include the specified expression as part of an aggregate 1
Replies
13
Views
227
Triacona
Triacona
shaunacol
  • Locked
  • Question
using a query to extract information from a text field
Replies
8
Views
113
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top