field not displaying in table

[JEB50]

Within Access, there is a field that is showing up in the design view, but
not in the datasheet view. This seems like an easy fix, but I can't figure
it out. Any advice would be greatly appreciated.

 

[Jeff Boyce]

Have you checked to see if the column has been hidden?

(by the way, you really don't want to be using the table directly ... it's
too easy to confuse a datasheet view with a spreadsheet)

Access tables store data ... Access forms (and reports) display data ... use
the Forms, Luke!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Wayne-I-M]

Open the table in datasheet view
Select Format
Select Unhide
Tick the boxes you want to see

HTH

 

[KARL DEWEY]

Try this --
TRANSFORM First(TableA.[Title]) AS FirstOfTitle
SELECT TableA.[Group], [Group] & [Title] AS Expr1
FROM TableA
GROUP BY TableA.[Group], [Group] & [Title]
PIVOT TableA.[Section] IN("One", "Two", "Three");

 

[KARL DEWEY]

Wrong thread.
--
Build a little, test a little.

Try this --
TRANSFORM First(TableA.[Title]) AS FirstOfTitle
SELECT TableA.[Group], [Group] & [Title] AS Expr1
FROM TableA
GROUP BY TableA.[Group], [Group] & [Title]
PIVOT TableA.[Section] IN("One", "Two", "Three");

--
Build a little, test a little.

Within Access, there is a field that is showing up in the design view, but
not in the datasheet view. This seems like an easy fix, but I can't figure
it out. Any advice would be greatly appreciated.