Problem with Query

J

jy

Hi,

I have a query here.

If I have created a form for users to key in the Length and Width for
example, and would like to sort records in my database according to the
following format:
"[Length] mm x [Width] mm", how do I go about it? There are other Fields in
the Table.

I have tried using a query to combine the two fields but a message box
appeared saying that the recordsource for this form or report is not found,
blah, blah, blah....

Any ideas? ;-)
 
L

Larry Daugherty

You would sort on those fields in your query. The query returns the
fields sorted as you direct. The sort doesn't change just because
someone entered some new data, the only thing that happens is that one
more row of data shows up in the query.

If you are looking directly at the data in your table you will just
see the last row appended at the end. That's just as it should be.
The query doesn't rearrange the data in the table, only presents it to
you from the query.

HTH
 
Top