error message appears when a run a query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sanjay - 12 May 2008 07:56 GMT

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.

Reply to this Message

Tom Wickerath - 12 May 2008 08:47 GMT

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
__________________________________________

> 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.

Reply to this Message