Problem to create query

  • Thread starter Thread starter esoso via AccessMonster.com
  • Start date Start date
E

esoso via AccessMonster.com

Hi,

I've a query and I would like to select all lines if the parameters is equal
to 1, over, I would like to list all lines wich the parameters equal to [NUM].


The [NUM] columns contains a value 2, 3 or 4.

I've this fields on my query :

[FIRSTNAME],
[LASTNAME],
[NUM].

Thanks by advance
 
SELECT FirstName, LastName, Num
FROM TheTable
WHERE Num =[Parameter] or [Parameter] = 1
 
Back
Top