Hi Franco,
You found a new issue :-) or better :-( because I have to fix it :-):-)
Could please file it and append the query which will be converted into
the wrong order of arguments. Thank you.
Best regards,
Ocke
Franco Fornari wrote:
Hello,
I found a second problem with queries, but this one affects also
standard queries.
I started with two tables with an inner join between their primary
keys. Then I built a simple query with a few fields chosen from both
tables, primary keys included. All worked well until I inserted two
criterions as filter under the same field (OR condition).
The query continue to work, but after closed and re-opened in Design
View, it's structure was changed: the graphical line representing the
relationship was missing and a new field was added to realize the same
relationship.
This way the query continue to work, but in Design View it appears
almost confusing for any further reading and modification. Please,
note that such a modification happens only with two or more criterion
filter, whilst with one criterion only all remain unchanged.
Please, tell me whether this is by design or I have to submit a new
issue. In case, I can send a little sample database.
Thanks in advance,
Franco
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Ocke Janssen Tel: +49 40 23646 661, x66661
Dipl. Inf(FH) Fax: +49 40 23646 550
Sun Microsystems Inc.
Nagelsweg 55 mailto:[EMAIL PROTECTED]
D-20097 Hamburg http://www.sun.com/staroffice
Example isn't another way to teach,
it is the only way to teach.
Albert Einstein
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
