Search results

Thanks, Macca. In order to determin the date and time value -can I simply add the arrival date and the arrival time? I don't want the group eliminated from breakfast everyday of their stay, just the first day if the are arriving too late. Thanks t

I think I saw something on this board for how to make a control active or not based on criteria, but I have not been able to find that thread again. Here is my problem: I have a table with [Arrival_Date], [Arrival_Time],[Departure_Date], and [Departure_Time]. Groups may stay for several days...

Please see the posts in the "Design" forum for my results. Thanks to everyone who helped.

Thanks, Doc. I was trying to simplify so that I did not waste your time with extraneous info... maybe I tunicated my description too much. I recieve a start date for an event and the number of days that it will last. I need to schedule meals and buildings/rooms for each day of the event so I...

Thank you Mr. Larson - I will address the naming as once. Other than that, dose this seem like the right way to go with this problem? Thanks, Chef

Thank You! I was only able to use the Alias proprerty to change the names of the tables, not the fields. But you put me on the right track and I found a way to make this happen. (This may or may not have been what you meant by your post) I've made 15 append queries (one for each DAY field...

Wallis - Thank you - sounds like a good way to go... I was unaware of aliasing and just looked it up in the help menu. Sounds like you've put me on the right track. Thanks.

I can't agree more... Many helpful and thoughtful people in this forum with a great deal of expertise. Let me add my thanks as well. t

REPOST from Design Area Hello all, I hope that the following explination of my problem in clear... I have a table with a series of dates in individual fields: Day1, Day2, etc. What I would like to do now is to combine those into another query/table where the dates are all in one field. ie...

Hello all, I hope that the following explination of my problem in clear... I have a table with a series of dates in individual fields: Day1, Day2, etc. What I would like to do now is to combine those into another query/table where the dates are all in one field. ie: Original Table [Day1]...

Thank You Thank You, Rural Guy - great link and I think I even understand it!;) That should do the job.

:confused: I have a table ClientInformation. One of the pieces of information is EmergencyContact. The EmergencyContact may be someone who is also listed as a Client. Some EmergencyContacts may be the contact for several people. Is there a way to gather infomormation from the current table...

Hello, I am trying to create my first "major" data base to be used as a reservation and service schedule for conference center and am stumpped. I would like to be able to enter a starting and ending date for an event, then have multiple records for each day between. I have a query that will...