Recent content by TEOA

Hi, I have conducted several searches but none of the results seem to be able to answer my query, now im sure it's going to be down to my lack of understanding so appologies if the answer has been staring me in the face! I am putting together a database for work, I have a table that is...

I have several tables that I am linking for a query, one of them however has a date and time field and one is just a date. unfortunatly when I try to link them I dont get any results, So what I want to know is can I put a left command in to the link so that the link only looks at the fist 10...

I have 3 odbc linked tables that I use to create a report, but as I am using tables from more than 1 odbc source I get a message saying that I will be unable to use Sql. Does anyone know of a work around for this, I need to add an Sql statement in to the query as the data type from one table is...

Worked great thanks :-)

Thanks for the quick Response :-) ill give that a go at work tomorow

Hi My Name Is jon, I work for Tyco within there Lean team TEOA Part of my role involves running lots of data extracts, so im becoming used to running queries and writing reports. Im also slowly learning VB. Found your forum very helpfull so far and have just posted my first question, so thought...

Hi I want to link two tables together, both tables has a field called opr_nbr This is the operation number (05 for example) The trouble is in one of the tables the data is a number in the other is text. The fields are outputs from legacy systems, I want an easy way to link these tables so that I...