Trying to do select criteria

H

HFlynn

OK very new to this. Looking to basically take one field of a query and
select data only when it falls between data from another table.

example
*select (textfield) only if it falls between ranges of (data text field) and
(field from) if true I want it to select the record from that table and
populate the correct fields.

Thank You..
 
M

MacDermott

Could you be more specific about your table structures, and what you want to
populate from what when?
 
H

HFlynn

I am pulling data using an ODBC driver. I have two different files and I
want one field in say the elgtmp file to basically only be selected when it
either matches or falls between a range of data in other fields a different
file.

They are date fields out of the relativity connection; however, enter access
as text so basically if elgtmp date of 20050101 equals or is beetween the
range of date1 20041231 and date2 20050105 then I want it to select the
record from elgtmp; however if it doesn't meet that critera I want it to
check the next record until the statement is true.
 
M

MacDermott

Sorry -
I'm afraid I need to back up again.
"Pulling data" - creating a recordset? Is this for internal
manipulation, or for binding to a form/report?
Are you trying to select only a single record? (The first which matches
some criteria?) Or several records together? Do you need to include fields
from both tables?
 
H

HFlynn

I think I figured it out. I had to do a between statement on the correct
field. I was just placing my select criteria backwards.

Thank you for taking the time to look at it. :)
 
Top