Instead of SQL view go to design view. Are there any fields in the grid? If
not drag them back down. You can go on forever trying to figure out how they
were lost. Could have been an accident with the space bar or the delete button.
Clauss Gilbert <[EMAIL PROTECTED]> wrote: Has anybody ever had this
bug :
A query, which usually works fine, suddenly answers (approximately,
translated from french) : "The query must have at least one target field".
When i try to see the SQL code, actually there is only "select;", the rest
of the statement has disapeared.
I'm sure i did not (or anybody else) modify the query, nor the
data...Strange
Any tip ?
Thank you
Gilbert Clauss
May God bless you beyond your imagination!
Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us
---------------------------------
Do you Yahoo!?
Get on board. You're invited to try the new Yahoo! Mail Beta.
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/