Loop for a action

[Rashid]

BookingDate

Date/Time Field

D1	D2	D3	...
			...	D31

Here I need when user select a date in booking date field the corresponding field in below text fields change to Booked.these fields are in one table.i have a query with a field Day=date part("d"[booking date]).By which I want to perform the target.so how can I do this.

 

[Gasman]

Table is not normalized. You will constantly jump through hoops with that structure.

 

[jdraw]

Rashid,
Tell us more of "what you are trying to achieve" in simple English. As Gasman said, your table structure is not set up for relational database and will cause you a lot of grief. Get the structure correct is first priority.

 

[Rashid]

Actually I need a calendar like form in which I can show event bookings

 

[Gasman]

Actually I need a calendar like form in which I can show event bookings

So google Peter Hibbs Calendar as an example.

They use a normalized DB structure.