Search results

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...

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...

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

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...