Please Help!!!!!!!
I have created a database which works on information for a month, then at the end of the month it is transferred to a history table.
What I like to happen in the header of the form is to have a text box which will covert the first date which is entered into the table for example (02/02/2001 09:55:00) into a month
So for example the text box in the will say = "Total Number of Faults For The Month of " & [ Month]
The only problem I have is that I cannot change the Date / Time format because it is working out downtime between two dates & times
How do I convert it and where do I put the conversion?????
Thanks
HL
I have created a database which works on information for a month, then at the end of the month it is transferred to a history table.
What I like to happen in the header of the form is to have a text box which will covert the first date which is entered into the table for example (02/02/2001 09:55:00) into a month
So for example the text box in the will say = "Total Number of Faults For The Month of " & [ Month]
The only problem I have is that I cannot change the Date / Time format because it is working out downtime between two dates & times
How do I convert it and where do I put the conversion?????
Thanks
HL