Search results

Ya, well, the 3113 would be a WHERE clause... whatever... doesnt matter... I just need to make one list showing all those numbers. When you say... query A then query B... do I make 2 queries then make a UNION of those 2? Sorry, never played with UNION query :confused: Luc

Probably easy question, but I just cant figure it out. Example of a list: 3118 3113 3115 3113 3113 2956 With this list, I need to create a query that will give me one list of all those numbers but 3113. So that I can get. 3118 3115 2956 Thanks in advance, Luc

Thank you!!! :) I will take a look at it. Thanks for the time buddy!! LucS

ok, thank you.

Kryst51, I think you're getting somewhere..... ya, I would love to see your example. This sounds like what I'm trying to do.

Well, logically, if 1 is related to 4 and 2 is related to 4... yes, 1, 2, and 4 should all related. Basically, if 10 IDs are related to ID number 44 .... and I relate 44 to lets say 77. 77, 44, and the 10 IDs should all relate to one another. I hope I'm making myself clear....

I'm a bit confused.... sorry.... I made a little example of what I'm trying to do. As you can see in the database, ID 1 and 2 are related to 4. When I check ID 4, it should be show 1 and 2 are related to 4....

I guess what I dont understand is that, when I open ID 2, how do I check if this calls has related calls? Lets say the separate table has ID (PK) CALLSID RELATEDID ##, 1, 2 If I open ID 1... I see that it is related to 2. But, if I open ID 2, I dont see the relationship. What I did is...

Hi everyone, I'm trying to get some ideas on how to do this. I have a database where I keep call the calls I get (a bit like a call center). What I would like to do is add an option to relate a current call to another call. If I open that call, I could have a little icon showing that this...

When in design view, click the VIEW and then go to :SQL view But you can try it from Microsoft design view also...

This is off the top of my head...I didnt test it... but try this in the where clause: WHERE (isnull([Forms]![frm_Main]![StartDate] and [Forms]![frm_Main]![StopDate]) OR Tablename.Date Between [Forms]![frm_Main]![StartDate] and [Forms]![frm_Main]![StopDate])

You may want to take a look at this. May help you in the future. http://www.datapigtechnologies.com/flashfiles/instrfunction.html

If you are only searching for one field, and only want one name returned and not the same multiple times... you can try this: Add the word "distinct" to the SQL statement: ex: Select distinct.....

In your SQL statement you would want to enter something like this after the WHERE clause: WHERE (isnull(forms![FormName]!TextBox) Or TableName.FieldName Like "*" & forms![FormName]!TextBox & "*") The isnull assures that if the field is blank, it will return everything. If you have more...

What I think you want is something like this: WHERE (isnull(forms!FrmReporting![Combo_RefLocName]) Or TableName.TableFieldName1 Like "*" & forms!FrmReporting![Combo_RefLocName] & "*") And (isnull(forms!FrmReporting!FormFieldName2) Or TableName.TableFieldName2 Like "*" &...

FYI, Just thought you guys should now, could be helpful in the future. And "Alc", you were close. Thanks again for trying. I finally figured it out!!! In the WHERE statement, I added: WHERE ISNULL([X]) OR [TABLE NAME].[FIELD NAME IN TABLE] Like "*" & [X] & "*" So easy, yet, took me a...

Instead of doing an docmd.openreport, how would I requery (or refresh) the subform in a form with the new info?

I'm so very sorry Bob, I just can’t make it work... plus, I dont understand all of it. I only do this part time for a friend. And no, he doesnt pay well, actually, doesnt pay at all... lol I was wandering if you could give an example if I would give you 3 fields name of mine and how you would...

You're the MAN!!!! I did look.... but quickly and I assumed the way it was coded... my bad!!

Dont you have to do all the combinations.... Like if field 1 and 2 have text in them... or field 4 and 5... and so on???