User Profile

Collapse

Profile Sidebar

Collapse
rmatos95
rmatos95
Last Activity: May 4 '10, 03:32 PM
Joined: Sep 4 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • rmatos95
    started a topic Convert zeros to null
    in Access

    Convert zeros to null

    I have a table where, in many fields there are numbers from 0 to 5. I need to convert the zeros into null. I guess I need to create an append query, but I do not know which expression to use so that it will convert the zeros to null.
    Thanks for the help!
    See more | Go to post
    • rmatos95
      replied to Can I create an online application that feeds into PeopleSoft Financials 7.5?
      in Oracle
      data entered by a vendor online (on a website) need to be stored in the master vendor file in PeopleSoft. The tab in PeopleSoft is called "vendors". I don't think it is a flat file.
      See more | Go to post

        Leave a comment:

      • rmatos95
        started a topic Can I create an online application that feeds into PeopleSoft Financials 7.5?
        in Oracle

        Can I create an online application that feeds into PeopleSoft Financials 7.5?

        We have PeopleSoft Financials 7.5 (I think). I wanted to know if it is possible to have vendors (who provides services to us) fill out an online application and have that information feed directly into the "vendor" file. Is that an integration? Would it take a customization from PeopleSoft? I am just trying to figure out if it is possible before I decide to go that route.
        See more | Go to post
        • rmatos95
          replied to Problem with the aggregate Sum function
          in Access
          Wow! It worked! I still don't know what it is summing, but now I understand that it is totalling more records than what my query returns. I was able to create another query of my original query and total only the results I want. Thanks, that answers my question.
          p.s. I took a couple fields off because I thought they were unecessary.
          Thank you again!
          See more | Go to post

            Leave a comment:

          • rmatos95
            replied to Problem with the aggregate Sum function
            in Access
            I am not sure if this will give more information to my problem, but here are a couple rows of my data:
            Code:
            . ID    TRC  Quantity  Hrs Yr
103187  FEX     -8      2007
103187  FEX      8      2007
600508  FEX      5      2007
600508  FEX      6      2007
601729  FEX     -8      2007
601729  FEX      8      2007
            But when I do Sum for the quantity field, the sums are not always correct. Here is what...
            See more | Go to post

              Leave a comment:

            • rmatos95
              started a topic Problem with the aggregate Sum function
              in Access

              Problem with the aggregate Sum function

              Hi all! I am trying to have a query return the sum of hours in a certain field. My problem is that when I use the Total Sum, the sum does not add up to the real sum. I can't seem to find out why. I know the query is pulling data from a numeric field and that when I don't Sum it return the correct records. Another peice of information is that some of the numbers are negative, but for some records it sums right and for others it does not, but it does...
              See more | Go to post
              Last edited by Stewart Ross; Sep 5 '08, 02:06 PM. Reason: Please use the code tags provided to delineate your SQL code.
              No activity results to display
              Show More
              Working...