Trying to do select criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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..
 
Could you be more specific about your table structures, and what you want to
populate from what when?
 
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.
 
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?
 
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. :-)
 
Back
Top