Create Time Slots!!!!

[mubi_masti]

Can any one help me in developing a column in query to create different time slots for each record like following:

IDs Time
new080592001 11:00 am
new080592002 11:00 am
new080592003 12:00 am
new080592004 12:00 am
new080592005 02:00 am
new080592006 02:00 pm

secondly how i can add unique values by developing append query .
For example i have developed a query which takes values from text boxes but those values are not unique in a table. The query append all values instead of providing unique values.
10-Oct-11 Ali Fayyaz
10-Oct-11 Ali Fayyaz
10-Oct-11 Ali Fayyaz

I want the query append only one record only instead of three records.

 

[CBrighton]

For the second part try enabling the "unique values" property of the query.

For the first, you could always just have a field displaying the date field in a custom format and replace the minutes and seconds with 0's. Of course this would mean they are always rounded down to the earlier hour whether it's 1 second or 59 minutes and 59 seconds past the hour.

 

[mubi_masti]

Sorry
both options which you have provided are not working.

time slot suggesion is not understandable as well.