Ricardo wrote:

> I have a table named Time and I'm trying to create a query that runs
> both in Access and Firebird. The Access query runs if I enclose the
> table name within brackets ([Time]). But Firebird doesn't accept this
> syntax. I have to put the table name within quotes ("Time"). Is there
> a way I can get the query working in both databases?

TIME is a reserved word in all versions of the SQL spec, so it needs to
be hidden in some way for an SQL query to be able to use it for a table
or column name, which the "" provides.
TIME should not be used at all as it confuses matters when you try and
create a column in a table
,TIME TIME
So to make this table work you simple need to change the name to
something that is not reserved.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services