Recent content by gtlifter

Hi, I'm trying to use a form to use as a filter tool. I've got a feild in a table with numbers in it that id like to filter by the first digit as defined in the form. I tried this: Like ' Forms![Master List Review Report Filter]![Text31]*' but it returns a blank result?

I've looked over that and its a bit over my head??

Hi, I'm looking to add a file dialog to my forum, so when I click the button it allows users to choose a file, once they click ok i want it insterted in a feild on a table that is hyperlinked. Honestly I have no clue were to begin and none of my searching has worked.

this is what i put in: select * from [Master List] where [ASSIGNED TO] = IIf(Len(Nz([Forms]![Master List Review Report Filter]![Text24],""))=0,[assigned to],[Forms]![Master List Review Report Filter]![Text24]") it returns a error that says "check the subquarys syntax and enclose the subquary...

Hmmm that didnt work, do i need to change the feild type from text?

Hi, I'm new to access ive done a ton of searching but it seems I cant find what im looking for, im creating a filter form so users can choose multiple filters for a query, I'm trying to figure out if theres a function to leave it blank or "show all" and return all the results. I thought of an if...