Query that is a sourceof a table

[Samuel]

I use the following query as a source of a table:

SELECT tblClientDetails.*
FROM tblClientDetails
ORDER BY tblClientDetails.strClientNo;

Is it possible that since I started using this instead of using the table as
the source I started having problems because of that, to me it seems
absolutely fine and I wonder if anyone thinks that I should call the fields
separately or else?

Thank you,
Samuel

 

[Dirk Goldgar]

In

I use the following query as a source of a table:

SELECT tblClientDetails.*
FROM tblClientDetails
ORDER BY tblClientDetails.strClientNo;

Is it possible that since I started using this instead of using the
table as the source I started having problems because of that, to me
it seems absolutely fine and I wonder if anyone thinks that I should
call the fields separately or else?

What do you mean by "source of a table"? A table is a table, a query is
a query. Either could be the recordsource of a form or report.

Or do you mean that you are creating a new table from the results of the
query?

I'm puzzled.

 

[Samuel]

I refer to the source of the form!

Thank you,
Samuel

 

[Dirk Goldgar]

In

I refer to the source of the form!

I don't see anything wrong with that as the RecordSource of a form. I
don't see how you could have any problems because of it.

 

[Samuel]

thank you

Samuel

In

I don't see anything wrong with that as the RecordSource of a form. I
don't see how you could have any problems because of it.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)