Why my rs.field is not printing out what I see in my Query result

[mp3909]

I have a built a Query in Access that when it runs, it produces the below table:



I have written a code in VBA that opens this table as a recordset.
When I loop through the field "SourceFile" and debug.print its contents, it does not show the part ".csv".
So for example, it will only show "Trade_Exposre_Report_Stage2_MUSE_20190304".

Why is this?

[June7]

No idea.

Post the VBA and query SQL statement.

If you want to provide db for analysis, follow instructions at bottom of my post.

[mp3909]

Hey,

Its ok, I just had to close and reopen the db.