Results 1 to 6 of 6

Thread: Simple Query Problem Please Help, its urgent!

Threaded View

  1. Feb 9th, 2005, 01:22 PM #1
    iParadox
    iParadox is offline

    Thread Starter
    Member
    Join Date
    Jan 2005
    Posts
    51

    Simple Query Problem Please Help, its urgent!

    I am trying to be able to search my database, using a form, but i have one major problem, i have to fill in every feild in the querey.

    Hoe can i have it so when i dont want to search by price, i leave it blank, and it is ignored during the query

    My current to search with the feild is [Forms]![Search]![Price]

    But how can i ignore the feild if it is Null? i tried [Forms]![Search]![Price] or is null but it doesnt work.

    Any Ideas

    Paradox
    Last edited by iParadox; Feb 9th, 2005 at 03:41 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width