MACRO
 

Can an Access MACRO be used in an Excel spreadsheet?

I am trying to do a custom mm/dd/yyyy h:mm field minus another custom field
(same) to get how many days, hours and minutes have passed. Or even to just
convert the results to total hours (to the nearest hour) that have passed. I
am not as savvy in Excel as I have been in Access. When I import my excel
spread sheet into Access the field goes to TEXT and I can't get it back to
the original format without loosing the data. Would this be a better
question for the Access folks? I am loosing time and need this report done
soon. Thanks for any guidance you can give me.
--
Thanks!
Lonnie Jo

MACRO
 

I'm assuming that you have a field in Access that is TEXT but you want it to
be a value.
The easiest way to fix this is to create a query that has all your current
fields in it.
Create a calculated field using the BUILD option.
In the Expression Builder put a formula something like...
Time_Passed: Val([MyTextField])
where 'TIme_Passed' is the name of the field and 'MyTextField' is the field
in Access that is TEXT but you want to be a value.
--
Hope this helps.
If this post was helpfull, please remember to click on the ''''YES''''
button at the bottom of the screen.
Thanks,
Gary Brown


"LonnieJo" wrote:

Can an Access MACRO be used in an Excel spreadsheet?

I am trying to do a custom mm/dd/yyyy h:mm field minus another custom field
(same) to get how many days, hours and minutes have passed. Or even to just
convert the results to total hours (to the nearest hour) that have passed. I
am not as savvy in Excel as I have been in Access. When I import my excel
spread sheet into Access the field goes to TEXT and I can't get it back to
the original format without loosing the data. Would this be a better
question for the Access folks? I am loosing time and need this report done
soon. Thanks for any guidance you can give me.
--
Thanks!
Lonnie Jo

MACRO
 

Thanks Gary. I'll try this!!!
Thanks again.
--
Thanks!
Lonnie Jo


"Gary Brown" wrote:


I'm assuming that you have a field in Access that is TEXT but you want it to
be a value.
The easiest way to fix this is to create a query that has all your current
fields in it.
Create a calculated field using the BUILD option.
In the Expression Builder put a formula something like...
Time_Passed: Val([MyTextField])
where 'TIme_Passed' is the name of the field and 'MyTextField' is the field
in Access that is TEXT but you want to be a value.
--
Hope this helps.
If this post was helpfull, please remember to click on the ''''YES''''
button at the bottom of the screen.
Thanks,
Gary Brown


"LonnieJo" wrote:

Can an Access MACRO be used in an Excel spreadsheet?

I am trying to do a custom mm/dd/yyyy h:mm field minus another custom field
(same) to get how many days, hours and minutes have passed. Or even to just
convert the results to total hours (to the nearest hour) that have passed. I
am not as savvy in Excel as I have been in Access. When I import my excel
spread sheet into Access the field goes to TEXT and I can't get it back to
the original format without loosing the data. Would this be a better
question for the Access folks? I am loosing time and need this report done
soon. Thanks for any guidance you can give me.
--
Thanks!
Lonnie Jo