Search results for query: *

anybody have any luck with this one yet? :) Thanks,I've had a good time. This wasn't one of them.

arrival date would be 01/01/2007 (mm/dd/yyyy) format and departure date would be 01/05/2007 (mm/dd/yyyy) format. should have stated the date format. sorry. :) Thanks,I've had a good time. This wasn't one of them.

ohhh! SO CLOSE! but not quite. It's now returing the data sort of correctly with two exceptions. 1. Example: john doe rents cabin 1 from 01/01/2007 to 01/05/2007 (he leaves on 01/05/2007). the cabin needs to become available again on the departure day (thusly it should show up on the query...

Now I'm thinking my cabin information table should be somewhere in this query or statement. How can i return all cabins available if one or more cabins were never reserved?The cabin field in the cabin reservation table looks up to the cabin information table. I did put that in my initial post...

oK. Here is the code I put in my query. SELECT [Cabin Reservation Table].Cabin FROM [Cabin Reservation Table] WHERE ([Cabin Reservation Table].[Arrival Date]>=Forms![Cabin Reservation Form]![Departure Date] Or [Cabin Reservation Table].[Departure Date]<=Forms![Cabin Reservation Form]![Arrival...

yup. it returned booked cabins only. is there some other easier way to do this? I'm open for suggestions. I was in the park wondering why frisbees got bigger as they got closer. Then it hit me.

ok. now I'm a little lost. I need all cabins that are not booked for those dates unless there is some other way to prevent double booking. I was in the park wondering why frisbees got bigger as they got closer. Then it hit me.

I have this SQl In my available cabins query but it isn't giving me the results I want. Before I go further I want to at least get the results I'm looking for. SELECT [Cabin Reservation Table].cabin FROM [Cabin Reservation Table] WHERE ((([Cabin Reservation Table].[Arrival...

Question 1: I have reservation database in access 2007 I have a cabin information table with: cabinid (primarykey) cabinname(text) cabinlocation(text) I have a customer table with: customer id(primary key) last name (text) first name (text) address(text) I have a reservation table with...

That's exactly what I'm talking about Lespaul, thanks for the abriged version of what I was trying to get at. Now if any kind guru's out there can assist??? :)

Hop e this clears it up a little on what I'm looking for. (start time field, stop time field and populate a table with those 2 times and every time in between based on the number of minute intervals the user inputs so the user does not have to manually enter each time into a table.) It's...

I am trying to create a form that a user can input start time/stop time, then intervals in minutes that will update a table with the results. Example: User inputs start time 9:00 AM and stop time of 10:00 AM with 15 minute intervals. The table would then contain 9:00 AM 9:15 AM 9:30 AM 9:45 AM...

I have a query in Access 2002 that outputs to excel.In the query is a field called date. Is it possible to change the format of the date field in the query when it outputs into excel but not affect the database format? The problem is that I don't want the query to output the date field in the...

I have a query in MS Access 2002 that outputs to excel. In access I created a module that rounds and truncates numbers to the nearest tenth in an after update event on a form. Example: 1.45559999 will round up to 1.5 and truncate off anything else. When I pull the query into an excel...

Well I've tried it and it seems to be working perfectly.

Hi. I have the following tables. Employee employeeid-autonumber primary key Name- text Projects Projectid-autonumber primary key projectname- text projectdescription-text Boxes boxid-autonumber primary key boxname-test boxdescription-text projectid-lookup to project Worklog...

I think I found another answer to rounding and truncating numbers also in the Microsoft Knowledge base article 97524 which I have pasted below. I'll add to this thread once I try it and let you know if it works. This article was previously published under Q97524 Moderate: Requires basic...

I have to calculate the hours based on tenths of an hour (1 hr 30 mins = 1.5). How do I round up anything in hundreths greater that 5 (1.35 rounds to 1.4 and 1.34 to 1.3)

I'm not sure how to do this. Can you show me some example code?

I have the project in a lookup now. The formulas posted won't work because they are cumulative formulas (after the first 8 hours is reached everything entered in after that will be in the overtime field as there is no reference to a particular date). I need the formulas to work for one give...