query criteria problem

  • Thread starter Thread starter Sharon
  • Start date Start date
S

Sharon

I have a simple select query based on a table linked to
a .csv file. The query contains a field as follows:

Balance Remaining: [FY04]-[YTD]

When I try to enter any query criteria for the above field
I get the error:

The text file specification 'Grants Link Specification20'
does not exist. You can't import, export, or link using
the specification.

Is it not permissible to enter criteria for calculated
fields in a query?
 
It sounds to me the problem is in the Linked Table rather the Query.
Somehow the link is made using the Import / Export / Link Specification
'Grants Link Specification20' which doesn't exist.

Try deleting & re-creating the Linked Table.
 
Back
Top