Recent content by bpk

I tried both your suggestions in a query, doesnt give any result, am i doing something stupid ?

Modest, i hcatn figure out the IIF statement as it needs True and False values, in yours you have mentioned in case its 'True' and " & Hour(Current_Time)" in case its false. The & is not recognised. thanks for helping me out, i have already asked too much, but need to get this thesis done by end...

Date and time in one Colum Thanks Modest, for the moment i have used your approach but for later needs i will have to use Doc's approach as i will possibly trying atleast a few more time frame. I have one more question, how do i bring the Date and Time together in One Field ( At the moment...

Can someone help me to put the date and time field as one so that it shows as DD/MM/YY HH:NN in one field. I have the date and Time in two fields currently. thanks a lot

Just astounded, impressive style of thinking Doc !! Will keep you posted after i work it out ! Many thanks

Million thanks for the speedy reply ! Will keep you posted with the outcome. Appreciate it very much !

Can someone help me out with this complicated logi ( atleast for myself) I have a set of data which has records of all the trades of a particular contract. I have so far cleaned it and i would like to study the way the pricing varies, need it for my school thesis. For every CONTRACT MONTH, i...