Patrick,

>Q2. Is there anywhere i can print the same record more than 1 ?
> I setup a label with 4 column number in the pagesetup but i cant find way
> to print entire page on the same record unless i've to manipulate the same
> exp to the entire page...
>

I don't think the label designer allows you to do this. However, it's quite easy to work around.
You could ask the user how many labels to print for each record then do something like this:

*-- select your result set
SELECT 

*-- get table structure
=AFIELDS(laStruct)

*-- create a cursor with the same structure
CREATE CURSOR  FROM ARRAY laStruct

SELECT 

*-- loop through result set and duplicate the records n times
SCAN

	FOR i = 1 TO lnLabel

		SCATTER MEMVAR MEMO
		INSERT INTO  FROM MEMVAR

	ENDFOR &&* i = 1 TO lnLabel

ENDSCAN

SELECT 

*-- print your labels

HTH