my query is not display my data when I enter specifc year like 2010 and data is ther

[roy rosales]

SELECT Audit.Station, Audit.AuditType , Audit.AuditSubT ype, Audit.StartDate
FROM Audit
WHERE (((Audit.Countr y)="USA") AND ((Audit.Cycle)= 2010));

[Rabbit]

If year is a string then you'll need quotes.

[roy rosales]

no it's allowing to enter 2009 with out the quotes. i ran it earlier and I was doing a cut and past and when it told me i had to much on the clipboard I canceled out and for some reason every time i enter 2010 on that or anyother query that is filtering for the year 2010 i get o records returned . so Im stomped. could i have some how embeddeda data filet for all of 2010 recoreds ?

[Rabbit]

Is Audit a query or a table?
If it's a query, what is the SQL and the table definition of the tables that make up the query?
If it's a table, what is the table definition?

[roy rosales]

Audit is a Table not sure about definition ?

[Rabbit]

The table definition would be the field name and data type.