Microsoft Works - Works guest list template |
- Works guest list template
- Works Calendar - Colour Change
- boarder art
- Convert Works Database into Excel
- Consultation about a formula for works...
- using Works Database
- Importing legacy Works Calendar with Outlook 2007?
- Where is Works Calendar file saved to?
- Finding the correct formula for this explanation
- Excell
- Works 9 Calendar import
| Posted: 04 Oct 2008 10:30 AM PDT Hattieruth, You are quite welcomed! -- Add MS to your News Reader: news://msnews.microsoft.com Rich/rerat (RRR News) <message rule> <<Previous Text Snipped to Save Bandwidth When Appropriate>> "Hattieruth" <microsoft.com> wrote in message news:com... Thanks for all your help. I really appreciate it. |
| Works Calendar - Colour Change Posted: 03 Oct 2008 12:54 PM PDT My calendar is purple, (works 9) and I would like to have other options also. If anyone out there has any solutions please reply. "st" wrote: |
| Posted: 03 Oct 2008 12:51 AM PDT craig wrote: A quick Google image search ( http://images.google.co.uk/images?q=boarder%20art* ) returns lots of artwork featuring boarders of, er, variable quality. |
| Convert Works Database into Excel Posted: 30 Sep 2008 05:29 PM PDT It should. As I recall, Works Suite 200 is Works version 5. If the install gives you an option, just install the Works and not the Suite add-ons. You probably already have a newer version of MS Word. -- Mike - http://pages.prodigy.net/michael_santovec/techhelp.htm "frankiegospel" <microsoft.com> wrote in message news:com... |
| Consultation about a formula for works... Posted: 29 Sep 2008 03:55 PM PDT From Works help: Click the data entry values such as text or numbers in cells you want to repeat. With the mouse pointer, point to the lower-right corner of the cell (the intersection of a row and column that can contain text or numbers that contains the entry). When the pointer looks like a plus, drag down the rows to select more cells. When you release the mouse button, Works repeats the text in the selected cells. Tip You can also repeat text by clicking a data entry, and then dragging down the rows where you want the data entry to appear. On the Edit menu, click Fill Down. -- Ronald Sommer "MR FORMULAS" <microsoft.com> wrote in message news:com... |
| Posted: 27 Sep 2008 07:31 PM PDT Hi Raymond, Works database report limits the use of functions as you encountered. The formula has to be entered into List view - a field that will hold the 'markings' i.e. asterisk etc. This then becomes the value displayed in the report as indicator. You may wish to use a new record line to print the asterisk etc. above the actual score achieved per hole. HTH, -- Kevin James "Raymond" <microsoft.com> wrote in message news:com... | | | "Raymond" wrote: | | Hi Kevin, | | I tried your formula and Works said that the function "IF" is an invalid | function in a Works report. The Works functions (AVG, COUNT, MAX, MIN, STD, | SUM, and VAR) will not work either. I was hoping a formula something like, | where "HFHDC" record value is equal to "hfhc" record value to write the | record | value of "Hole10", ect. Maybe this is not possible in the Works Database. | Any | other ideals would be appreciated. | | Thanks for all your help, | | Raymond | > | > "Kevin James" wrote: | > | > > Hi Raymond, | > > | > > That page explains it all. | > > | > > You wish to find a hfhc value that matches the player's HFHDC value and then | > > identify the hole numbers for which the player receives an allowance. This is to | > > be signified in the report with the display of a plus, an asterisk, an asterisk and | > > a plus or two asterisks ( 0.5, 1, 1.5, 2 ). | > > | > > One way of treating this is to say e.g. that Hole 10 is 'used' when HFHDC is | > > greater than 6.5. Hole 10 has 5 different values that it can hold, all based on the | > > HFHDC value. | > > | > > So perhaps, a formula that has the following 'pattern' can be used e.g for Hole 10 | > > | > > =IF('HFHDC< 6.5,"",IF('HFHDC=6.5,"+",IF('HFHDC<15.5,"*",IF('HF HDC=15.5,"*+","**")))) | > > | > > HTH, | > > -- | > > Kevin James | > > | > > | > > | > > | > > "Raymond" <microsoft.com> wrote in message | > > news:com... | > > | | > > | | > > | "Kevin James" wrote: | > > | | > > | > Hi Raymond, | > > | > | > > | > It's good news to hear that you are progressing well with your database. | > > | > | > > | > To retrieve the value for field 'Hole11 when the 'HFHDC and 'hfhc" fields | > > | > are equal in value you may set up new fields, in list view, with the formula: | > > | > | > > | > =IF('HFHDC ='hfhc,'Hole11,'"othervalue?") | > > | > | > > | > where "othervalue" is whatever other value you wish to use when HFHDC | > > | > and hfhc are not equal. | > > | > | > > | > I don't understand ( golf and ) how this will operate to provide the solution | > > | > to your statement below nor why hole 11 is used. | > > | > | > > | > "I will then need to write it for each hole, 10 thru 18, which will dot the | > > | > score card on the holes of which each player would receive a stroke, | > > | > based on his handicap." | > > | > | > > | > If you intend to compare the two handicaps and the hole 'par' and mark the | > > | > hole (report) with an asterisk if they are equal then perhaps you are looking | > > | > for something close to: | > > | > | > > | > =IF('HFHDC ='hfhc,'*","") which returns an asterisk if equal or else 'nothing' | > > | > | > > | > HTH, | > > | > -- | > > | > Kevin James | > > | > | > > | > | > > | Thanks Kevin, | > > | If you have time please go to http://www.jhga.org and click on the "Misc" | > > | link in the navigation bar. I have a copy of the database and report which | > > | might help me in explaining what I'm trying to accomplish. | > > | Raymond | > > | > | > > | > "Raymond" <microsoft.com> wrote in message | > > | > news:com... | > > | > | Hi Kevin, | > > | > | In reference to my post on 9/15 for designing a golf score card with the | > > | > | Works Database. I have the design completed as I want in a report. I still | > > | > | need to write a formula that will use the record value of my "HFHDC" field | > > | > | and match the record value of the "hfhc" field and then get the record value | > > | > | of my "Hole11" field. If a formula can be used to do this, I would appreciate | > > | > | if you will write an example for me. I will then need to write it for each | > > | > | hole, 10 thru 18, which will dot the score card on the holes of which each | > > | > | player would receive a stroke, based on his handicap. I have my database list | > > | > | with the HFHDC field to provide the players' handicap, the hfhc field to | > > | > | provide the course handicap rating for each hole, and each Hole fields (10 | > > | > | thru 18) to provide asterisks that dots the score card for the stroke holes. | > > | > | | > > | > | Thanks, | > > | > | Raymond | > > | > | > > | > | > > | > | > > | > | > > | > > | > > | > > |
| Importing legacy Works Calendar with Outlook 2007? Posted: 26 Sep 2008 09:20 AM PDT You are welcome and thanks for posting back. -- Mike - http://pages.prodigy.net/michael_santovec/techhelp.htm "Xandrakkan" <microsoft.com> wrote in message news:com... |
| Where is Works Calendar file saved to? Posted: 25 Sep 2008 10:08 PM PDT mswkscal.wcd is where Works calendar data is stored. Works calendar reads the gibberish you see in the mswkscal.wcd file. If you are in doubt whether the calendar is displaying what is in the mswkscal.wcd file, tempory move mswkscal.wcd out of it's existing folder, open calendar, it should display an error message. If it doesn't, then the file you moved is not the one Works calendar is reading. Hope this helps, Ken "Bacchus41" <microsoft.com> wrote in message news:com... |I have looked at the files named in the support article but they are exactly | the same size with data entered into the calendar as they were empty. Is | there somewhere else to look or is there a way to read the gibberish in the | files to see if something is really stored there? I lost everything once | already when SP3 ruined the files in my computer and I had to start over with | a clean install. I would really like to be able to back these files up. | | "Kevin James" wrote: | | > Hi Dave, | > | > These are the Calendar files installed by Works Calendar. | > | > http://support.microsoft.com/?kbid=909529 | > | > HTH, | > -- | > Kevin James | > | > | > | > | > | > | > | > | > "Dave" <microsoft.com> wrote in message | > news:com... | > |I have searched high and low on my computers to find where Calendar's data is | > | stored, but can't find it. I've selected hidden and system files in the | > | searchl. I have looked for files with today's date. I have searched | > | manually. But I can't find it. | > | | > | I ask this because when I reformatted my drive last year, I got my data | > | saved -- except for Calendar data because it was stored in an odd place. i | > | would like to save the file to another place so that that doesn't happen | > | again. But, I just can't find it. | > | | > | Thanks for any insight, | > | Dave | > | > | > |
| Finding the correct formula for this explanation Posted: 21 Sep 2008 02:34 PM PDT MR FORMULAS, For a single item X quantity use the following: A1= Item Name B2= Quantity C2= Per Unit Price D2= Fee Charge E2= The following formula, then drag the fomula down the length of the column. =IF($B2="","",IF(($B2*$C2*$D2)<1.01,1,IF(($B2*$C2* $D2)>60.01,60,($B2*$C2*$D2)))) Or you can just add the Fee Charge Percentage in the formula, like this, in your fee column. =IF($B2="","",IF(($B2*$C2*0.01)<1.01,1,IF(($B2*$C2 *0.01)>60.01,60,($B2*$C2*0.01)))) If it is multiple items to the same receipient, then you will need to get the total of the order, before applying the following. If you designate E10 as the cell that your total in E11 place the following formula: =IF(($E10*0.01)>60.01,60,IF(($E10*0.01)<1.01,1,($E 10*0.01))) Or if you place the percentage for the fee in a cell, use the cell address to multiply with the total. -- Add MS to your News Reader: news://msnews.microsoft.com Rich/rerat (RRR News) <message rule> <<Previous Text Snipped to Save Bandwidth When Appropriate>> "MR FORMULAS" <MR microsoft.com> wrote in message news:com... I've been trying to create a spread sheet, that calculates all my fees, profits, starting from distributors to the cost of shipping to Mexico, which I have already, and has beed designed in works the website similar to Ebay, infact its the same company, I'm new at works, and I got stuck at this formula that I can't get it to work right because I believe Im not very savvy about works and formulas. What I am trying to do is this... This company charges you (1%) of price of item being sold, but minimum charge it's ($1 dlls) max $60 dlls, meaning that If I sell 7 CARS @ $1000 each one, then 1000 X 1% X number of cars (7) = $70, but the max they can charge you is $60. So $70 will be decrased to $60.00, same as well if the charge it's less than $1 dollar how can I make it to display $1 dollar?. How can I express this on WORKS?" |
| Posted: 21 Sep 2008 06:19 AM PDT I CAN NOT ACCESS MICROSOFT 2007 wrote: Please rephrase your question in the form of a question, rather than a post which is empty save for the quoting of someone else's post. .... What is "Microsoft 2007"? Is it related to Microsoft Windows Vista, which stumbled into the world in 2007? |
| Posted: 19 Sep 2008 03:01 PM PDT Jeffrey Needle wrote: Well, I've tried .ics and .vcs, and neither one will work. I looked on the web, and others seem to have had similar problems. But no fix seems to be forthcoming. I'm searching the Microsoft site to see if something comes up. If anyone has other ideas, I'm all ears. Thanks. |
| You are subscribed to email updates from TextNData Forums - Microsoft Works To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
I have lost all the toolbar names and cannot open a new file or open files within office. I can't seem t find tools/options to reset the defaults and this copy of offie was installed by dell onto the pc at purchase, so I don't really know how to re-install if I don't have hard copies. I include a screen dump of the problem,