Sorting and Preventing Blank Lines

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

Guest

I pretty new to Access. I have a database that contains employees, their spouses and their spouses' dates of birth. I want to create a report that lists the spouse name and his/her date of birth sorted by the month. The DOB format is mm/dd; 99/99. When I sort, it sorts by month, then day, then year the information was entered so a DOB of 1/11 entered last year is at the top of the list and a DOB of 1/11 entered this year is at the bottom of the list. Also, some employees don't have spouses. The report shows a blank line where there is no spouse so I have a big blank space at the top of the report

Thanks for your help!
 
Hi Cindy.
First let us address the Sorting Issue:
in order to sort by month, day, year you would create a
field in the query for each one of these and and cause the
query to sort on these.
for month use "month([YourDate])"
for day use "day([YourDate])"
and for year use "Year(YourDate])"
with out the quotes.
To remove any of the blank lines, you may set the
properties for the textboxes and the detail field "can
shrink" property to yes.
Hope this gets you on the right track.
Fons
-----Original Message-----
I pretty new to Access. I have a database that contains
Click to expand...
employees, their spouses and their spouses' dates of
birth. I want to create a report that lists the spouse
name and his/her date of birth sorted by the month. The
DOB format is mm/dd; 99/99. When I sort, it sorts by
month, then day, then year the information was entered so
a DOB of 1/11 entered last year is at the top of the list
and a DOB of 1/11 entered this year is at the bottom of
the list. Also, some employees don't have spouses. The
report shows a blank line where there is no spouse so I
have a big blank space at the top of the report.
 
To remove the blank line, right-click on the spouse field, choose
Properties, click on the Format tab, and change Can Grow to Yes.

HTH,
Debbie


I pretty new to Access. I have a database that contains employees, their
spouses and their spouses' dates of birth. I want to create a report that
lists the spouse name and his/her date of birth sorted by the month. The
DOB format is mm/dd; 99/99. When I sort, it sorts by month, then day, then
year the information was entered so a DOB of 1/11 entered last year is at
the top of the list and a DOB of 1/11 entered this year is at the bottom of
the list. Also, some employees don't have spouses. The report shows a
blank line where there is no spouse so I have a big blank space at the top
of the report.

Thanks for your help!
 
Back
Top