Newbie - Finding dates in several fields

P

PSCairguy

I have a table with 'member name', 'spouse', 'birthday', 'spouse birthday'.
I want to set up a query to take birthdays for member and spouse on one
form/report. I can do it separately, can they be combined?
 
S

S.Clark [Access MVP]

Queries can be used for data entry, with limitations based on any joins in
the query.
I would think, in your case, that setting the form's recordsource to the
table should do the trick.

Steve Clark, Access MVP
fmsinc.com/consulting
 
P

PSCairguy

Thanks for the answer, but I need to rephrase the question...
I would like to take the information in the fields and sort by the persons
birthday. I want to put the birthdays for each month on a form of some sort.
(All birthdays for January - 'member name' and 'spouse name')
 
Top