datatype mismatch in criteria expression

[CyberSkillsz]

Hi everyone,

I hope you can help me.

I have a simple database with the following layout:

Table - T_TrafficLog (Main Table)
Row - TimeInOut

Table - T_TimeInOut
Row - In
Row - Out

I tried using the following SQL Query to pull a total count of In and a total count of Out seperately which is shown on a Report.

SELECT Count(T_TrafficLog.TimeInOut) AS CountOfTimeInOut
FROM T_TrafficLog
WHERE (((T_TrafficLog.TimeInOut)="In"));

and

SELECT Count(T_TrafficLog.TimeInOut) AS CountOfTimeInOut
FROM T_TrafficLog
WHERE (((T_TrafficLog.TimeInOut)="In"));

Can you please let me know how I can get the total In and Out count.

Thank you,


Jonathan

[jzwp11]

Welcome to the forum!

I'm a little confused about your tables. You have 2 tables

T_TrafficLog (Main Table)
-TimeInOut

T_TimeInOut
-In
-Out

Is TimeInOut of T_TrafficLog a field? Are In and Out of T_TimeInOut also fields. What are the data types of each field?

How are the two tables related?

Can you provide some examples of typical data in each table?