Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: rbvcbr
  • Content: Threads
  • Order by date
  1. rbvcbr

    Lowest Date

    I have date field, I want to show on the report, start date (lowest date) and end date(latest date). Need help with formula please. Something like, 9/1/09 - 9/18/09. Thanks,
  2. rbvcbr

    Total Vs Move

    I put the following formula, calculation works. when highlighted this field to "Sum (total)", it show is "Move" instead "instert summary". Any tips please to "insert summary" (want to total this field). Thanks, if {JCT_CURRENT__TRANSACTION.Accounting_Date} =...
  3. rbvcbr

    Show value

    I have the following formula, if there is no amount I want show $100 (meaning now blank row). But the following formula is not showing any value. Can somebody please fix the formula. Thank you, if {CURRENT__TRANSACTION.Accounting_Date} < 8/1/2009 then if...
  4. rbvcbr

    Address Formula

    I am creating labels/form letters with the the following data. If I do not have "Address 2" I want supress that row and move up the "city" up one row to replace "Address 2". Can I get some help please. Thank you. Name Address 1 Address 2 City State, Zip.
  5. rbvcbr

    Latest Date Formula

    I have the following dates and amounts fields. I want to write a formula to pick the latest date (most recent). Can some body help me please. Thank you, 04/09/2009 - $12,000- 06/18/2009 - $9,000- 04/17/2009 - $16,000- 07/15/2009 - $1,000- 05/11/2009 - $8,000-
  6. rbvcbr

    Crystal Formulas

    I am pulling data from timberline, transaction table. This table has two fields acct_date and amounts. If I put from and to acct_dates (5/1/09 - 5/31/09) it gives me that criteria amounts (Column1). This is good. Now - Besides this column1 I want to show amount in another column (Column2) "from...
  7. rbvcbr

    ASP / MS Access

    I have about 20 fields in a table, I want display all these 20 fields in two rows, first row will be 10 fields, and second row will be 10 rows. How can I break like this. Please advise with code or some links. Using ASP /MS Access 2003 / XP Thank you.
  8. rbvcbr

    Crystal formulas v10 and v8.5

    I created a crosstab report in v10 with few formulas and I can see/use all formulas. I created the same crosstab report with same formulas in v8.5 and I cannot see/use all the formulas in v8.5 and with this I cannot create the same report what I created in v10. Am I doing something wrong in my...
  9. rbvcbr

    CR Version 10

    I have created a report in version 10, and I want save that report under 8 or 8.5. I want use this report under version 8 or 8.5. Is there any option in version 10 how I can do this. Thank you.
  10. rbvcbr

    Count or sum text field

    I have a formula field which returns 0 or 1, I want to count how many 0s and how many 1s. I formatted this field as numaric. Then I try right clicking on this field it gives me 'move' instead 'Insert/grand total or summary" Can some help how to do this. Thanks in advance
  11. rbvcbr

    Reports fields

    I took over a new job. I have report created by previous employee. I have 'country' field twice on the report next to each other. I can move one field and the other field I cannot move (and it is grayed out). Is there any way can take off that gray out and move the field around. And also how...
  12. rbvcbr

    % Complete - 2 decimals

    I want to show %Complete with two decimals, like if trade is completed 20.22%, I want to show it as 20.22%, not as 20%. Any help please, Thanks,
  13. rbvcbr

    Images / Links - on off

    I have 3 icons/small images, all these have href links. dark1on.gif,dark1off.gif, dark2on.gif,dark2off.gif, dark3on.gif,dark3off.gif, I have a href link to dark1on.gif, when I click on dark1on.gif I want to go to this href link, and show dark1off.gif showing or identifying, that I am in this...
  14. rbvcbr

    Mouseover

    Windows XP pro / Javascript I have two images, 90x90 and 160x160 sizes. I am looking for javascript mouseover code, if I mouseover on 90x90 I want to see 160x160. Not the same size as 90x90. Any help please Thanks,
  15. rbvcbr

    MS Access / PHP Authentication (validation)

    I am looking for MS Access 2000 / PHP authentication (ODBC) tutorial, for user login name with password to access certain pages. Can you please give me the link or code. Thanks.
    • rbvcbr
    • Thread
    • Replies: 1
    • Forum: PHP
  16. rbvcbr

    Access Forms / Network

    I created form in MS Access 2000 / XP, put it on the network,but for some reason, all users cannot use this form at a time. One user only can use this a time. Is there anyway I can fix this to use this form by all users. Do I have to change form properties, or change network setup ? Thank you,
  17. rbvcbr

    PHP / ODBC / MYSQL

    When I run this I can write "userid" where you see Welcome, But it is not working with my sql statement. Need code help please. Can somebody fix this. I tried GET and POST, no luck. Thank you, ---------------------------------------- Welcome <?php echo $_REQUEST["userid"]; ?>.<br />...
    • rbvcbr
    • Thread
    • Replies: 3
    • Forum: PHP
  18. rbvcbr

    MYsql connection/PHP

    I am getting the following message, when I installed mysql client version 5.1.11. I get this message when I tried to connect through PHP. I am using, windows XP professional. Any help please. Thanks, "Client does not support authentication protocol requested by server; consider upgrading MySQL...
  19. rbvcbr

    Word / Mail Merge

    I created a mail merge with ODBC with access 2000 and word 2000, it works fine. I use it get out. Then when I try to use it next time or in next day, it always asks to 'find odbc' or database file/location. Is there any I can fix this by passing this 'find odbc' question. Thank you.
  20. rbvcbr

    Access Tables/Queries/Forms

    I have a small question. I copied Northwind.mdb from my home desktop to my notebook. While I am on the road, I created some new queries, when I get back to home, I copied to back to desktop only newly created queries. (since data is same in tables, in both handheld and notebook). Is this okay...

Part and Inventory Search

Back
Top