field no show

[seeker]

The following query does not show the ID field. This is imperative because
data change is dependent upon this field showing.

select member_time.id, member_time.date, member_time.timein,
member_time.timeout from member_time where member_time.date = #4/16/2010#

This is written in a access database.

Thanks

 

[Jerry Whittle]

That's strange. Maybe it's hidden? Try this:

SELECT member_time.id,
member_time.date,
member_time.timein,
member_time.timeout,
member_time.id as TheID
FROM member_time
WHERE member_time.date = #4/16/2010# ;

If that doesn't work, try this:

SELECT member_time.id,
member_time.date,
member_time.timein,
member_time.timeout
FROM member_time
ORDER BY member_time.id desc ;

 

[seeker]

I suspect that it is hidden. How do you unhide a field. I have check the
property sheet of the table and see nothing. Thanks. The queries you shared
showed all fields except the id and TheId fields.

 

[John Spencer]

In datasheet view, select FORMAT: Unhide columns.

In Access 2007, you will have to find the equivalent in the Ribbon.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[Daryl S]

Seeker -

Is there a column title for the ID field and no data, or is the column title
not even showing?

Did you try putting square brackets around the ID field name (e.g.
member_time.[id])?

Is this in a query def or in code? If it is in code, copy/paste it into a
query (SQL View), and see if that shows it.

It it is in code, can you post the code?

 

[Jerry Whittle]

I just tested things and hiding the column in the table doesn't seem to make
a difference. As you ran other queries, I don't think that's it either. You
can try opening the table and the query in datasheet view. Right click on
them and you should see an option for unhiding fields. See if its not checked.

Also try this to see if the missing column shows up with the wildcard:

SELECT *
FROM member_time ;

Are you seeing any data or columns that you don't expect? Could you be using
lookup fields in that table?