I've build a small database to publish a calendar of events. Of course, one field displays the time for an event. I built the table with an EventTime field with format: Date/Time. Next I built a data-entry form to allow quick and easy entry of events. I also built a report to print a "Calendar of events for [month & year]." Everything uses the table as the data source. The EventTime field allows me to enter a time as, e.g., 11:30 AM. That worked fine until I ran into an event where the sponsor wants to show a range of time, e.g., 12:00-2:00 PM.
I built a query to use as the data source with fields for Start time and End time. In the report, I replaced the Time field with an unbound text box that displays a concatenation: [EventTimeStart] &"-"& [EventTimeEnd]. Now I have some new problems.
[list=1]<LI> Wasted space