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!
-
multiple charts on a report - too many parameter prompts
Hi, I guess I'm answering my own question. I didn't realize when I asked this question that I could make the criteria line of my query based on a field of a report. In the criteria row of the style# column of my query, I typed: [Reports]![ReportName]![Style #] This seems to have...- elisharae
- Post #2
- Forum: Microsoft: Access Reports
-
Too many fields defined... ?
You see, at51178, I cannot just mechanically add extra columns to the table. I need the tables merged on matching a certain field (date in my case). As soon as I get to this I have to use the UNION SQL construct seen above. And here it is - the magic circle closes... Unless there is something I...- elisharae
- Post #9
- Forum: Microsoft: Access Modules (VBA Coding)
-
multiple charts on a report - too many parameter prompts
I created a query which prompts the user for a style# when it runs. I then created a report based on this query. On the report are several charts based on the same query. The report & charts seem to be working properly, except that each time the report runs it prompts the user for a style#...- elisharae
- Thread
- Replies: 1
- Forum: Microsoft: Access Reports
-
Print value from query on form
I am trying to print the value from a query on my form. So, I have a text box on the ClaimClient_MainForm form called ClaimCount. My query goes like this: dim sql as string sql=SELECT Claim.ClientID, Count(Claim.ClaimID) AS CountOfClaimID FROM Claim GROUP BY Claim.ClientID HAVING...- elisharae
- Thread
- Replies: 4
- Forum: Microsoft: Access Modules (VBA Coding)
