Search results for query: *

thanks for the tip, hope i didn't offend too many users

i am importing excel time data into access. i want to display minutes, seconds and hundredths in excel i use a mm:ss.00 format and this returns the correct value but access won't allow this format when i use the ms format it actually returns a different value. a 1:07.893 time in excel returns...

i got that wrong, below is correct when i use the ms format it actually returns a different value. a 1:07.893 time in excel returns 1:07.89 when i use mm:ss.00 and this gives me the correct value. when i use nn:.ss.ms it returns 1:08.18 for some reason. the format that works for me in excel...

when i use the ms format it actually returns a different value. a 1:07.893 time in excel returns 1:07.89 when i use nn:ss.00 and this gives me the coreect value. when i use nn:.ss.ms it returns 1:08.18 for some reason. the format that works for me in excel dosn't play ball in access any ideas

i am importing excel data which i want to display as minutes/seconds/hundredths, currently when i import the times they read as a time of day. is there a hundredths format code

tyre_picker is the form, total mileage is a formula running as the control source in a text box which is the sum of 8 field entries. total mileage is not a field. i build the query using expression builder and select the "total mileage" from the open forms box so i don't actually type anything...

i don't know how to send you the query as i'm using the query builder not vba. i have sorted the parameter request by having the relevant form open. when i run the query on the form it does not filter the data, the query works fine when i specify to filter data appearing in the form that is...

i am trying to filter form results, some of which are table entries and some are calculations made in the form, when i build a query to act as a filter i cannot get it to work, it asks for parameters which i do not want to give. should i be trying to do this differently

hi phv i have tried to use the information you sent but havn't made it work when i try to select multiple fields in the expression builder and separate them by coma's the function fails if i knew how to do do the above i would be fine to be honest i am not very good with vba and couldn't...

hi i am trying to get the minimum value from 7 fields of 1 record in form view and struggling to get the expression right can you help