G
Guest
Hi,
I am running a query that concatenates two text fields into one, the
statement in the Field box in the query design grid looks like this:
Site:
![Station ID] & " - " &
![Station Name]
As stated, both [Station ID] and [Station Name] are text fields. The query
concatenates the two fields, but the results are records where there is
variable length in space between the [Station ID] field and the " - ".
Records look like this:
C03SALML01 - Salmon Lake
4328AL01 - ALICE CREEK
HE409 - HOGUM, EAST FORK
C03POORC02 - Poorman Creek -first stream crossing d/s of SF
What I want is just one space between the [Station ID] and the " - ", like
the first example in the previous list. Any ideas what may be going on? thanx
I am running a query that concatenates two text fields into one, the
statement in the Field box in the query design grid looks like this:
Site:
As stated, both [Station ID] and [Station Name] are text fields. The query
concatenates the two fields, but the results are records where there is
variable length in space between the [Station ID] field and the " - ".
Records look like this:
C03SALML01 - Salmon Lake
4328AL01 - ALICE CREEK
HE409 - HOGUM, EAST FORK
C03POORC02 - Poorman Creek -first stream crossing d/s of SF
What I want is just one space between the [Station ID] and the " - ", like
the first example in the previous list. Any ideas what may be going on? thanx