Thanks for your help joel,

I understand the choices you gave me, But I am not getting the query wright
with tha attachment field in it. It doesnt give me the right results when I
use it in Excel

If rst.fields("7") Is Null and rst.fields("5") = "Chicago" Then
Me.File.Value = "NO"
End If

I tried creating the query in access and running it and it works fine, But
when I do it in excel it doesnt show me the right results.
Do I need to user any specific property of the attachment field in the query
when I am testing if its null? such as rst.fields("7.FileURL") ,
rst.fields("7.FileType") etc?

Basically I am having issues with running the query with attachement field
in the query.

Thanks in advance

"joel" wrote:


You have two choices.

1) Use a SQL statement that gets only the records that meet your
requirements by filtering the Database.

2) move through the recordset like the code below

With rst
.movefirst
Do While Not .EOF
Debug.Print , .Fields(0), .Fields(1)
.MoveNext
Loop


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=167796

Microsoft Office Help

.