EXpression Builder 1

[thetusk6]

I need the simple expression on how to make a field in a table only hold 9 digits...no more no less....please help.

Thanks,

thetusk6

 

[SgtJarrow]

In the InputMask property, simply put nine zeros....000000000. A zero says there MUST be a digit in that field....... Programming isn't a profession of choice.
It's a profession of calling...
"Hey Programmer, your application broke again!"

Robert L. Johnson III, A+, Network+, MCP
robert.l.johnson.iii@citi.com

 

[maccess]

I am new in the Access World, so pardon the basic question. But what is the expression that will allow my report to list only one line item with the total number of simlilar items next to it, as opposed to listing every instance of that particular line item seperately?

Thanks.