Hotel Check-in and Check-out dates

[Guest]

What is the formula to create a sorting by check in and check out dates?

i am using this formula =Format$([Arrival],"Long Date",0,0)
and i only get the check-in date. This is how i would like it to look on
the report

August 28, 2006 - August 30, 2006

Can anyone help me.

Thank you

 

[Guest]

Sorting in reports is controlled by specifying sort orders in design view,
under
View > Sorting and Grouping

Your expression can be written like this, although make sure that the
textbox is named something other than one of the field names involved, such
as txtReservation:

= Format$([Arrival], "Long Date", 0, 0) & " - " & Format$([DepartureDate],
"Long Date", 0, 0)


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________