table columns don't show when table opened or in query output disp


D

dizzyp

I have these 28 colums in a 2007 accdb table. When I display the table or
run a query, cols 1-8 and cols 20-28 are displayed; cols 9 - 19 are not. The
columns show on the query design screen and grid and are found if I reference
them in the query; they just don't display. Can someone tell me why they
don't display?

col# col Name Type
Size
1 ID_NUMBER Text
10
2 ALTERNATE_ID Text
20
3 PERSON_CODE Text
4
4 PHARM_INSURED_OFFLINE_LAST_NAME Text 35
5 PHARM_INSURED_OFFLINE_FIRST_NAME Text 35
6 METRIC_QUANTITY Double
8
7 DAYS_SUPPLY Double
8
8 DATE_PROCESSED Date/Time 8
9 PHARMACY_NAME Text
50
10 RX_NUMBER Text
30
11 NDC_NUMBER Text
30
12 PRODUCT_DESCRIPTION Text
50
13 NETWORK_COST Currency
8
14 FILL_FEE Currency
8
15 SALES_TAX Currency
8
16 NPS_ADMIN Currency
8
17 HFRX_ADMIN Currency
8
18 PATIENT_PAY_AMT Currency
8
19 TOTAL_DUE Currency
8
20 CKTOT Currency
8
21 CKNO Text
6
22 CKDATE Text
10
23 GROUP_NUMBER Text
11
24 GROUP_NAME Text
30
25 DIVISION Text
3
26 LOCATION Text
20
27 PLAN1 Text
10
28 HFRX_Process_Date Text
8
 
Ad

Advertisements

K

KARL DEWEY

You may have drug the field display so it does not show. Drag the right edge
of field 8 to the right. To do this move the cursor to the top edge of the
query display and hover over the vertical line separating the fields. When
the cursor changes to a vertical line with left and right arrows throgh the
middle then press the left mouse button and drag to the right.

Another check is to create a form from the query and include those fields.
See what it displays.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top