query results

[jkjmwilliams]

How can I display only 4 digits in a number in a query when the original data
has 5. I am storing my numbers as text.

JoAnn

 

[jkjmwilliams]

This would also apply to how to show only the first letter (initial) of a
name. How to?

 

[Dirk Goldgar]

How can I display only 4 digits in a number in a query when the original
data
has 5. I am storing my numbers as text.

Let your query select the expression,

Left([YourNumberField], 4)

 

[Dirk Goldgar]

This would also apply to how to show only the first letter (initial) of a
name. How to?

For example,

SELECT Left([FirstName, 1), LastName
FROM MyTable

 

[jkjmwilliams]

Thanks, I tried it out, and it worked! You forgot to put the closing bracket
in, but I figured that part out. I just needed to know the right code.

This would also apply to how to show only the first letter (initial) of a
name. How to?

For example,

SELECT Left([FirstName, 1), LastName
FROM MyTable


--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[Dirk Goldgar]

You forgot to put the closing bracket in

Oops! Sorry about that. I'm glad that didn't stop you.