Search results for query: *

bnpmike, i am sorry, i guess either i am not understanding what you are telling me or i did not get my question across. so let me try again. if i have both dept A and B codes in the same table, but i don't want to see dept A codes - if they have the identical start times as dept B. i do want...

bnpmike, your example is exactly what i was talking about, but what if they are on the same table? how do i differentiate between a code that is identical and therefore not to be repeated like in the last 2 of your example, as opposed to the top 2, where i also want the dept A code along with...

ok, got it, thanks guys. the only reason i was asking was because i will have to download this text file perodically and it has minutes which i will have to convert to hours, but i was hoping that in the import process, there was a formula i could create which will do the coversion for me, then...

thanks bnpmike, i knew i could do it in a query, but i didn't know if i could do it in the table, i assume not?

duane, thank you for answering, i guess i didn't ask the question right - but where do i divide by 60 in the database? in design? or is that even possible?

i imported a text file into access that has minutes in a column. i would like to have the minutes in the column be converted to hours. is there a way to do this in the data design view? i also notice that the explanations in these forums are aimed at programmers (and there appear to be a lot...