Search results for query: *

Hi guys, never mind I got it going! YAY I just put the duplicates in another group and then it filtered it out for me. Thanks so much!

Thanks so much lbass - that worked! I had to modify it a little bit because I had to modify hastrue flag to if {table.exists} then 1. Now the assets with any true flags definitely don't show up. You are a genius! There's still a little to do though because there are duplicates (for all the...

Hi Turkbear. Thanks so much. I don't think it works, because I haven't explained properly. I tried the equijoin and also the Not In statements, but the problem is that I have to evaluate whether or not there is a flag after I've returned the data. Here's a sample of the report: Asset...

Hi guys. Sorry for the confusing explanation, but I'm a newb so here goes. I have a crazy report that has one main table, then it has links (some outer joins) to 6 other tables, so it's a beast. I have it working semi ok with just the outer joins and links, but now have a quandary with one...

Hi guys. Harley, that was my problem - and PScott, I didn't know my strings from my arrays! The records (in access) returned from this query could be one line or up to 3 or 4 lines. The only difference for each record is the STAND_ID number. So I did the EOF thing (or a Do Until EOF and...

I've been stuck on this for a while as a newb, so please forgive me in advance. Any help would be very appreciated. I wrote a little script to query a sql server database. Everything works except the fact that more than one recordset can be returned, and each record can have more than one...