Search results

I have a form that has a bunch of project information and scrolling buttons at the bottom to browse by next/last. Right now the form is sorted by the ID associated with the project, which kinda sucks because they were and are not put in alphabetically. I discovered if you right click on a...

Maybe you can't do it :(

I think you are misunderstanding what I am saying. I basically need 3 outputs. 1 output describes ALL of the records with ANY status in my check box field. I was hoping to use the "thirdstate" option of a checkbox (puts a gray square in it). The other 2 (0/1) are straightforward and bring back...

I need the check box to return all results if its say...in the thirdstate, and the individual status whether its 1 or 0

I'm also wondering if there is a wildcard for a checkbox, if anyone can answer that.

How about a screenshot of your query and your tables.

Yeah I know some guys from Essex, UK. Niall Chadwick for one. Maybe you know him! Essex is a town in the province of Ontario.

I have a form field with a date in it, is there any way I can make the value in that field display one thing, but still run a query based on the original text? for example: txtDate is 1/1/1000 if txtDate = 1/1/1000 then display = "*" but the query still runs on 1/1/1000 I am asking this...

Colin my hometown is Essex :) (Canada)

You will need to create and update query with the criteria "+%%%3*" and the update as "+%%%71*" Should work for you.

Make the default for all 4 fields "*" and use "Like [Forms]![DailyWorkForm]![commonth]" etc for your criteria.

I'm saying that doing something like this "Between * and *" for a date has never been done and the only way people can figure out how to do such a "wildcard" is to use "Between 1/1/1000 and 1/1/3000" therefore including all dates possible for computing and then some. In my case, I am using a...

I did a bit of reading, seems between date wildcards a bit of a mystery in the access world.

Yeah that documents "Like" but im not sure Between is the same thing

I have another question on this topic, I also have dates that I want to be wildcarded, I have tried using just a simple * for the "Between [field] and [field]" to get "Between * and *" but this does not work as I had hoped. Is there a special way to do a wildcard for a date?

Ah there we go, I used Like [Forms]![Refurb-WildcardReport]![RefurbWildcard-Set] Maybe I had the syntax wrong before

That worked for the wildcard (simply * in the search box) but returned no results when searching for a specific record. Say "G4"

I am running a query that links to a "wildcard" form so that the user can basically run a query filtered on any field they want. For some reason when I try to use wildcards along with Criteria in my query the query will not return any results. I know the link to the textbox is right because if...

Alright I got this figured out.I just took the code from the original query and translated it to the criteria that could be used for a query. Worked perfectly.

I have a report that uses the code found below the filter the report by date. I have no idea where I found the code as I made this a long time ago, but now it has been requested that I add another filter to the actual report in addition to the date filter. This isn't the same setup as I have...