Re: can you specifie criteria for a parameter query in an Auto Number.
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
On Tue, 13 Sep 2005 14:40:27 -0700, Lea
<Lea@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>I have created a parameter query, and specified criteria in an Auto Number
>field (which is also the primary key) and when i run the query i get no
>results. Why?
Probably because your query, or your criteria, are incorrect.
We can't see them, so we can't help. Care to open the query in SQL
view and help us to help you?
John W. Vinson[MVP]
.
Relevant Pages
- Re: Queries making multiple records
... table description and qty and the other table i have put description qty ... I have linked these with a query using the Primary Key which i ... is it because i have used an auto number on all the lines? ...
(microsoft.public.access.gettingstarted) - Queries making multiple records
... table description and qty and the other table i have put description qty and ... I have linked these with a query using the Primary Key which i have ... is it because i have used an auto number on all the lines? ...
(microsoft.public.access.gettingstarted) - Re: Multiple Statements in a query
... What I'm doing is an insert of a row, where the primary key is an auto ... tried sending another query after the first (once I knew that it the ... increment field all you have to do is query the maximum value in that ...
(comp.lang.php) - Re: Optimizing custom collection for access?
... The only way to filter a collection of objects based on specified criteria ... >time with each having a start datetime and an end datetime. ... >need to query this collection to return a subset of the objects that fall ...
(microsoft.public.dotnet.languages.csharp) - Re: Queries making multiple records
... View your query in SQL view. ... I have linked these with a query using the Primary Key which i have ... is it because i have used an auto number on all the lines? ...
(microsoft.public.access.gettingstarted) |
|
