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 Chriss Miller 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. knappm

    Group on Dollar Totals

    Changing it to WhilePrintingRecords results in a "Group specified on a non-recurring field" error. Am I even approaching this the right way? Is there a better way? Is this even possible? Thanks. Mark
  2. knappm

    Group on Dollar Totals

    Let me modify my statement a little. When I refresh the report, it doesn't group as desired. I puts each primary in its own group, and then puts all the secondaries into a single group. If I add a line such as "WhileReadingRecords" to the top of the formula, then it groups correctly --...
  3. knappm

    Group on Dollar Totals

    primary item up with secondary items of close to equal value. So, for example, if you had primary and secondary items as follows: Type Amount P $1,000,000 P $750,000 S $50,000 S $465,000 P $20,000 S $650,000 S $400,000 S $300,000 Then, ideally, it may group them as follows: P $1,000,000 S...
  4. knappm

    Combine Two Queries

    In case someone's curious, I did manage to incorporate all of this into one query using the EXISTS predicate. The query is as follows: SELECT Employee.Name, Employee.[No], touter.Description, Max(touter.dDate) AS MaxOfdDate, touter.Duration FROM Training AS touter INNER JOIN Employee ON...
  5. knappm

    Combine Two Queries

    Haha.. oops. I just figured it out. :-P Thanks again for the help! Greatly appreciated.
  6. knappm

    Combine Two Queries

    Thanks for the reply. After a bit of monkeying around, I was able to display the results I'm looking for based on your idea. Thank you. However, there's still a little problem. I only want to display the value from table A or nothing at all. That is, if the matching record is not in table B...
  7. knappm

    Combine Two Queries

    That's what I would like to do. Just simplify it all down to one query that I can set as the source of the listbox. But thus far, I have not been able to construct that query. Maybe it's simple, and I'm just missing it. I'm not an SQL expert by any means. I can't figure out how to select a...
  8. knappm

    Combine Two Queries

    I was wondering if it would be possible to combine the following two queries given the scenario. I have a value list listbox that I want populated with certain data. So, this is what I do. I select all records with a given criteria. Then for each result, I do another query and based on the...
  9. knappm

    CR8 and IE6

    Hiya, On at least 2 computers, we've run into a problem with Crystal Reports 8 and Internet Explorer 6. They are NT machines with Service Pack 6. We're in the process of updating many computers in the company. The ones in question could open/run the reports fine. Then we updated the computers...
  10. knappm

    Protecting an Access Database

    Right. Those are both good ideas that I have considered. However, I believe it is possible to crack the password on an Access database. And while it's true that they most likely won't find a database hidden in a few levels of obscure directories, it's still possible. I imagine implementing both...
  11. knappm

    Protecting an Access Database

    Heya. I will soon be developing a website using VBScript in ASP. It will run on a W2K server with an Access 2000 database. The ASP will require a logon/pass, store that information, and then check it against a verification script included within each ASP page. That should ensure that the ASP...
  12. knappm

    Prompted multiple times for same parameter value when adding subrep

    Heh, well, both maybe? I don't fully understand either and if I could understand both, then I would be able to choose the best solution for me. When I asked the question, I guess I was referring to creating a form though. That's what I was trying to get to work and couldn't. Thanks. Mark
  13. knappm

    Prompted multiple times for same parameter value when adding subrep

    Could you possible elaborate a bit on this solution. I'm in the same situation, and I can't seem to figure out exactly how to implement this solution. Any help would be appreciated. Thanks, Mark

Part and Inventory Search

Back
Top