Field Name in a Table

  • Thread starter Thread starter carl
  • Start date Start date
C

carl

Is there a way to specify that a table will not have field names in
the top row. I transpose my data so the field names are in the first
column - thus I have no need for field names at the top of the table.

In my case, after the transpose, the field names are "1" and "2". I
can't figure out a way to remve thee.

1 2
Total Volume: 460486
Total Trades: 37990
PIP Volume: 282183
PIP Trades: 20659
QQQ Volume: 8290
QQQ Trades: 496
SPY Volume: 40223
SPY Trades: 2606
PEN Volume: 373296
PEN Trades: 27800

Trying to get

Total Volume: 460486
Total Trades: 37990
PIP Volume: 282183
PIP Trades: 20659
QQQ Volume: 8290
QQQ Trades: 496
SPY Volume: 40223
SPY Trades: 2606
PEN Volume: 373296
PEN Trades: 27800


Thanks in advance.
 
carl said:
Is there a way to specify that a table will not have field names in
the top row. I transpose my data so the field names are in the first
column - thus I have no need for field names at the top of the table.
Click to expand...
Nope. It sounds like you don't want a table: you want a report showing your
data. If you're intending to store the data in a table then field names are
required, I'm afraid. What is your objection to them?
 
Is there a way to specify that a table will not have field names in
the top row. I transpose my data so the field names are in the first
column - thus I have no need for field names at the top of the table.

In my case, after the transpose, the field names are "1" and "2". I
can't figure out a way to remve thee.
Click to expand...

Don't confuse data STORAGE with data PRESENTATION. They are two different
tasks with different requirements!

Tables are for data storage; a table represents a collection of instances of
some type of "Entity" - a real-life person, thing, or event. The Fields in the
table are "Attributes" of that entity: discrete chunks of information of
interest for your application.

Tables should not be used for data viewing or editing. That's better done
using a Form. It's perfectly easy to take a table with fieldnames as you
describe, and create a Form or Report with the fields in textboxes running
down the screen vertically (or horizontally, or in blocks, or on multiple tab
pages, or pretty much any way you like).
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com
 
Nope. It sounds like you don't want a table: you want a report showing your
data. If you're intending to store the data in a table then field names are
required, I'm afraid. What is your objection to them?
Click to expand...

Thanks. I am just starting out with Access.

I send this info via email. The email is read into a process
automatically. That process does not like the field name - rejects all
the data.

Can you show me how i can take this query and generate a report (with
Field Names vertical) ?

SELECT TotalVolume.[Total Volume: ], TotalTrades.[Total Trades: ],
TotalPIPVolume.[PIP Volume: ], TotalPIPTrades.[PIP Trades: ],
QQQVolume.[QQQ Volume: ], QQQTrades.[QQQ Trades: ], SPYVolume.[SPY
Volume: ], SPYTrades.[SPY Trades: ], PENVolume.[PEN Volume: ],
PENTrades.[PEN Trades: ]
FROM TotalVolume, TotalTrades, TotalPIPVolume, TotalPIPTrades,
QQQVolume, QQQTrades, SPYVolume, SPYTrades, PENVolume, PENTrades;
 
carl said:
Nope. It sounds like you don't want a table: you want a report
showing your data. If you're intending to store the data in a table
then field names are required, I'm afraid. What is your objection to
them?
Click to expand...

Thanks. I am just starting out with Access.

I send this info via email. The email is read into a process
automatically. That process does not like the field name - rejects all
the data.

Can you show me how i can take this query and generate a report (with
Field Names vertical) ?

SELECT TotalVolume.[Total Volume: ], TotalTrades.[Total Trades: ],
TotalPIPVolume.[PIP Volume: ], TotalPIPTrades.[PIP Trades: ],
QQQVolume.[QQQ Volume: ], QQQTrades.[QQQ Trades: ], SPYVolume.[SPY
Volume: ], SPYTrades.[SPY Trades: ], PENVolume.[PEN Volume: ],
PENTrades.[PEN Trades: ]
FROM TotalVolume, TotalTrades, TotalPIPVolume, TotalPIPTrades,
QQQVolume, QQQTrades, SPYVolume, SPYTrades, PENVolume, PENTrades;
Click to expand...

A report, as I meant it, is an Access object - just go to the Reports tab
and use the wizard to create the report based on the union query I showed
you how to create yesterday. Then, in the report's Design view, delete the
labels containing the field names.

However, that does not address your real problem, which you really should
have explained to begin with. How are you planning to get the data into the
email? VBA code? Copy-paste? If the latter, you're just pasting text and you
can delete the column names after pasting.
 
Back
Top