G
Guest
I start with a linked excel table, (generated automatically by a SCADA system
that I cannot edit) that has 3 fields:
RepDate, Date/Time
Turb, Number
State, Number
Data is entered autoimatically every 15 minutes and the RepDate data has
both date and time. I want to count the number of times State = 1 each day.
I also want to establish relationships between RepDate and fields in other
tables that contain dates only (no time). Changing the format allows a
select query to generate the count I want; but every thing I try still leaves
a 'type mismatch' error when joining to other tables in subsequent queries.
Changing the format only seems to hid the time, not remove it.
I think my problem would be solved if I could either: 1) remove the Time
part form the RepTime data, or 2) set all the times equal but not change the
date. Maybe I don't understand where the problem is originating? What do
you think?
Thanks for sharing you suggestions,
Doug M
that I cannot edit) that has 3 fields:
RepDate, Date/Time
Turb, Number
State, Number
Data is entered autoimatically every 15 minutes and the RepDate data has
both date and time. I want to count the number of times State = 1 each day.
I also want to establish relationships between RepDate and fields in other
tables that contain dates only (no time). Changing the format allows a
select query to generate the count I want; but every thing I try still leaves
a 'type mismatch' error when joining to other tables in subsequent queries.
Changing the format only seems to hid the time, not remove it.
I think my problem would be solved if I could either: 1) remove the Time
part form the RepTime data, or 2) set all the times equal but not change the
date. Maybe I don't understand where the problem is originating? What do
you think?
Thanks for sharing you suggestions,
Doug M