Recent content by bkanealy

Pat, I tried the Not in and still get the same thing. Yeah, I put "" around 999, because this loopy (lotus notes) database was created where the trouble ticket is a text field not numeric. So, I've been trying the variations of "999*" to get rid of the incorrect ticket numbers, but have been...

Dcx693, Thanks, I'll give that criteria in B a try. For the "not", I'd tried putting the criteria on the same line with no luck. Pat, Yes, I realize the best solution is to make it correct; however, I'm only an end user not an admin. One table is linked from an AS400. The other (the...

All, I have two tables with the same field name "trouble ticket"; however, when one table was created the field was made text. I was going to make a query that converts the field to a value and then use that query in another query to join the information. Is it possible to do that in one...

Rich, Thanks very much. Brian

All, I have two tables one is linked from an AS400. The first table is an extract where the field I want to search is text, but the field in the linked table is a number. I've been trying to use the "format" function in a query and then use the query to pull against the linked table, but I'm...

DCX, Not a problem thanks for your assistance. I hope you can read this as I don't think it will come out like I typed it in. The fields I'm seperating by "--". Thanks again, Brian In table one; Customer #-- Conversion Date 555444-- 20040301 555445-- 20040326...

Yes, there would be more than one occurence in table 2. What I'd like to see is if the most recent date in table two is greater than the date in table 1. We have a conversion date in table one and higher ups would like to know if there are trouble tickets for a customer in table two created...

All, I have two date fields in seperate tables. I'd like to get records from table 1 where the effective date field resides when it is less than the trouble ticket field in table 2. Is there a way in a query to accomplish this? Thanks in advance. Brian

FoFa, No, we access the Lotus Notes DB directly using ODBC drivers. There is no extract. Thanks for your input. Brian

All, We have a report that is created off of a Lotus Notes database. I'm trying to pull records for one field that should have multiple occurences, but I only get one record back. When I test it against other records I don't always get the same record back. When they print out the record...