Hello:

Thanks for the responses! Jack, the data is coming from a UNIX-based custom database that I inherited--it's not in any of the DBMS formats with which I'm familiar. And Gift,...

Hi, Bob:

It seems that you've discovered my problem! I don't want to subtract the times at all--I only want to display the start and end times with a dash to...

Hi, Bob:

Thanks for the quick reply! I tried your suggestion and received the error message "Conversion from type 'TimeSpan' to type 'Date' is not valid." I'm not really familiar with...

Thanks, TKD-BB! I would prefer not to alter my dataset, as it runs a stored procedure that I use for multiple reports, so I tried your second suggestion. Unfortunately, the...

Thanks to you both! Exactly what I needed!! 😀

Hi, GSquared:

I actually had hoped to just get a list of postal codes, but the cheapest one I could find was $100, and, working at a non-profit, I'm trying to...

Thanks to you both for your responses! It turns out that the records with which we'll be working will not change once they're created, so it renders my question moot....

Thanks, Ron--it looks like I'm going to have to resign myself to just hiding the join column. Being new to Access, as I said, as well as being somewhat of...

I must be doing something wrong, because my subforms don't appear in the database objects window at all. Again, they do appear if I use the subform wizard to create...

See, this is where it gets complicated. 🙂 My organization is quite a large one (we have more than 80 databases...that we know of) and our needs vary considerably...