Select Query Broken

  • Thread starter Thread starter dan.cawthorne
  • Start date Start date
D

dan.cawthorne

Does any one know, of the issue in A2k3 With the Query,

I was creating some combo list filters, via query's then putting the
SQL in a Marco Apply filter.

work great then all i sudden, now, when i view the query in normal
mode, (NOT Design mode) Its Showing all the fields that are related on
the table the query is based on, even though only two fields have been
selected. and the show tick is ticked? just for 2,

any ideas whats happening here?

ive tried repairing and compacting database and also restarting access
no luck?
 
Post the SQL for the query.
Click to expand...

This is my SQL

[ProjectQNo] IN (SELECT tbl_Projects.ProjectQNo
FROM tbl_Projects
WHERE (((tbl_Projects.ProjectStatus)=[Forms]![frm_ProjectEdit]!
[Combo91]));

What Was happening is the Query was Not Just Displaying the Field
[ProjectQNo] it was displaying all the fields in the table which the
field ProjectQNo is also from.

No when every a create a query i have to use the query wizard, other
wise the query shows all fields and not just the ones i want.
 
Try this ---
SELECT [tbl_Projects].[ProjectQNo], [tbl_Projects].[ProjectStatus]
FROM tbl_Projects
WHERE [tbl_Projects].[ProjectStatus]=[Forms]![frm_ProjectEdit]![Combo91];

--
KARL DEWEY
Build a little - Test a little


[email protected] said:
Post the SQL for the query.
Click to expand...

This is my SQL

[ProjectQNo] IN (SELECT tbl_Projects.ProjectQNo
FROM tbl_Projects
WHERE (((tbl_Projects.ProjectStatus)=[Forms]![frm_ProjectEdit]!
[Combo91]));

What Was happening is the Query was Not Just Displaying the Field
[ProjectQNo] it was displaying all the fields in the table which the
field ProjectQNo is also from.

No when every a create a query i have to use the query wizard, other
wise the query shows all fields and not just the ones i want.
Click to expand...
 
Back
Top