Manipulating & limiting data in a data access page created w/ a qu

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm hoping someone can help me with this.

I am trying to create a data access page from an existing database that
limits the data to a query result and still be able to manipulate the data.
I can't seem to figure out just how to do it. Is it possible?

When I create the page using the fields table I can edit the data just fine
but I cannot seem to limit the data to just one of any given value in the
table. Here's my scenario...

I have a defect database that lists, amoung other things, release number,
priority, assigned to and status. I want to be able to query the database to
select only new and open defects, sort the data by release number but also be
able to change the priority and assigned to fields and have that data persist
to the database when saved. Help!
 
Back
Top