Simple Question! - Default Values

  • Thread starter Thread starter halfbodyguy
  • Start date Start date
H

halfbodyguy

Hey there, I want to make a default value which uses a Dcount
Expression. I got the Expression to work, and it comes out as expected,
the problem is, i want the Default value to be the Letter "H" And then
the result of the Dcount, For example:

Dcount: =DCount("[Ordernumber]","tblordernumber")"
Reponse: 3

I want the Value to be "H3"

What do I need to put in to make this happen?

Thanks
 
="H" & DCount("[Ordernumber]","tblordernumber")


You had one extra quotation :-) haha, But its working now, and I"m
retarding for not remembering to use the "&" (I just learned, this is
all new)

Anywho it's working now, thanks so much!
 
Back
Top