T
tkosel
I already posted this once, but perhaps didn't phrase it right. I have an
Access 2003 Application that contains a linked table from a SQL Server 2000
Database. (It was upsized from Access 97.)
The following Query SQL yields many records.
SELECT Absences.ID, Absences.Date, Absences.Reason_Code,
Absences.FMLA_Transaction_Complete
FROM Absences
WHERE (((Absences.Reason_Code) Like "f"))
ORDER BY Absences.Date DESC;
I have included the top 4 records.
ID Date Reason_Code FMLA_Transaction_Complete
147169 8/15/2005 F 0
146858 4/12/2005 F -1
146809 4/12/2005 F -1
146976 4/12/2005 F -1
Reason_Code is a Bit Data type field in SQL. Since I am only interested in
records where the reason code is F and the FMLA_Transaction_Complete is
False, I changed the query. If I add the following to the Query, I get no
records returned.
SELECT Absences.ID, Absences.Date, Absences.Reason_Code,
Absences.FMLA_Transaction_Complete
FROM Absences
WHERE (((Absences.Reason_Code) Like "f") AND
((Absences.FMLA_Transaction_Complete)=False))
ORDER BY Absences.Date DESC;
Interesting note. If I open the linked table in table view in access and
filter on the FMLA_Transaction_Complete field for False, it returns the right
records.
Another interesting note, if I Import the data rather than link it, the
query works properly.
Can anyone help me? I am stuck, have wasted too much time on this!
Access 2003 Application that contains a linked table from a SQL Server 2000
Database. (It was upsized from Access 97.)
The following Query SQL yields many records.
SELECT Absences.ID, Absences.Date, Absences.Reason_Code,
Absences.FMLA_Transaction_Complete
FROM Absences
WHERE (((Absences.Reason_Code) Like "f"))
ORDER BY Absences.Date DESC;
I have included the top 4 records.
ID Date Reason_Code FMLA_Transaction_Complete
147169 8/15/2005 F 0
146858 4/12/2005 F -1
146809 4/12/2005 F -1
146976 4/12/2005 F -1
Reason_Code is a Bit Data type field in SQL. Since I am only interested in
records where the reason code is F and the FMLA_Transaction_Complete is
False, I changed the query. If I add the following to the Query, I get no
records returned.
SELECT Absences.ID, Absences.Date, Absences.Reason_Code,
Absences.FMLA_Transaction_Complete
FROM Absences
WHERE (((Absences.Reason_Code) Like "f") AND
((Absences.FMLA_Transaction_Complete)=False))
ORDER BY Absences.Date DESC;
Interesting note. If I open the linked table in table view in access and
filter on the FMLA_Transaction_Complete field for False, it returns the right
records.
Another interesting note, if I Import the data rather than link it, the
query works properly.
Can anyone help me? I am stuck, have wasted too much time on this!