Search results

I have a report that counts the number of telephone calls per month and groups them depending on the type of call ie claims call or customer service call. I also want it to add them together and show a total at the bottom? Cheers Mike

Hiya Hay.. Downloaded the first one...bit complex for me!!:o I tried the locked demo on there and i can't even get that to work. I'll try that other link. Mike:)

Bummer!! Thanks Pat Mike

Is it possible to export a report to, for example a word or powerpoint file? The report displays charts aswell as text. cheers

Cheers Mile....you've bailed me out again! Mike

Yes ok, but is there a way round this?

=[TxtActualScore]/[TxtMaxScore]*100............ is what i am using to give me a percentage. For example: (Actual Score) 8 / (Max Score) 9 x 100 = 88.9 % There is the possibility that in some cases the Actual Score and Max Score are not applicable. I thought that if i enter '0' in Max Score...

by the way i did query on the real date then reformatted that date as follows.. ForMonth: Format([Calldate],"mmm yy") And then sorted on that and it seemed to work. Mike

Sorted, don't really know how, but it's sorted... Thanks for your help;) Mike

I get what your saying but i still need the date to show in the report... I'll have a go Cheers

I have a query that throws out results by month. When i open the query i get the correct results however, the results are not in date order...for example: Instead of Jul-03, Aug-03, Sep-03 etc.... It's showing date in alphabetical order, for example: Aug-03, Jul-03, Sep-03! I have also...

Thanks Nouba... Worked Perfect! Mike

I want to be able to Dbl Click an employee in a list box that will then open that employees record on another form... Does any know the On Dbl Click code i need to open the other form on that employees record? I have a command button that will do this when the employee is selected from the...

Ghudson... Great sample, thanks for that.;) Mike

I have created a transparent label on a form footer that will appear when the user mousemoves over a command button... Example User moves mouse over command button. Form footer text appears "Go to Employee Details Screen" When user mousemoves off command button the footer text dissapears...

Go to properties of Text Box(s) > Format Tab > Text Align > Left Mike

SORRY :D :p Thanks again. Mike

Haley.. Thanks, got it working...i used your command button example via wizard. How easy was that. Thanks again Mike :)

Hay Thanks for your reply..... I had a look at inserting a command button on 'forma' to navigate to a particular record on 'formb' but i can't see where it gives the option to link by ID (I wish it did)! Any Ideas?

I have a search screen (frmsearch) which is linked to my main table (tblmain). On the search screen there is a list box which lists all employees. I can scroll up and down the list box or i can use a search facility that i have created which will narrow the list down. I also have a form...