Index a table on month(date) 
Author Message
 Index a table on month(date)

Can I have a table in an Access DB indexed on the month of a date e.g.
        index on str(month(date1)) + name + ...
or have I to split the date into different fields and set the index on
TIA for any suggests, pal
Andrea Palazzi

Sun, 21 Nov 1999 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. WeekToDate, month to Date, Last Full Month

2. How to insert data from un-indexed tabel to indexed table

3. How to get table's index in the tables collection

4. Calculate no of days in a month within a specified date range

5. Date FIlter for whole month

6. getting date to + 6 months

7. difference between two dates ,in years,months,and days

8. Date Range - using day and month

9. Date of last sunday of month

10. DATES ISSUE: Number of the current Week of the current Month

11. Count the months between two dates.

12. Months and Date


Powered by phpBB® Forum Software