Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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