Data not showing up in Query, but in Table

[kxj3]

Good afternoon everyone. My name is Kim. I am working with a database and existing query from my predecessor. The field in the query appears in both the database table and the query. However, when I run the query it doesn't appear. Is there a limit to the number of columns in a query? I easily added a new column and moved a column, but this is stumping me.

Help!:banghead:

 

[CJ_London]

the limit is 255 columns in a query - if you are using the query designer make sure the 'show' option is ticked

 

[rzw0wr]

Check the design view to see if the check box is set (has check mark)

Dale

 

[kxj3]

If I go to design view is that in there?

 

[kxj3]

I only have 25 columns and it is marked "show" underneath in the design view.

 

[CJ_London]

can you post the sql to your query and indicate which field is not showing

To see the sql, click on the view -SQL button to the top left of the ribbon

 

[kxj3]

Sure - here is the sql for the business phone number column.
[Business Phone], [MIP Participants Table]

 

[kxj3]

Here's the entire sql.
SELECT [MIP Participants Table].ID, [MIP Participants Table].[Program Year], [MIP Participants Table].[Group I], [MIP Participants Table].[Group II], [MIP Participants Table].[Group III], [MIP Participants Table].[Last Name], [MIP Participants Table].[First Name], [MIP Participants Table].MI, [MIP Participants Table].[Badge Name], [MIP Participants Table].Title, [MIP Participants Table].[Co-op], [MIP Participants Table].Address, [MIP Participants Table].City, [MIP Participants Table].State, [MIP Participants Table].Zip, [MIP Participants Table].[Business Phone], [MIP Participants Table].Fax, [MIP Participants Table].[E-Mail], [MIP Participants Table].[Completed Unit A], [MIP Participants Table].[Completed Unit B], [MIP Participants Table].[Completed Unit C], [MIP Participants Table].[Mobile Phone]
FROM [MIP Participants Table]
WHERE ((([MIP Participants Table].[Program Year])="2013-2014") AND (([MIP Participants Table].[Group II])=Yes))
ORDER BY [MIP Participants Table].[Last Name];

 

[kxj3]

I did get the column finally to appear in the query, but it has "Expr1015" in the title field of it instead of the name Business Phone.:banghead:

 

[CJ_London]

This is because it couldn't find it originally - you have spaces in your field names which is never a good idea and is probably the reason why you had a problem.

In query builder, find the relevant column and remove 'Expr1015:' and ensure that Business Phone is in square brackets