field no show
in [Queries]
|
Prev: Append Query with Oldest top Records by Group
Next: You tried to execute a query that does not include the specified expression...
From: Jerry Whittle on 20 Apr 2010 13:27 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? -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "seeker" wrote: > 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. > > "Jerry Whittle" wrote: > > > 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 ; > > -- > > Jerry Whittle, Microsoft Access MVP > > Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. > > > > "seeker" wrote: > > > > > 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 |