Two Quick Questions

[Schwimms]

These are both in queries
I have a column for Shipped Dollars. In this column I have "$ 1425.52" with
the quotes. I want to remove those quotes automatically without having to use
the remove function. If I could add it to the criteria of the column.

Next, I have a column for Order by Name. In this column the name looks like
this - Gunther John M
I want to remove that space between the name. I tried the trim function iin
the criteria of the column. Didn't work

 

[KARL DEWEY]

In both of these cases you do not use criteria. Add these in the query
design view grid --
Shipped_Dollars: Replace([Shipped Dollars],""","")

Order_by_Name: Trim([Order by Name])

 

[Schwimms]

Ok, I think am in the query in design view. The only place I know to enter
this is in criteria. Is there something I am missing?

In both of these cases you do not use criteria. Add these in the query
design view grid --
Shipped_Dollars: Replace([Shipped Dollars],""","")

Order_by_Name: Trim([Order by Name])

--
KARL DEWEY
Build a little - Test a little

These are both in queries
I have a column for Shipped Dollars. In this column I have "$ 1425.52" with
the quotes. I want to remove those quotes automatically without having to use
the remove function. If I could add it to the criteria of the column.

Next, I have a column for Order by Name. In this column the name looks like
this - Gunther John M
I want to remove that space between the name. I tried the trim function iin
the criteria of the column. Didn't work

 

[KARL DEWEY]

In query design view the top row of the grid is called 'Field'. Enter what I
posted in a blank column.
--
KARL DEWEY
Build a little - Test a little

Ok, I think am in the query in design view. The only place I know to enter
this is in criteria. Is there something I am missing?

In both of these cases you do not use criteria. Add these in the query
design view grid --
Shipped_Dollars: Replace([Shipped Dollars],""","")

Order_by_Name: Trim([Order by Name])

--
KARL DEWEY
Build a little - Test a little

These are both in queries
I have a column for Shipped Dollars. In this column I have "$ 1425.52" with
the quotes. I want to remove those quotes automatically without having to use
the remove function. If I could add it to the criteria of the column.

Next, I have a column for Order by Name. In this column the name looks like
this - Gunther John M
I want to remove that space between the name. I tried the trim function iin
the criteria of the column. Didn't work

 

[Schwimms]

HAHAH! Duh! I blanked out. I know thats how you build an expression. Thanks!

In query design view the top row of the grid is called 'Field'. Enter what I
posted in a blank column.
--
KARL DEWEY
Build a little - Test a little

Ok, I think am in the query in design view. The only place I know to enter
this is in criteria. Is there something I am missing?

In both of these cases you do not use criteria. Add these in the query
design view grid --
Shipped_Dollars: Replace([Shipped Dollars],""","")

Order_by_Name: Trim([Order by Name])

--
KARL DEWEY
Build a little - Test a little


:

These are both in queries
I have a column for Shipped Dollars. In this column I have "$ 1425.52" with
the quotes. I want to remove those quotes automatically without having to use
the remove function. If I could add it to the criteria of the column.

Next, I have a column for Order by Name. In this column the name looks like
this - Gunther John M
I want to remove that space between the name. I tried the trim function iin
the criteria of the column. Didn't work

 

[Schwimms]

Excellent I got the quotation marks to be replaced, but I needed to do a
double "" rather then a single " otherwise I got an error.

Although I was not able to do the trim()..and I don't know why?? Any other
suggestions?

In query design view the top row of the grid is called 'Field'. Enter what I
posted in a blank column.
--
KARL DEWEY
Build a little - Test a little

Ok, I think am in the query in design view. The only place I know to enter
this is in criteria. Is there something I am missing?

In both of these cases you do not use criteria. Add these in the query
design view grid --
Shipped_Dollars: Replace([Shipped Dollars],""","")

Order_by_Name: Trim([Order by Name])

--
KARL DEWEY
Build a little - Test a little


:

These are both in queries
I have a column for Shipped Dollars. In this column I have "$ 1425.52" with
the quotes. I want to remove those quotes automatically without having to use
the remove function. If I could add it to the criteria of the column.

Next, I have a column for Order by Name. In this column the name looks like
this - Gunther John M
I want to remove that space between the name. I tried the trim function iin
the criteria of the column. Didn't work

 

[KARL DEWEY]

Try this --
Order_by_Name: Left([Order by Name],InStr([Order by Name]," ")) &
Trim(Mid([Order by Name],InStr([Order by Name]," ")))
--
KARL DEWEY
Build a little - Test a little

Excellent I got the quotation marks to be replaced, but I needed to do a
double "" rather then a single " otherwise I got an error.

Although I was not able to do the trim()..and I don't know why?? Any other
suggestions?

In query design view the top row of the grid is called 'Field'. Enter what I
posted in a blank column.
--
KARL DEWEY
Build a little - Test a little

Ok, I think am in the query in design view. The only place I know to enter
this is in criteria. Is there something I am missing?

:

In both of these cases you do not use criteria. Add these in the query
design view grid --
Shipped_Dollars: Replace([Shipped Dollars],""","")

Order_by_Name: Trim([Order by Name])

--
KARL DEWEY
Build a little - Test a little


:

These are both in queries
I have a column for Shipped Dollars. In this column I have "$ 1425.52" with
the quotes. I want to remove those quotes automatically without having to use
the remove function. If I could add it to the criteria of the column.

Next, I have a column for Order by Name. In this column the name looks like
this - Gunther John M
I want to remove that space between the name. I tried the trim function iin
the criteria of the column. Didn't work