access query

[steven low]

Hi guys im trying to create a access database which has two colums like the example shown below.

Registry          total registry 



///                     3

basically the first colume would contain these symbols /// and i want the second colume to read off the first colume soo if I have /// the total registry colum would show the total number of ///.



how woud i get the tables within access to do this

 

[Bat17]

you would just store Registry in the table and use the len function on a query to calculate total registry on the fly.
TotRegistry = Len(registry)

HTH

Peter

 

[steven low]

I tried what you said

you would just store Registry in the table and use the len function on a query to calculate total registry on the fly.
TotRegistry = Len(registry)

For this I went in the Querys option and created query in design view I put

TotRegistry = Len(registry) in the Criteria section got nothing is this right what i am doing?

 

[steven low]

No luck

Tried what you said in critera it keeps saying error in syntax

could you please send an example please

 

[Bat17]

oops my bad :-(
should have been TotRegistry: Len([registry])

here is a sample

HtH

Peter

 

[steven low]

Hi Bat17

thanks for that.

My other problem is. Say If i wat to just let the colume count // and not these xxx what validation would i use e.g.


Registry total registry



///xx 3

 

[Bat17]

probably a better way, but this should work
TotRegistry: Abs(Len(replace([registry],"/",""))-Len([registry]))

Peter

 

[steven low]

Thanks alot

Got it working

Thanks for your help