sort by document type and year

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I have a database displaying documents, document type and year filed.

I would like to create a report showing documents type completed by year.
my field names are as follows
[ProjectName]<--"name of document"
[DocType]
[DateNoticeFiled]

I'd like to end up with something like in 1999 there were X # of document
type 1 filed, X types of doc type 2...

thanks
 
Followup question,

How do I get summary totals of records, I don't need to see all the records
just the number of "document types" sorted by year.

thanks again.

JethroUK© said:
you can multiple sort for the report design view:

View>Sorting & Grouping



tahoe8020 said:
Hello, I have a database displaying documents, document type and year filed.

I would like to create a report showing documents type completed by year.
my field names are as follows
[ProjectName]<--"name of document"
[DocType]
[DateNoticeFiled]

I'd like to end up with something like in 1999 there were X # of document
type 1 filed, X types of doc type 2...

thanks
Click to expand...
Click to expand...
 
in that case use multiple grouping instead of sorting - include totals (
SUM(myfield) ) in the group footers - hide the detail section (if you dont
need it) and just print what's left (the headers & totals)




tahoe8020 said:
Followup question,

How do I get summary totals of records, I don't need to see all the records
just the number of "document types" sorted by year.

thanks again.

JethroUK© said:
you can multiple sort for the report design view:

View>Sorting & Grouping



tahoe8020 said:
Hello, I have a database displaying documents, document type and year filed.

I would like to create a report showing documents type completed by year.
my field names are as follows
[ProjectName]<--"name of document"
[DocType]
[DateNoticeFiled]

I'd like to end up with something like in 1999 there were X # of document
type 1 filed, X types of doc type 2...

thanks
Click to expand...
Click to expand...
Click to expand...
 
The SQL statement to get the data would be

SELECT Year(DateNoticeFiled) as YearNumber, DocType, Count(ProjectName) as
CountDocs
FROM YourTable
GROUP BY Year(DateNoticeFiled), DocType

IF you are doing this in the query grid,
-- Add the table to the query
-- Select your three fields
-- Change the first field to
Field: YearNumber: Year(DateNoticeFiled)
-- Select View: Totals from the menu
-- Change "Group By" under ProjectName to "Count"

Use this query as the source for your report.
 
Back
Top