exclude some field in a query

[Guest_imported]

Hi !

I'm try to automate some work to produce a web application that can manage an Access database.

In this case, I'm looking for some way to exclude a field from the return of a query.

Say Ma table contains a field 'phoneNumber' and other fields (say 'firstName' 'lastName', ...),
I want to set up a query whitch returns all the fields except 'phoneNumber'...

Is it possible (with SQL) ?
Any one can help me to do this ?

 

[mymou]

Hi goups

How about Create a temp table and delete that column?

Stew "Make good use of bad rubbish."