Hello,

i hope somebody could help me.

Ok, ich work with Access 2k, i have six tables. The fist and second table with names InkaPro and InkaLite has five rows with the name date, aviable_to, version, description and compTime. The next three tables are the same view like date, name and description and the last table is, i hope my thinking is correct, the junction of all has only datetimes between 01.01.97 and 01.01.05.

So, i need three querys. The first must give me after enter an free date the Version of InkaPro, InkaLite and the name of the other three table apropose the entered date. The next query has as criterion the version of InkaPro and i need an view ofer the InkaLite version and softversion in the time of the InkaPro version. And the last query ist the same as InkaPro query but with InkaLite.

I hope you will understand my problem and could help me.