Search results for query: *

Morning All, I have an MS SQL 7.0 database with an Access front end. The front end is used by about 7 people. There are two views that I have linked via ODBC to Access. There are several queries which reference them, that are used in forms. The problem: When starting Access some users are...

VE, Thanks for the response. I've done that, I suppressed everything but the details and shrunk the details down as well. The subreport still takes up twice as much space as it needs..... Ed Colbeth

I'm inserting a subreport into a report in the details section. I'm trying to line up all of the columns from the subreport and report. I made the borders go away. I have no problem doing this in design mode, but when I preview the subreport the columns are not lined up. And, in preview mode...

Steve, Thanks again for your time! Ed Colbeth

I don't think that will work..... WtrWtrBeds: SELECT rmgt_t_Room_Person.ck_Bed_Space, rmgt_t_Room_Person.ck_Move_In_Date FROM rmgt_t_Room_Person WHERE (((rmgt_t_Room_Person.ck_Move_In_Date)=#1/1/2001#)); AllBds: SELECT rmgt_t_Room_Configs.ck_Bed_Space FROM rmgt_t_Room_Configs LEFT JOIN...

Sorry, I'm using Crystal Reports 8.0.1.0 and Access 97. Thanks, Ed Colbeth

Steve, Great idea! But how do I pass the date parameter {?term} to Access? Thanks, Ed Colbeth

I've been working on this for a couple of weeks. I'm new to Crystal and don't know programming. Any help would be greatly appreciated! Thanks, Ed Colbeth

Hello, I'm trying to display all of the bed spaces in the "booked bed spaces" table(rmgt_t_room_person.ck_bed_space) for a parameter(?term) as well as all the rooms that are unbooked for the same period. (rmgt_t_room_configs.pk_bed_space) Contains all bed spaces. The "all bed...