Could I control user access data bwtween two dates?

[#1]

Hi

I have a table :

F1	date
tom	2008/1/1
john	2008/1/2
jerry	2008/1/3
frank	2008/1/4

Can I use section access to control users access data bwtween two dates?

USER1 can access 2008/1/1~2008/1/3

USER2 can access 2008/1/1~2008/1/4

...

USER3 can access date1~date2

If use section access, do I have to link such table as:

USER1	2008/1/1
USER1	2008/1/2
USER1	2008/1/3
USER2	2008/1/1
USER2	2008/1/2
USER2	2008/1/3
USER2	2008/1/4
USER3	DATE1
USER3	…
USER3	…
…	…
USER3	DATE2

My question is: if userX can access 300days' data, do I need to link a 300rows table? or sth better idea?

Can I set a date range in section access?

[deepakk]

hi ,

Try out the attach application.

User iD : Admin and password :Admin for all data.

UserID : User1 and Password: User1 for restricted data.

I hope this helps.