Search results

When I open the subreport all the data is there. Under the properties: All Name............Grouped by CM Shares Source Object... Report.qry_Grouped by CM Shares Link Child Fields.... AssetName Link Master Field..... AssetName Visible............... Yes Can Grow.............. Yes Can...

Any direction is appreciated. I have a report with a subreport and when I view the report, the subreport portion does not show up. Any suggestions on what I should be looking for?

I have a report, stemming from a query, based on 2 tables. I need to have just certain accounts in the query that I want in the report. As soon as I run the report or query the results seem to multiply many time (sometimes duplicates, triplicates etc). I posted this earlier this summer under...

Having little experience, I need to have more explanation. Option A sounds the easiest, but can I then enter the date each time I run the report, as we need this. If so, then can you help me to write the where clause and tell me exactly where to place it in the report. How to I know if I'm...

Upon looking closer at the original tables that the query is based on I do see that there is another column that I have overlooked. That is, the 'lot number', the shares have also been purchased in many lots, so there in I believe is where is appeared to be duplicates. So, my next question is...

I need show the issue in process with each company in the accounts listed, as well as the activity level, the number of shares for each code, what action was taken, when the action began and ended, and any comments about the action itself.

Here's the SQL. SELECT DISTINCTROW tbl_Actions.Code, [tbl_MonthEndTrust--fromComerica].Shares, tbl_Actions.Action, tbl_Actions.[Activity Level], tbl_Actions.Issue, tbl_Actions.[Begin Date], tbl_Actions.[End Date], tbl_Actions.Comment FROM tbl_Actions INNER JOIN [tbl_MonthEndTrust--fromComerica]...

I have two tables the query is based on are: Table 1: Code, Asset Name, Shares, AccountNo Table 2: Code, Action, Activity Level, Issue, Begin Date, End Date, Comments Under the begin date in the query I have >=([Start])which works fine. Under the AccountNo I have listed just certain...

I have a report based on a query which is working correctly. However, the report linked a form based on a this query does not return the proper dates. The report prompts for a >=([Begin Date]) and returns the prompt when you input the date it does not filter out the appropriate dates. It...