Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by scy90uk

  1. scy90uk

    Only show certain fields depending on condition - how?

    Thanks LesPaul, I've just tried this, but the query returned the same rows twice. I'm wondering if there is a way to query the fields necessary and hold each of the results in an individual variable each which is then put into a select query? For example: IF Field x = "Y" display Field B...
  2. scy90uk

    Only show certain fields depending on condition - how?

    Thanks Remou, but it only returns some of the results. I was hoping that if field A said field B could not be displayed - it would replace the initial value with a blank value in a new table, so that all the records in the table would be returned but with blank fields where the information...
  3. scy90uk

    Only show certain fields depending on condition - how?

    I'm a bit stuck and fairly creeky with Access. I have a table whereby I need certain fields NOT to display in the query results if another field (in the same row) has a particular value i.e. if chocolate = "n" don't display field "chocolate type". I need to do this for 3 other fields i.e. if...
See more

Part and Inventory Search

Back
Top