I am using CR7 Designer's Select Expert to build a Selection Formula. The Report is connected to an Access 2000 DB utilizing ODBC. There are two tables in the Access DB. One titled "FloatTable" and the other "StringTable". The fields in these tables are as follows:
FloatTable.DateAndTime-----|
FloatTable.TagIndex |
FloatTable.Val |
|
StringTable.DateAndTime----|
StringTable.TagIndex
StringTable.Val
The connection shown above indicates an indexed field within the Access DB. I can get the one of the records that I want in the report, but I can't get the other linked records. My Selection Formula is :
{StringTable.Val} in "2000/07/10 00:00:00" to "2000/07/10 01:59:59". I am basically looking for all records between these two strings. This returns the one record in the DB that matches, but I would like all records that have the same Date/Time value (i.e. the value in StringTable.DateAndTime), as the original correctly returned record. It is almost like using this record as a pointer to all the records I need. Is it possible to do this? How? Any help would be greatly appreciated.
Thanks!
P.S. Take it slow with me. I'm a rookie
[sig][/sig]
FloatTable.DateAndTime-----|
FloatTable.TagIndex |
FloatTable.Val |
|
StringTable.DateAndTime----|
StringTable.TagIndex
StringTable.Val
The connection shown above indicates an indexed field within the Access DB. I can get the one of the records that I want in the report, but I can't get the other linked records. My Selection Formula is :
{StringTable.Val} in "2000/07/10 00:00:00" to "2000/07/10 01:59:59". I am basically looking for all records between these two strings. This returns the one record in the DB that matches, but I would like all records that have the same Date/Time value (i.e. the value in StringTable.DateAndTime), as the original correctly returned record. It is almost like using this record as a pointer to all the records I need. Is it possible to do this? How? Any help would be greatly appreciated.
Thanks!
P.S. Take it slow with me. I'm a rookie
[sig][/sig]