Lucrecious
Last Activity: May 2 '12, 01:57 PM
Joined: Apr 12 '12
Location:
-
Thanks NeoPa, and so how does one include the field from the query in a report? The query does work, thank you for the sample code which I based the query upon in order to get it to work, however, I don't know how to create the field with the query results as the source.Leave a comment:
-
I have the code which works given the situation I have in the table as follows:
This works as a query, however, I have been unsuccessful in having this code work as the source for a new field within the report.Code:SELECT IIf(PCBanner='Yes' Or PCColumn='Yes' Or PCColumn='Yes' Or PCFootprints='Yes' Or PCPoster='Yes' Or PCOther='Yes','Yes','No') AS PC FROM CRF;
Excuse my ignorance; what is the correct place...Leave a comment:
-
Sorry, here is an elaboration on the particulars of my request.
1. I have a table, called DRM
2. In the table are three checkbox fields called EV1, EV2 and EV3
3. I need to show whether any of the three are true in a checkbox field in a report as space is limited to print horizontally and I only need to see if any one of the three are true or none are true, meaning false (yes = any one field is checked, or no = none of the...Leave a comment:
-
Need a report checkbox which shows a check from any of 3 table fields
I have three check boxes in a table which I would like tracked in a report check box showing a check mark if any one of the three fields has a positive value. For arguments sake the three fields in the table can be called: check1, check2 and check3. The report check box will only be clear (no check) if all 3 table check boxes are empty or clear. Is it possible to have this within a report? If not, how can it be handled so that it displays within... -
Alternately, would it be possible to create a template look and feel so each Report generated is based on the same graphics and layout?Leave a comment:
-
Okay, this is not what I need and now see what you were mentioning.
I took a current report with custom graphics, layout and fonts.
Removed all the selected fields and set the recordsource to the query expecting the report to populate with all the fields using the wildcard "*".
Excuse my ignorance, however, is there a way that a report can be created to dynamically update the fields from a variable...Leave a comment:
-
I followed your instructions, however, the report remains blank.
The second query does match the first and I have set the recordsource of the report to the sql from the second query namely:
SELECT CRF_Fields1.*
FROM CRF_Fields1;
The report remains blank.
The second query does retain the selected fields from the first.
Do you have any suggestions?Leave a comment:
-
Thank you for your suggestion.
In terms of a dynamic report generated based on a custom layout using fields from the query. How is this accomplished with your suggestion? Please elaborate...Leave a comment:
-
Create report based on dynamic query from a select field form
How do I create a dynamic report based on a query that updates from a select field form? I followed the information from the article here entitled: "Checkbox form to allow user to select query output fields". I wish to have the Switchboard run the report after I have used the select field form to generate the results. Is this possible, and if not, is there a way to create a report template which can be applied to the query results of the...
No activity results to display
Leave a comment: