access query Help

[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

 

[lingsn]

What I can think of it is to have a access table with Registry column, then use the Queries to create the view:


SELECT Table2.Registry, Len([Registry]) AS TtlRegistry
FROM Table2;

 

[Steven Low]

Hi lingsn

I am not sure were i type that query in access. when you say query im thinking the query section and type that under critera but it isnt is it?

Could you please explain were i would be typing this query please?

Thanks

 

[lingsn]

Yes, it is in the "Queries",

1) click on new button up there, then it will pop up a new query box
2) Select the design view
3) It will as you to chose table, just close it.
4) In the menu, select View->SQL View, then paste the query in the previuos post, or you create your own query there, and save the query.

 

[Steven Low]

Hi lingsn

got it working

but i like to just count / and not anything else like x

heres what i have done: what would i need to include to just count \

SELECT student.StudentID, student.Firstname, student.Lastname, student.Age, student.[Dance Stage], student.Attendence, student.tname, Len([Attendence]) AS totalattendence
FROM student;