Search results

Some timespans overlap but most don't. But the query repeats everyrecord that pen has been used. So that i do get all the unallocated pens but like pen 4 repeats 4 times. So in report this does not look right. Thanx Thpus

Even with SELECT DISTINCT the query displays all the times that pen has been booked in. Very strange. Thanx Thpus

I need to create a query which will show what pens on todays date do not have a bookings in them. The two tables i would need to use are: Booking Booking_number (which is the primary key) Pen_number (which is the foreign key) start_date end_date Pen Pen_number (primary key)...

Access has no help on DateDiff. I'm probably been really stupid but i created that third field used your code with my fields and it won't except that has code it complans about the colon. Also is the n a varible used from the datediff in the other two colums or do i not put any criteria in them...

Ok so using the datediff function OK, So in creating this third field would i have to add the field the table like other fields. Or can you do this in the query design. Also what would the expression be like for datediff() would i have it in both start date and end date criteria. And how would...

Hey, Well i have to create a query that will enable me to make a report displaying the average length of stay of the dogs i have in my dog kenel database. I know this would need to be done using my booking table which holds all the information on what dogs i have staying and what length of time...