error message appears when a run a query

[Sanjay]

When I run a query i receive a error message in the cost/currency field. The
error message is meant to represent 0. Does anyone know how to change the
error message so it reads 0. I have tried to put a delfault value of 0 in the
cost field but it didnt work.

Thanks.

 

[Tom Wickerath]

Hi Sanjay,

When I run a query i receive a error message in the cost/currency field.

What is the exact error message? It might also be helpful to provide the
SQL statement for your query. In Access 2003 and lower versions, open the
query in design view. Click on View | SQL View. Copy the SQL statement, and
paste it into a reply. Hopefully, it is not a bloody long SQL statement.
That's why I say it *may* be helpful.

The error message is meant to represent 0.

I don't understand what you are saying here.

I have tried to put a delfault value of 0 in the cost field but it didnt work.

What happened when you tried this? Did you add the default value in table
design view?


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________