Visual Foxpro Date/Time link

[hurtman]

I'm using CR XI and trying to report off of some VFP tables. If I report off just one table, I see all data. When I add another table and link the date/time fields (which is a date/hour field), I only see data once every 3 hours (example 12:00, 3:00, 6:00). The date/time looks to be identical between the tables. Any thoughts?

Thanks,
Jeff

 

[kray4660]

You say it appears to be the same. If there is only a slight difference, they will not match(unless you do an outer join).

I have never linked tables in this way. Without exploring the data, I would not be certain that they would be matching.

 

[lbass]

Try a left outer join FROM the original table TO the new table. It may be the new table only has records every three hours, even though in the same datetime format. Also make sure you have no selection criteria using the new table.

-LB