Adding field in query design view to enter 207 blanks.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mscomdex - 23 Mar 2006 22:52 GMT

Hi:
Working on a make-table query to make a table to send to IRS to report
1099's. Many required fields contain various number of blanks. That's easy
when the field is supposed to contain 2 or 10 blanks: " " or " ".
But when it gets to 207 blanks, isn't there some way to indicate blanks
without typing the in individually?
I seem to remember in old Dartmouth Basic you could enter "blanks(207)" in
the code. That doesn't work in designing a query (in design view).
Very glad for any suggestions.
Cheers,
Gus

Reply to this Message

John Spencer - 23 Mar 2006 23:15 GMT

I believe you might be looking for Space(207) or alternatively String(207," ")

> Hi:
> Working on a make-table query to make a table to send to IRS to report
[quoted text clipped - 7 lines]
> Cheers,
> Gus

Reply to this Message

mscomdex - 24 Mar 2006 16:46 GMT

Dear John:
Thanks so very much! Of course, I couldn't see the 207 spaces in Datasheet
view, but String(207,"m") put in the character m 207 times, and I could see
that. So thanks very much again.
Now, I'm always asked to "Read and rate the response." I've searched for a
way to "rate" but no joy. I will click on the "yes, this answered my
question" button, but if there's another way to "rate" I don't know what it
is.
In any case, you have my gratitude.
Cheers,
Gus

> I believe you might be looking for Space(207) or alternatively String(207," ")
>
[quoted text clipped - 10 lines]
> > Gus
> .

Reply to this Message

KARL DEWEY - 24 Mar 2006 00:08 GMT

Space(207)

> Hi:
> Working on a make-table query to make a table to send to IRS to report
[quoted text clipped - 7 lines]
> Cheers,
> Gus

Reply to this Message