field not displaying in table

  • Thread starter Thread starter JEB50
  • Start date Start date
J

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.
 
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.
 
Open the table in datasheet view
Select Format
Select Unhide
Tick the boxes you want to see

HTH
 
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");
 
Wrong thread.
--
Build a little, test a little.


KARL DEWEY said:
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.


JEB50 said:
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.
Click to expand...
Click to expand...
 
Back
Top