Search results

Ya... it's a lot of work... a lot of combinations... but buildable......!! :o Ok boss!! Thanks guys.... if you have other ideas.... let me know.... for now I'll start with the IFs..... lol

Forget about that.... I cant do it with a simple table anymore????? :confused:

I was able to do it with a simple table... but when I do it with LEFT JOINs... it doesnt work.... dont understand??

Ya, I was thinking about that. The only thing is that I have about 9 fields on that form and that's a lot of "IFs" to create..... :eek: But, this shouldnt be this hard to do???

You and me bud :( Thanks for trying....

That is so close.... when entering nothing, everything comes up... that awesome.... but when entering lets say "555", I get that number, plus the null values. Close though.... I thought you had it.

Oups sorry!!! Here you go.

Here, I have made an example of what I'm trying to do. When you double click on the query without the criteria, you get all the info (3 entries). But, when you double click on the one that has the criteria, and leave the field blank (just click ok when it ask for [hnumber]), it will have...

Yes I did try, But when I do that, it comes back with what I searched for and all the "not" nulls.

Hi everyone, I have created a query that queries many tables. The relationships between them and the main table are left joints. The query works fine, I see all my data. The issue that I'm having is when I put a Like statement on a field that has nulls. ex: Like "*" & [txtname] & "*"...

thanks both of you.

This is probably easy for some, Using VB, is there a way to run a query from a form (by clicking on a button), then count the number of entries found and send the results to a text field? If there is not entries found, the text field should display 0. Thanks for any info, Luc

Here's an example in Access 2003 and 2007.

I'm an idiot... instead of putting the ID # of the employee, I was entering the full name... that's why it was giving the error.... Works fine now.... thx

Ya,.... I tried that... didnt work.... I'm getting the error, "This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to...

I have a form which I enter calls coming in for our work. One or more person can work on a call. So I can see who worked on every call. Table info [ID] [TITLE] [employee1] [employee2] [employee3] ...... What I wanted to do is to, is to created a query that will give me all the calls an...

I dont know how to thank you enough!!!! This is awesome.....

Just a question, This is actually what I was looking for a long time.... I love it, and it works great. If I would like to add that if all fields are null... to show all? How would I write this?

Anyone have any suggestions on this would be greatly appreciated. Right now, I can have it working with one field by itself.... or when both are select (just by using "AND" instead of "OR" on my SQL). But I would like to use either.... if one field is selected... or both. Thanks in advance...

Thank you for the quick answer MSAccessRookie, Actually, I think you got confused with my naming of my tables... ish!!! I could have done a better job on those...... [PPD or TRAD] is one field name in my table.... Here's a picture... may be better to understand: Thanks again, Luc