Dates

T

Tobes

I have a table of dates, which is just all the dates till the end of the year.
I have a table of names with dates on it. the dates are booked from and
booked too.
Im wondering is there a way where i can get the database to realise that if
it says booked from and booked too, them two dates and the dates in between
them mean there out of office...... can this be done? please help. Thanks.
 
J

Jeff Boyce

Take a look at "queries" in Access HELP. You'd use a query to find the
rows.

And no, Access, by itself, is not able to associate from/to dates with "out
of office". That's what humans are for.

You will have to tell Access what to associate with what.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
T

Tobes

i knew it wouldn't straight out associate it like that i meant with my
in-put. thanks for the advice but what kinda of query would i use, i can find
a criteria that says link dates between these two fields.....

anymore advice would be much appriciated. Thanks.
 
T

Tobes

Ok sorry for asking for so much help, did abit of research on the web, and
realised the design i was asked to do at start was wrong.

did two tables: tblexcelfile (imported file) tblpersonnel (peoples names +
skills), did 3 queries which have the criteria <=[Please enter date] ,
=[Please enter date] under the appropriate fields, then [Annual Leave by
Click to expand...
Date].[FirstName] , [Annual Leave by Date].[LastName] . Then i did a null
query under names which gave me a nice way of getting my info. Where you have
red alot of my post this should give you an idea of how it was achieved.
 
Top