Select Top Function

  • Thread starter Thread starter Gabriela
  • Start date Start date
G

Gabriela

I need to use the "Select Top ... Records" function that
comes built into Access queries, but with a different
twist:
I have a query that gives me a number result which is the
number I need to use as "Select Top" in another query.
Is there a way in which I can have the result of my first
query (a table with only one row and one field showing
the number)linked to the Select Top of another query, so
that this new query only gives me (for example) Top 6
records that fit the criteria.
Thanks for the help
 
Gabriela,

You could try something like:

"SELECT TOP DFirst("[FieldName]", "QueryName") ..."

i.e. use the DFirst function in the query to return the number of records as
calculated in the other query.

HTH,
Nikos
 
Back
Top