Recent content by cl159037

hey guys... my case is exactly what Brianwarnock as stated. I solemnly apologize for the language i have used. Now i would like to explain my situation as below. i have a query as shown below. SrNo startTime endTime 1 31/01/2015 01:00...

Dear CJ_London I tried your sql code but couldn't achieve the desired results. In order to have a better view of my problem i have attached an excel file that gives me the desired result. Please check the formula in the excel file and try to achieve the same using access file. tnks in advance.

sorry all. due to my hectic work commitment i didnt have time to go through your suggestion. I will try your suggestion/ codes the moment i m free. plz hold down a while...

dear CJ_london... tnks 4 ur reply.... You have meant it correctly itz the missing records. Before reaching any conclusion please note that my order sequence is based upon start_time. I would appreciate if i can have an early solution to my problem.

i want to resolve difference in time in query when the autonumbers are not in order. i have attached the word file with details. please go thru the attached word file and give me the solution.

i tried doing this, but the problem isn't solved.

I tried typing in with caps lock off it only displays the data in the field in the caps lock format but the data entered in the main database table is still small caps.

m using office 2007: when i type the data in a access form, i want all the words that i type to be saved in a capitalized format irrespective of whether my caps lock is on or no.

it is not conected to any table for field, but rather i want to create a lable or text field in report to do it.

as i hv mentioned when i type my name in the footer secton it goes at the lower end of the page which i dont want. i want my name just at the end of the data and not at the end of the page.

Access 2007 : At the end of report (tabular) i want to add my name in order to sign. i tried doing it in details block but my name repeats again and again. even the header footer block is not viable option because my name goes at the end of the page. plz help

I m using access 2007, can anyone help me to transfer tabular access report to excel / spreadsheet file.

i m using access 2007. i want to know how to export my report to excel file since my excel file icon is disabled in the access tootbar.