Search results for query: *

Pivot might well be one of the better options Miracles we do immediately ... imposibilities take a little longer.

yes i did look at the pmt function - and i do understand it - i will see if i can work it out .. thanks for your help Miracles we do immediately ... imposibilities take a little longer.

You can either get it from your templates in Excel, (File, New) or you can download the Loan Amortization Schedule from the Microsoft Template site) It will be a bit tricky to get all the data in here - alternatively i could email it to you ? Thanks for the response Miracles we do immediately...

Try This =dcount(database,field,criteria) database = all the data (everything) field = the Product criteria = the sales figures but if you want as you say only need to see them in the list if they have a sale, check out the help on MS Excel related to database functions - DCOUNT Miracles...

The Excel Loan Amortization Schedule REQUIRES that LOAN PERIOD IN YEARS, need to be whole numbers. How do i get around that if i do not want a whole number, instead i need 3½ years. Miracles we do immediately ... imposibilities take a little longer.

I would like to know if there is anyway that you can set the default settings for Excel (or in the Control Panel, Regional and Language Options) to display negative numbers for all new worksheets as (999,999,999.00) Miracles we do immediately ... imposibilities take a little longer.

Firstly you need Exchange server for the sharing of the calendar to work. If you do have Exchange server, then you start by setting up the Delegate Access Feature. This has to be done on the CEO's Computer To set up the Delegate Access feature, you would click Options on the Tools menu and...

Have you considered putting a border in the footer. Use the Custom Footer box and then Center Section. Use an underscore to draw a line. You need to hold the shift and the underscore in so that it draws a continuous line - 4 rows of it. Your line should appear on every page at the bottom. I...

Never Mind - Worked it out - just for interest, here is the solution =IIf([Result]<[Pass requirement],[Supp Results],&quot; &quot;) Miracles we do immediately ... imposibilities take a little longer.

Hi there, I am trying the following This is in an Access Report In the [Supp Results] field, i am trying to get the [supp result] only if the [Result] is Less than the [Pass Requirement]. how do i do it Miracles we do immediately ... imposibilities take a little longer.

My client has a problem in Microsoft Excel 2000 She says that where the column inidcators are A, B, C, D it is now 1, 2, 3, 4 etc. and the Row indicators are showing A, B, C, D instead of 1, 2, 3, 4 etc. How can we change this back ? Thanks Miracles we do immediately ... imposibilities...

When Creating chart in ACCESS 2000 with SP-3 there is a stuff up with the chart design. You have to do it to understand what it does - it is either over- or undersized for the area - and you cannot resize it, and believe me, I have tried everything to get it right. Designing a chart with...

This is the scenario : 'update temp table 'code snippet... cm.CommandText = &quot;insert into mytable (code, product) values ('&quot; & strCode & &quot;', '&quot; & strProduct & &quot;')&quot; cm.CommandType = adcmdText cm.ActiveConnection = cnn cm.Execute Miracles we do immediately ...

How about inserting a field called MAIL - Entry into that field must be either YES or NO - then when you run the mail merge you run a query on the MAIL Field - all the fields with YES - will receive mail. Miracles we do immediately ... imposibilities take a little longer.

In Access 2000 using VBA I have a string value e.g. 500mg Litchi &quot;A&quot; duplex box (string value uses double quotes) or or 500mg Litchi 'A' duplex box (string value uses single quote) How do I insert that record (which can be either the one or the other - indicated above) into a...

Thanks a Million !!! Miracles we do immediately ... imposibilities take a little longer.

Sorry, i should have told you that I am working in VBA for Access 2000 - I have several lines of code that i want to select and make it a comment. I am aware that If I want to do a comment, I use ' - the single quote. do you think you can help on this one ? Thanks Miracles we do...

Hi there I would like to mark Selected code as comment. Forgot how to do it. Can you help Thanks Miracles we do immediately ... imposibilities take a little longer.

You will have to be more specific, Are you working in Excel or word - Is your data and excel and you want to merge to word or is the data in word and you want to merge in word ??? Miracles we do immediately ... imposibilities take a little longer.

I know you can do it in excel - will have to figure out how to do it in word - Miracles we do immediately ... imposibilities take a little longer.