Query Returning Blank Columns

[JungleJme]

Hi,

I've set up a simple query that returns 6 columns of data.

This query then shows on a sub-form elsewhere in my DB.

The problem is that the query always appears with a horizontal slider. Allowing the user to scroll across to see the other columns in the query...

The problem here is that there ARE no other columns of data. They are just empty. I want to restrict the output of this query to ONLY show the 6 columns that i have specified.

I have tried deleting the columns in Query Designer, then save the Query. But every time i re-open it half a dozen or so blank columns are stuck on the end.

Its driving me nuts :banghead: Any idea how to restrict my query to ONLY show the 6 columns??

 

[bob fitz]

Can you show us the SQL statement of the query.

 

[pr2-eugin]

You have to delete the controls in the SubForm.. The Recordsource of the SubForm can have 100 columns, but what you add on the SubForm through controls like TextBox/ComboBox will be appearing in the Display..

 

[JungleJme]

Can you show us the SQL statement of the query.

SELECT issues_table.issue_PK AS ID, issues_table.issue_title AS Title, issues_table.testplan_reference AS [Issue No], Issue_Statuses.Status_Name AS Status, projects_table.ProjectName AS Project, issues_table.issue_raised_Date AS [Date Raised]

FROM Project_Statuses INNER JOIN (projects_table INNER JOIN (Issue_Statuses INNER JOIN (company_table INNER JOIN (person_table INNER JOIN (test_plans_table INNER JOIN issues_table ON test_plans_table.testplan_PK = issues_table.testplan_FK) ON person_table.Person_PK = issues_table.Person_FK) ON company_table.Company_PK = issues_table.Company_FK) ON Issue_Statuses.Status_PK = issues_table.Issue_Status_FK) ON (projects_table.Project_PK = issues_table.Project_FK) AND (projects_table.Project_PK = test_plans_table.project_FK)) ON Project_Statuses.Status_PK = projects_table.Status_FK

WHERE (((Issue_Statuses.Status_Name)<>"Resolved" And (Issue_Statuses.Status_Name)<>"Cancelled"));

There you go, just looking at the subform controls as well....

 

[JungleJme]

I've looked at the subform again and it has only got controls for the 6 fields specified...take a look at the screenshots to see how the subform looks in Design View and how it appears normally with the blank columns at the end....

screenshots uploaded here: http://dropcanvas.com/10q98