Search results

I posted a question yesterday however realised in hindsight that I wasn't particularly clear with what I needed help with. I am looking to input data from two text boxes on a form, indicating a price range and have a query show all records with values between those numerical values. Normally I...

Yeah so on the form there are two input number fields for a price range. I want these input fields to be optional criteria for the query, so by inputting e.g 50 and 100 I get all the values inbetween. However with the criteria I posted earlier, it doesn't take the values i inputted in the...

So I changed the Criteria to: Criteria: Between [Forms]![frmProject Query].[txtProjectValue1] And [Forms]![frmProject Query].[txtProjectValue2] or: Like [Forms]![frmProject Query].[txtProjectValue1]&"*" or: Like [Forms]![frmProject Query].[txtProjectValue2]&"*" however I still got an...

Hi, absolutely brand new to Access. I am trying to set up a query by form with multiple criteria. For the majority of the criteria I'm using the format: Like [Form]![formName].[txtInputboxName] &"*" . I copied the Like (...) &"*" from someone else in order to allow for multiple, optional...