Microsoft Access help

[Whoop]

Hi all,

Can anyone answer this simple (for you!) access question?

I have 3 columns -

| Product | In Stock | Backorder |
|..Cheese..|.......4......|.......4........|
|.....Fish....|.......4......|.......8........|

What I want the Access query to do is hide the line Cheese as "In Stock" and "Backorder" are the same value but I can't find enough info on the expression builder to do it !

Any ideas?

Thanks,


Whoop

 

[Whoop]

SELECT
*
FROM
[Your Table Name]
WHERE
[In Stock] <> [Backorder]

Sounds great, will try in the morning

Thanks,


Whoop

 

[Whoop]

SELECT
*
FROM
[Your Table Name]
WHERE
[In Stock] <> [Backorder]

Hmmm problem with the syntax, where am I missing brackets

SELECT * FROM [Product] WHERE [In Stock] <> [Backorder]


Repeatedly changing and I can't get it to work !!!


Thanks,


Whoop

 

[Whoop]

My thread fell off the page and I'm hoping you'll know where it went wrong


Whoop