# Rabbitt

Members

7

0 Neutral

• Rank
novice
1. ## Viewing quicktime files via web view

I am trying to establish if Quicktime files (movie files) can be viewed via the web view of my database? My simple test of adding a movie file to a container field then viewing that via a web browser on another computer, did not work. Can anyone tell me if this is possible?
2. ## Amount of days/months expired

I have got a calculation written to calculate if a date has expired but I'm not sure how to calculate the amount of time that has expired?? My calc is If ( renewal date ≤ Get ( CurrentDate ) ; "Expired" ; "" ) But how do I work out (in this instance) how many months have expired?? Thanks in advance

Thank you!
4. ## the middle character of a long number or text string

Thanks for your post but it's not giving me the result I need. After testing your caculation it returns a 6 for the serial number UV432007QHU, but in this instance I would need the 0 in the middle? I think your calculation just counts the middle character, but I need to know exactly what it is, eg, 0 in the serial number above.
5. ## Extracting text from a string

Thanks for this, it has not only helped me with my query but given me more of an insight into the Let function
6. ## the middle character of a long number or text string

Can any body help me with a calculation to extract the middle character/s of a long number or a text string, eg, the 5th character in the number 12345678 or the 4th letter in stephen In both of the examples I will not know the contents of the number or text string, they will be different every time. Steve
7. ## Extracting text from a string

I am trying to work out how to extract characters from a text string and paste them into separate fields from a calculation. The field data I am working with is 00:0D:93:6C:0C:7C which is actually a MAC, I want to extract each section into it's own field eg, 00 into field 1 0D into field 2 93 into field 3 6C into field 4 I can figure out the pasting bit myself, but what I'm struggling with is how to extract each part of the text string using a calculation? Any help is appreciated. Steve
×
×
• Create New...