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 SkipVought 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. agsjjs

    Ability to use Access forms/reports without having Access installed

    Those FAQs are very helpful Rick! Thanks for pointing me in the right direction. :-) One more quick question. I have Access 2002 installed on my PC. I can spilt the database, however, Make MDE file is grayed out. Any ideas? Thanks Again. Angelica
  2. agsjjs

    Ability to use Access forms/reports without having Access installed

    I have a unique question about Access. We have Microsoft Office2000 Small Business installed on all our PCs at work, in which Access is not included on the CD. However, we have a a packaged vendor application that has created some reports in Access. On the PCs that do not have Access...
  3. agsjjs

    Sum problem (on a one to many)

    Hi Jason! Your advice worked perfectly! Thank you so much! :-) I have been working on this off and on for a week. It is also better solution for me than DSUM Because I have multiple filters in the query my report runs! Also, yeah Purdue! I graduated in 97 from Krannert' Thanks Again...
  4. agsjjs

    Sum problem (on a one to many)

    Hi John! Thanks for your feedback! Here is what I have found from testing. I have added the DSUM into the expression builder for my calculation field and I changed the txtFiscalWeek to the actual control name. I run the report, and I am prompted for Me. Access thinks Me is a prompt!? I...
  5. agsjjs

    Sum problem (on a one to many)

    I have been reading this thread and I have the same challenge. I tried a DSUM like you suggested, jrbarnett...and I get an error message in my report. As a result of my one to many relationship, EmpPay repeats itself for each job. I have 1 EmpPay value for the multiple jobs an employee...
  6. agsjjs

    Complex Sort in Access Report

    AccessAce. Your trip worked like a charm! Thank you so much!
  7. agsjjs

    Complex Sort in Access Report

    I have been working on a complex sort in Access Reports using Sorting and Grouping and I cannot get it to sort and group in the order I need. Here is what I am trying to accomplish. 1. Group by Order_Number ascending and sum the amounts in the group footer using a calculated field. Group...

Part and Inventory Search

Back
Top