Search results for query: *

Union query seems the way to go, from what I understand. It puts all the data from one table first, then the second table AFTER the fields from the first. I have no idea how to actually DO one of these, but I'm sure it's easy to find.

Have you tried this? http://www.lebans.com/reporttopdf.htm ? I'm not sure if it will solve ALL your problems, but it's another avenue.

Is there a specific reason that you have to send it in PDF form?

DAmoss, you might be better off using the Label as Samyers said, Have you tried this? Also, make sure you're selecting the subreport control on your main form, and NOT the subreport's properties itself.

Ok, I don't have the entire answer. I'll keep looking. But a good starting point MIGHT be this. In the criteria of a query, you could put, Like "[A-Z]*" That way you can at least SEE the separation. This might not help you, but I'll keep researching.

Wow, MajP. Thank you so much for going into depth and explaining it all to me. I believe I actually understand everything now. I still don't think I can use grouping to limit the number of queries effectively, but at least I understand how it's used. Thanks again. I'm archiving this thread...

Also, MajP, how does each know what query or table you're getting the information from? val1 = strVal("Count of Employees") val2 = DCount("EmployeeID", "Employees") val3 = strVal("Employees") Call insertVals(val1, val2, val3) I see what Val1 equals, But val2? It's obviously counting...

Hrm, MajP. That certainly looks interesting, and I may play around with that. I enjoy working in code better anyway. I have two questions: 1) Where do you put that code? Link it to a button or something? a) Where does the output go? tblOutput? 2) I HAVE used VBasic for years, but...

Ok. I finally got it. It was a mix between finding the right syntax to call a subreport field, and not knowing that the subreport name could be different than the source report name (thanks, dhookom) It works perfectly now, this is what the text box on the main report has as a control source...

Just to finish this thread up. I DID find a way around, still using subreports, but pulling the info from the subreport to my main report.

This isn't exactly the same question. By asking the other questions, I have found out other things I might be able to do, so I'm trying to figure out how to do those specific things. I need to pull a control or a field from the subreport. My main problem is that everything I have tried to do...

Ok, so now, I've run into the problem where you can only have 32 queries linked to a query. I'm pretty sure there's no way around this "Query too complex" error, so I've been looking at other, more complicated, and more annoying ways of doing this.

Ok, hopefully, this is a simple problem. I have a report, with a subreport on it. This subreport has a field on it, and all I want to do, is reference that field in the main report. That's it. From what I've been able to research, (which is nothing) this is completely impossible in every...

Ok, here's the problem I'm running into. (Some of you may remember part of the problem from other posts.) I've got a lot of queries that count other queries. All of these queries need to be displayed on one report. I don't want to use subreports because they're very annoying. I originally...

lespaul, I did not know you could do that, actually... I'm going to try to mess around with this right now. This may be one of the MANY problems that arises from me being self-taught in Access. There is a bunch of stuff that I'm just not aware of. Hrm... I run that, and just get this error...

Someone mentioned something about running functions on the report earlier... Any ideas how that would work? I can make all the queries independently, then run a function on my Master report for all the counts I need, or something, I just don't know how, or the syntax for that. Also, I made...

Main query with 3 of the 'subqueries' in it: SELECT qryAsianApplicantTotal.AsianApplicant, qryAsianHiredTotal.AsianHired, qryBlackApplicantTotal.BlackApplicant; Query 1: SELECT Count(*) AS AsianApplicant FROM (SELECT DISTINCT tblCompilation.IDCompilation FROM qryAsianApplicant) AS...

Right now I have 32 queries that look like this: SELECT Count(*) AS IndianHired FROM (SELECT DISTINCT tblCompilation.IDCompilation FROM qryIndianHired) AS qryIndianHired; Then, one query that simply has That field from each of the 32 queries. That's all. If I put more than 32 queries in...

Ok, it seems that this message is my bane. Antithesis, if you will. I have a lot of calculated numbers from many different queries, which I then have combined all in one query (this query is nothing but a holding query: it holds no calculations, it simply has the ONE field from each of my...

Ok, so I'm a complete idiot, it turns out. Thank you for helping dhookom, but Ray1127's answer was EXACTLY what I needed. I couldn't really make sense of the SQL (not your fault, of course, I just think you assumed I had a better grasp of SQL than I actually do.) I just made a new query...