baldrex
Last Activity: Nov 10 '07, 05:00 PM
Joined: Jun 14 '07
Location:
-
Thank you Linq, this works great! -
awesome!!!
Thank you very much for all the help!
You guys are great!Leave a comment:
-
Ahh yes I agree with both of you in regards to changing the data type in the table, however, part of the problem is that I am working with a proprietary program and the DB I use is a read only copy of a live DB.
so I have to convert it in the query; either a straight query or an append query
I even resorted to trying to modify a built in function:
TOD: TimeSerial ((Hour(Left([duration],2), (Mid([duration],3,2),...Leave a comment:
-
need to convert text to time only
hmm...
I have something similar to this but in my case this will not work. I have a text field storing the value in mins in this format 000100 representing 1 min.
I need to break this into a time reference 00:01:00 so that I can use it to calculate total time spent.
I have tried several different date/time functions but they all add the date, which I do not need.
question is: is there a... -
hmm...
I have something similar to this but in my case this will not work. I have a text field storing the value in mins in this format 000100 representing 1 min.
I need to break this into a time reference 00:01:00 so that I can use it to calculate total time spent.
I have tried several different date/time functions but they all add the date, which I do not need.
question is: is there a...Leave a comment:
-
auto save report printed to PDF from code in VB?
hello again,
I have already gotten to the pdf file, however it hangs at the save as screen. What I am looking for is a snipet of code that will allow me to print to the pdf and auto save it to file with the default name and either not actually open Adobe or to have it close adobe after it auto saves the file
a point in the right direction would be of great help!!
basically looking for a code snipet... -
Imnew,
hmmm, you mean I have to create a table with every sec of every min of every hour and assign a shift to that second, min, hr ?
i was hoping for something like this - column in my table has 093025 and when I run my report I would like the number to be replaced with Day Shift and not the number - but i want to be able to look at the query and still see the actual number - i just want it to be replaced on the report...Leave a comment:
-
find shift value based on time for report
I am running a report based on a table where the time has been entered in this format HHMMSS and what I want to do is have access look at the time then instead of placing the time on the report I would like it to replace the time with a string name i.e. graveyard, day shift etc. is there a way to have it compare and then replace with the appropriate string ?
No activity results to display
Leave a comment: