Table/Fields Question

[Bob V]

If I have to store 72 Alphabetical Letters , Do I then have to have 72
Different fields in my table, and do I make the field size 1?
Thanks for any Help..........Bob

 

[Arvin Meyer [MVP]]

It depends upon what you are doing. Normally, you would have 1 field and 72
rows of data.

 

[Bob V]

Hi Arvin,The problem is for printing purposes its 72 individual boxes that
have to make up words, so as each box on the paper form gets a letter in it,
...........Thanks Bob

 

[Joseph Meehan]

Hi Arvin,The problem is for printing purposes its 72 individual boxes
that have to make up words, so as each box on the paper form gets a
letter in it, ..........Thanks Bob

Bob,

I am having a difficult time visualizing the data and printed results
you are wanting.

Do specific letters go in to specific places on the report? Is there a
special order. Are there different sets of data (the 72 letters)

Do the 72 letters for specific unique groups, like 72 letter words? Are
there spaces between letters? are there blanks What do you do with a blank?

 

[Bob V]

Hi Joseph, its actually 4 horse names to request a race name for a horse,
and the Authority have a paper form, that contains 4 rows of 18 boxes to
fill in. As 18 is the longest name you are allowed, so gaps are counted as a
letter .........Thanks Bob

 

[John W. Vinson]

Hi Joseph, its actually 4 horse names to request a race name for a horse,
and the Authority have a paper form, that contains 4 rows of 18 boxes to
fill in. As 18 is the longest name you are allowed, so gaps are counted as a
letter .........Thanks Bob

This has nothing to do with either tables or fields. It's a Reports question.

Basically, you want to print the letters of "SEATTLE SLEW" in certain places
on a sheet of paper. This can be done using a Report - with either one textbox
and appropriate fonts and kerning, or if need be, by using 18x4 textboxes with
control sources like

=Mid([Horsename], 11, 1)

to print the 11th letter.

John W. Vinson [MVP]

 

[Joseph Meehan]

Hi Joseph, its actually 4 horse names to request a race name for a
horse, and the Authority have a paper form, that contains 4 rows of
18 boxes to fill in. As 18 is the longest name you are allowed, so
gaps are counted as a letter .........Thanks Bob

It appears that you have four bits of information each one having a
maximum of 18 characters. That means four records text type with a maximum
length of 18. I would imagine you would want each record to have additional
fields for things like date requested, requester ID, and maybe other
information. The requester ID would likely be a link to another table
holding the requester information like name address, stable etc.

If you read John's response you will see how you can print out that
information in the format you want.

Remember tables are just for storing information, not formatting it for
printing. Access is a relational database so it uses different tables for
related information unlike a spreadsheet that repeats and repeats the same
related information.

It may seem like this is the hard way to do it, but trust us. In the
long run you will find that it is the ONLY way to do it. It will make your
next questions not only easier but possible.

I hope that helps.