Re: Save a filter (from table) as a query
From: Bill Taylor (wtaylor51537_at_earthlink.net)
Date: 04/29/04
- Next message: Bill Taylor: "Re: Please help me with when I can use my key field"
- Previous message: Bill Taylor: "Re: Query won't list more than 25 records"
- In reply to: Sandy: "Save a filter (from table) as a query"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 29 Apr 2004 19:38:28 GMT
No shortcuts, sorry. You can open the table in design mode and open the
property *** to copy the filter property. this will be placed in the
criteria field of the query builder or the WHERE clause of the query.
Example:
table BucketMaterial
Filter ((BucketMaterial.BucketMaterial="Stainless"))
query SELECT * FROM BucketMaterial WHERE
((BucketMaterial.BucketMaterial="Stainless"))
HTH
"Sandy" <swampsec@fast.net> wrote in message
news:5e1a01c42def$50fe1900$a401280a@phx.gbl...
> I opened a table and used the filter key twice, how do I
> now save that information as a query? The only options
> in the drop down box for saving are
> form, report or access page.
>
> Also, when using the filtered method, do I ever run the
> risk of altering my original table and losing all the
> information? I have Access 2002.
- Next message: Bill Taylor: "Re: Please help me with when I can use my key field"
- Previous message: Bill Taylor: "Re: Query won't list more than 25 records"
- In reply to: Sandy: "Save a filter (from table) as a query"
- Messages sorted by: [ date ] [ thread ]
