crosstab to find the most recent and oldest dates?

Hi,

I have a table like this.
authort(authorid, surname,givenname)
publicationT(publid, title, pubdate)
association(pubid, authorid)

I am trying to use the crosstab to find this
row: Authorid,
column: #of publication, earliest date (of publication),oldest date(of publication)

I am having alittle trouble with find the earliest and oldest.
Can I just use  FIRST and LAST?
I tried it but it errors out.
dkim18Asked:
Who is Participating?
 
peter57rConnect With a Mentor Commented:
You wouldn't use a crosstab for this.

Using the query design grid Just create a query that lists the authorid, title, and the publication date twice.
Convert this to a totals query by clicking the Totals button .
Change the GroupBy in Title to Count, the groupby in the pubdate columns to max and min.
0
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
better upload a copy of the db..
0
 
dkim18Author Commented:
You are right.<br />I don't need the crosstab.<br /><br />Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.