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!

  • Congratulations strongm 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: *

  1. Santos

    How do I handle multiple rows?

    LB....this works PERFECTLY. Thanks so much!
  2. Santos

    How do I handle multiple rows?

    Hi LB, thanks for the quick response. I do know for sure the approver 2 and 3 belong to each of their respective job titles. I was able to verify it. Unfortunately, no other fields repeat....I wish at least one did.
  3. Santos

    How do I handle multiple rows?

    I'm creating a new report that pulls data from our ASP applicant tracking system. We can't pull directly from the database, so we have to download the data and then save it as an access file. The problem is with how they generate the report. It looks like this in Access: Job Title One...
  4. Santos

    Compare records between 2 different subreports?

    Hi, Is there a way to compare 2 records beween 2 subreports? For example, I have 2 subreports and I would like to match records between the two. I want to set it up so that if there is a match, then the matching record will be suppressed. I tried using the shared stringvar statement with no...
  5. Santos

    Query and parameter prompt

    It's just one parameter used by all three queries. - dan
  6. Santos

    Query and parameter prompt

    Any thoughts? thanks...dan
  7. Santos

    Query and parameter prompt

    Hi...I'm working with three peoplesoft queries: one for the main report and the other two are for subreports. When I run the whole report, I am prompted three times because the three queries require a parameter prompt. Is there any way to have the parameter prompt come up only once? I tried...
  8. Santos

    Horizontal Display??

    Thanks everyone...I fixed it! - dan
  9. Santos

    Horizontal Display??

    Hi Geoff, Email: daniel_santos@avid.com Thanks!
  10. Santos

    Horizontal Display??

    Hi everyone, Does anyone know the formula for displaying a field with multiple rows...on just ONE row? Hope this makes sense: Example: Jones1 Jones2 Jones3 ----> Jones1, Jones2, Jones3 I saw this formula a while back, but since the keyword search is down, I can't find it. Can anyone help...
  11. Santos

    Two different tables linked to same table...need help

    Hi everyone, I have a problem here that I can't seem to figure out. Basically, I have four tables (Candidate, Offers, Interviews, and Status) The candidate table is linked to both the offer and interview tables. Both the offer and and interview tables are linked to the status table. What...

Part and Inventory Search

Back
Top