TOP x PERSENT

  • Thread starter Thread starter vj
  • Start date Start date
V

vj

hi all,

is it possible to input x persent from form (using unbound
or any possible way) and relate it to query to show me the
TOP x PERSENT from my table? how to do that?

thanks,
vj
 
HI,


Not in the SQL statement, that x cannot be a parameter. You can built
the command, as a string, at run time (through concatenation of the various
element making the string that would become the SQL statement to be use).

Hoping it may help,
Vanderghast, Access MVP
 
Back
Top