Search results

My apologies for all the same entries, no idea what happened there. I am including a screenshot of the report. I have included the numbers relating to the months. Regards Terence

Months in chronological order Gentleman I have decided to get of my arse and do something myself, based I hope on your suggestions. I have changed the following: I have added a numberic field to my tblMONTHS. There are two fields now: Number and Month I have enter 1 next to January, 2 next...

Months in chronological order Gentleman I have decided to get of my arse and do something myself, based I hope on your suggestions. I have changed the following: I have added a numberic field to my tblMONTHS. There are two fields now: Number and Month I have enter 1 next to January, 2 next...

Months in chronological order Gentleman I have decided to get of my arse and do something myself, based I hope on your suggestions. I have changed the following: I have added a numberic field to my tblMONTHS. There are two fields now: Number and Month I have enter 1 next to January, 2 next...

Months in chronological order Gentleman I have decided to get of my arse and do something myself, based I hope on your suggestions. I have changed the following: I have added a numberic field to my tblMONTHS. There are two fields now: Number and Month I have enter 1 next to January, 2 next...

Months in chronological order Gentleman I have decided to get of my arse and do something myself, based I hope on your suggestions. I have changed the following: I have added a numberic field to my tblMONTHS. There are two fields now: Number and Month I have enter 1 next to January, 2 next...

Months in chronological order Hello Ken Answer to your question is a resounding - YES!!! Regards Terence

Hello Ken It's with the Report

Months in chronological order Hello Pat Many thanks again for your help, but I feel that I must give up on this one as I am taking up far too much of your time. I tried looking at the combo box rowsource code that you suggest but cannot find a place to insert your suggestion i.e. 1, January...

Months in chronological ordert Gentleman I am very impressed with your responses to my problem. Can't thank you both enough. But I have a dilemma. How can I show months of the year in anything but a text format? I include a screenshot of the culprit in question. The first combo box allows the...

Months in chronological order Hello Wayne It was very kind of you to take the trouble over my problem. I have tried your line of code and am still having problems. I have included two screenshots, one of the query, the other the result of the query in the report. As you can see my months are...

Months in chronological order Hello Pat Sorry about the error. The CMONTH is a text field. I use a combo box to list the months of the year. Included is a screenshot of the combo box in question. Can't thank you enough for taking the trouble to sort me out (no pun intended) Regards Terence...

Hello Pat Many thanks for your help here but I am still having a problem. The field I am trying to sort on is called CMONTH. After allocating a month, date, and type of overtime to a Commander (of an armoured car) I am trying to list all his overtime earned in chronological order in a Report...

Listing dates in chronological order Hello KenHigg and Pat Hartman Many thanks for taking the trouble over my problem. I am using a combo box to display the months: January February March etc. And then highligting the required month, then the day in another combo box, then the the type...

Hello RV and ScotGem Am in Nairobi to see the family at the moment, when I get back to London I will send you the programs Regards Terence

Hello All Does any know how to index months of the year in chronological order, such as Jan Feb Mar Etc. Regards Terence Nairobi

Hello RV and ScotGem Spent most of the day yesterday looking up my old programs and found such a program I did two years ago. Here I created a count query of all the relevant fields and used that in my Report. I then summarised the field that had counted the numbers of hours and multiplied that...

Hello RV The client wants and individual report on each guard so that the guard can see how many overtime hours he has worked. This program will be used in Kenya. Hello Scotgem Yes I am going through that route and will let you know how I get on. Many thanks to you both for taking the trouble...

Hello All I am writing a program for a client who runs a security business. I have reports for each guard for each month, which normally list 28 to 32 activities for every day of a month. I now need to produce a report for all guards (48) that sums up their number of hours worked and their...

Hello Aqif I have included a jpeg attachment of the form that includes your solution. This is from a previous attempt and doesn't include all the products. Regards Terence