Queries

On Sat, 11 Jul 2009 03:00:52 GMT, "gr8_access via AccessMonster.com"
u53119@uwe wrote:

John,
My table name is "Various_Records". As an example, I will use characters as
field names.
These are the fields: P, H, D
My IT wrote some query that gives the following output from these fields....
This is the output as example: And this is just on record.
P123456123456789.1212345678.01 H12345678.0112.3456 D12345678901.2312345678

There are may be around 100-150 records with different numbers but same
preceding characters P, H, D.

Field P has upto 13 character space, H has upto 14 character space, D has
upto 11 character space. The above example might have more character space.

When I tried access sql, this what I have:
Select P&H&D from Various_Records which produces the same result above. But
I would like to break it down like below:
P...
H...
D...

Please let me know if I ws able to explain this time.

Don't confuse data *storage* with data *presentation*. A Query is not an
appropriate tool for presenting data!

Create a Form based on the table.

Put a textbox on the form bound to the P field.
Directly beneath that textbox put another textbox bound to the H field.
Directly beneath that... well, you get the idea.

For printing the data use a Report rather than a Form.

This could be done in SQL but it would be a hassle and is simply not the right
tool for the task.
--

John W. Vinson [MVP]