Help with SunEase!!

[dwnlschmk]

I am trying to pull up a report of all tanners that have been in the last 12 months but cant figure it out...does anyone know how to do it?

[DB Hottie]

I am not at the salon. I know you can do it. I'll get you the sequence tomorrow.
Are you on 2K?

[DB Hottie]

Reports;
Client Reports;
Open;
Select the type of report (How you would like it printed- by address, client ID, etc.); Load;
CQ Last Date Tanned.QRY;
Custom;
Look at the formula in the box and modify to your needs--->This is what I typed in:

Client.Last_In >= MakeDate( 2007, 11, 1 ) .and. Client.Last_In <= MakeDate( 2008, 11, 1 )

Select your sort order;
View


Hope this helps dwnlschmk.