Set value upon no data returned

[Uvuriel03]

I'm not even sure this is possible. I have a query that, assuming the needed data is there, finds the highest number from a list. Easy.

Here's the hard part.

I can't figure out how to set an automatic first number, just in case there isn't one already there.

I THINK I need to use an IIF() statement, but I have NO idea how to imply the lack of data within it. It would basically look like;, IIF( {no data is returned from}[insert code here],1,

)
 
Anybody have any ideas?

 

[RuralGuy]

How about using a DMax() function instead of a query and if a null is returned then insert your initial value?

 

[Uvuriel03]

I hadn't thought about that. I shall have to test it. ^__^

 

[Uvuriel03]

The Dmax() in conjunction with a little bit of coding worked like a charm! I had to use IfNumeric() to avoid getting a lack of data error, but it works perfectly! Thanks for the idea! ^__^

 

[RuralGuy]

Glad I could help. Merry Christmas.