I have a query that I run on some other queries, but if there isnt any data that matches I want the initial query to put default value of zero in its fields. Is this possible?

Thanks

Anything is possible. How are you launching the query? Can you post the SQL?


mmcdonal

The the query is in a SubForm and is launched when the form opens

This is the SQL:
SELECT [Repairs - LS - MT].[# of Welds] AS [Long Seam],
       [Repairs - GW - MT].[# of Welds] AS [Girth Weld],
       [Repairs - RW - MT].[# of Welds] AS [Rack Weld],
       ([Repairs - LS - MT]![# of Welds]+[Repairs - GW - MT]![# of Welds]+[Repairs - RW - MT]![# of Welds])/
       ([Progress_MT]![Long Seam]+[Progress_MT]![Girth Weld]+[Progress_MT]![Rack Weld]) AS [% Complete]
FROM [Repairs - LS - MT], [Repairs - GW - MT], [Repairs - RW - MT], Progress_MT;

It feels like there should be a better way to do this but im at a loss.

I would have to have the database in front of me, but what I might do is use perhaps the On Load event and run the query in code, and then check the record count. If the record count = 0, then substitute your other values.

I know the other posters here should have some more elegant solutions. C'mon folks.

Let me know if you want to go this way and we can work our some code.
I would use ADO or DAO, open a connection and recordset, run the query, check the recordcount. If rs.RecordCount = 0 Then, run the second query with substitute values.



mmcdonal