Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


peptoulcer last won the day on May 7 2011

peptoulcer had the most liked content!

Community Reputation

1 Neutral

About peptoulcer

  • Rank

Profile Information

  • Gender
    Not Telling
  1. Hey LaRetta, this is very good to know because I don't want to look up characters all the time. I used to use character map years ago but I forgot about it. Hey Raybaudi, this works also and I will probably write down this because the arrows come in handy many times. I appreciate the responses, guys.
  2. I should mention that I found information about it by searching for decimal code 9660. In fact, I've found enough to keep me studying this stuff for a thousand years. I am using 9660 and 9658 both in a chart. I have the calculation string working. But now I need to add the legend which is: Document Title (and then the 9660 character here) Document Sub-title (and then the 9658 character here) There is information here but when I type just those key strokes it says, nothing happens. Something is inserted into the text box because it doesn't disappear like it does if the text box
  3. Never mind. This works. I swear I tried that and it wouldn't work but now it does. TextSize(TextFont(Char(9658);"Arial");8) but I would still like to know how to figure out what key stroke is typed.
  4. Hi people, I need to take a string which contains: TextSize(TextFont("6";"Webdings");8) and change it to use arial char(9658) which both produces the arrow. The computers can't (won't) install webdings (management decision) so I need to change it. This is within a string which sets the arrows within a calculated line so I need to include the font and font size because the rest of the string is calibri and the sixes are mixed. I tried to find out what char(9658) is in key stroke but I just get the arrow lol. I would really appreciate help translating it from webdings to ar
  5. Thank you very much, Stephen. I did not expect such a fast response. I have changed it back to my comfort zone.
  6. Well, I found another issue. GetNth not only needs to be wrapped if it is date or number, it also needs to be wrapped if it is text. I should have thought of that and checked it but I thought text was text and wouldn't break anything. On the existing file, Invoice Payments report, setting the check number always grabbed the first related payment's check number (same break as the others would do) unless I changed it from this: List($$text2 ; Case(IsEmpty(GetNthRecord(payments::check#;$kount) ) ; " " ; GetNthRecord(payments::check#;$kount))) to this: List($$text2 ; Case(Is
  7. This is a message to Comment: I tried to send you a private message but it said you could not receive private messages so I will post it here. Hello Comment, it is Andy, the one you spoke with on the GetNth issue. I am not sure if it is okay to contact you but I want you to know that I am sorry for our interaction. And I am mostly sorry for removing the 'best regards' from my message to you. I was offended by your last message to me when I was trying so hard to explain things. My posts kept getting longer and longer because it was clear that I was not getting through. It was
  8. Hello Site Administrators, My title went from novice to Advanced Member and I have something like 32 posts. I did not change that title and actually do not see where it could be changed. After I couldn't find where to change it, I asked Bruce, a fellow member, and he said, "Regarding the "Advanced Member" thing I don't know how that gets started. I was labeled Pooh-bah for a while; and I did not give that label to myself. Some admin with a sense of humor maybe. But you can go to your profile and change it I believe." I realize that the title can change by the number of posts. Is t
  9. Many times I am asked to provide information such as this "and, by the way, since we are looking at a staff's schedule can you display the staff's total sales so we can know if they are producing sufficient revenue?" It simply provides them immediate information so they don't have to look elsewhere and the fact that the information is NOT really relevant nor related but available to pull through to the report is exactly the point of it. If the information WERE relevant then it would be a relationship connected to Schedules in the primary TOG. I thought I clearly covered the need fo
  10. Thank you, Bruce. But I'm not sure I understand what is wrong with it. These sales amounts were pulled from the relationship of Staff::staffid=Sales::staffid and it uses a summary field in Sales. That is why it is powerful to grab the information from the primary relationships. Staff 1 has a summary of 115 and staff 2 has summary of 395 and that is what the detail sales show as well as the virtual table (Schedules). I realize that it repeats the sales values but it must because it is flatline (just as it repeats the staff name). I realize too that I could hide all but first line and
  11. Here is a sample file which walks through the process and explains very clearly how to create left outer joins . This is not to prove a point; this is not to begin an argument; this is not to offend, demean, belittle, or make fun of anyone here. It is for those who wish to understand the technique. Left outer join or union using arrays
  12. I do apologize for this. But I do not apologize for anything else I said. I suppose people will now get in a long line to take turns flogging me for having the nerve to disagree with the most popular person on this forum. :gang:
  13. And I would say the same from many things said throughout this thread. Comment said "It's all right to redefine the problem being discussed - but I would have appreciated being told about it." I told you several times. And I did not redefine the problem - the problem was dates. It was you two who went after the approach I was using - stop using GetNth, stop peeking. I kept saying I needed to create left outer. You are not only beating a dead horse - you are group beating one. This horse is done. I removed my 'best regards' because I don't feel them any more.
  14. Left outer join (from Wikipedia): The result of a left outer join (or simply left join) for table A and B always contains all records of the "left" table A, even if the join-condition does not find any matching record in the "right" table B. Example: You want a report based upon the Payments (child right) table but want to include Invoices (parent left) without payments or you want a report of Sales (child right) but you want all Sales Persons (parent left) listed even if they have no sales. This files shows dynamic way of using one temp table to merge table data and generically
  15. I have reviewed this thread many times. You were told. You wouldn't listen. Well you are obviously offended and I didn't mean to. By dog with stick I meant you kept suggesting different approach. But I'm not going to continue either so don't worry. It really wasn't you but that other guy. Regardless, you are not being friendly so I'll just leave. However, I am going to post my file for others who have left outer join issues. I wouldn't want them to have to deal with the tone on this thread to get the information.
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.