Printing all records that share a common date.

  • Thread starter Thread starter Joseph Ellis
  • Start date Start date
J

Joseph Ellis

Hello all,

I have a table of birthdays that contains, among other things, a date
and corresponding text:

[fullDate]
[text]

Which on a report produces:

April 5: Bob's Birthday
April 11: Jane's Birthday
April 11: Joe's Birthday
April 22: Bill's Birthday

Of course, several people can have the same birthday. First of all,
I'd like to make a query that selects only unique dates. Then I'd
like to make a report that prints each unique date along with the
names of all the people who share that birthdate:

April 5: Bob's Birthday
April 11: Jane's Birthday
Joe's Birthday
April 22: Bill's Birthday

So far I've isolated the uniqe dates with:

SELECT DISTINCT [fullDate] FROM [myTable];

Now how do I go about printing all the names for each unique date?
I'm assuming it'll have to be a subreport, but how do I make the
subreport "list all the people who share this birthdate"?

Thanks for any help.
Joseph
 
Maybe I'm not understanding something, but wouldn't it be enough to have a
report grouped by the date field?

--
Regards,

Sal Rosario
Microsoft Access Database Cosultant
www.salrosario.com
 
Maybe I'm not understanding something, but wouldn't it be enough to have a
report grouped by the date field?
Click to expand...

Well, for some people in the database, I do not have their year of
birth. So one person's birthdate might be 04/22/1976, while another's
might be 04/22/2004 (because their birthdate was input as 04/22). I
would like all people who share the birthdate 04/22 to be grouped
together, regardless of the year.

Is there a way to group reports just by the month and day?
 
Well, for some people in the database, I do not have their year of
birth. So one person's birthdate might be 04/22/1976, while another's
might be 04/22/2004 (because their birthdate was input as 04/22). I
would like all people who share the birthdate 04/22 to be grouped
together, regardless of the year.

Is there a way to group reports just by the month and day?
Click to expand...

Nevermind...I figured it out. I must be tired or something <g>.
Thanks though, Sal. You got my brain back on the right track.

Take care,
Joseph
 
Back
Top