boblarson
Smeghead
- Local time
- Today, 13:59
- Joined
- Jan 12, 2001
- Messages
- 32,040
Nope, if you look at the code behind my sample (it would appear you haven't) you will see how it is done.
Query Problem with Left Joint
- Thread starter rockyjr
- Start date
Nope, if you look at the code behind my sample (it would appear you haven't) you will see how it is done.
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 do it?
It's a basic form with a subform at the bottom pointing to a query(Calls-to-find). There's a search button that would have the codes in it.
Query fields : [Title] and [Opened Date] and [ReportID] (that's the one sometimes null)
Form fields : [txttitle] and [startdate], [enddate] and [txtreportid]
-For [Title] I would like to do a Like statement (Like "*" & [txttitle] & "*")
-For [Opened Date]... a Between [startdate] and [enddate]
-Form [ReportID] I would like to do a Like statement also
Any help is beautiful!!
Thanks
Luc
I was wandering if you could give an example if I would give you 3 fields name of mine and how you would do it?
It's a basic form with a subform at the bottom pointing to a query(Calls-to-find). There's a search button that would have the codes in it.
Query fields : [Title] and [Opened Date] and [ReportID] (that's the one sometimes null)
Form fields : [txttitle] and [startdate], [enddate] and [txtreportid]
-For [Title] I would like to do a Like statement (Like "*" & [txttitle] & "*")
-For [Opened Date]... a Between [startdate] and [enddate]
-Form [ReportID] I would like to do a Like statement also
Any help is beautiful!!
Thanks
Luc
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 long time to do it.
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 long time to do it.
Similar threads
