LjushaMisha
Registered User.
- Local time
- Today, 06:16
- Joined
- Mar 10, 2017
- Messages
- 55
Hello.
I have 2 tables. One is [tblTimes] with two fields, first field is [IdTime], wich is actually a numeric value of, for example, 6/24 = 0,25. --> field size = Double. The second field is text and the value is 06:00. First part of table:
IdTime MyTime
0,00000 00:00
0,01042 00:15
0,02083 00:30
0,03125 00:45
and so on
In the other table I'd like to dLookp [MyTime] using following line in query field:
Time: DLookUp("[MyTime]";"tblTimes";"[IdTime] = " & [table02].[id02Time])
(you have probably noticed I'm using "continental" setups.
If I change [IDTime] and [ID02Time] to Integer everything works great, but it doesn't have a sense.
You my also ask me why using this type of table, why not using whole numbers, etc.
But mainly I'm interested what is "WRONG" with DOUBLE field size, format STANDARD, Decimal Places: 6 (normally in both tables same setups. Also I've established JOIN PROPERTIES to INNER JOIN - show records equal in both tables.
ANY HELP ??? PLEASE!!!! :banghead:
I have 2 tables. One is [tblTimes] with two fields, first field is [IdTime], wich is actually a numeric value of, for example, 6/24 = 0,25. --> field size = Double. The second field is text and the value is 06:00. First part of table:
IdTime MyTime
0,00000 00:00
0,01042 00:15
0,02083 00:30
0,03125 00:45
and so on
In the other table I'd like to dLookp [MyTime] using following line in query field:
Time: DLookUp("[MyTime]";"tblTimes";"[IdTime] = " & [table02].[id02Time])
(you have probably noticed I'm using "continental" setups.
If I change [IDTime] and [ID02Time] to Integer everything works great, but it doesn't have a sense.
You my also ask me why using this type of table, why not using whole numbers, etc.
But mainly I'm interested what is "WRONG" with DOUBLE field size, format STANDARD, Decimal Places: 6 (normally in both tables same setups. Also I've established JOIN PROPERTIES to INNER JOIN - show records equal in both tables.
ANY HELP ??? PLEASE!!!! :banghead: