Dears

since I'm using microsoft acces and recently changed to open office I
encountered the following problem:

when you launch a query in the query window and you have added a table you can
only drag one field at the time into your query selection. I know you can use
the astrix to do this aswell but then you can't add any criteria in the query
window.

In Microsoft acces you can add all the fields from the table at once by double
clicking on the table header (at this point all fields are selected) then you
select with your mouse 1 item in this list (without releasing your mousbutton!!
this is very important) and then you drag everything into the query window
itself, at this point you've added all the fields at once into the query window
and you are allowed to add any criteria you like for each and one of these fields