Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 339
  • Last Modified:

Insert a character into an access field in a report

I need to display a hyphen in an access report that is not in the data itself.

So in the example I included in the screen cap. 51D should end up as 51-D in the report.

This ones got me running in circles any help would be appreciated.

Thanks,
BTW I'm a newbie Access users.
Image-004.jpg
Image-005.jpg
Image-006.jpg
0
beatified
Asked:
beatified
  • 5
  • 4
1 Solution
 
Jerry MillerCommented:
Looking at the representative data, you have the number is always two number and a letter. So iIn the query that you use to bind the data, you can use the LEFT and RIGHT functions.

ApartNumber: (LEFT([ApartmentNumber], 2) & '-' & RIGHT([ApartmentNumber],1))
0
 
beatifiedAuthor Commented:
Ok that worked but its converting the Uppercase "D" to lower case "d". Is there a way to fix this?
Image-007.jpg
0
 
Jerry MillerCommented:
You can use UCase to change it to upper case.

ApartNumber: (LEFT([ApartmentNumber], 2) & '-' & UCase(RIGHT([ApartmentNumber],1)))
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
beatifiedAuthor Commented:
Thank you so much for giving me the newb version exactly what I needed.
0
 
beatifiedAuthor Commented:
I will start another question if you have an answer for this since it is a different question. But the goal in this is to autofill a form I have in both word and PDF. Is it possible to overlay the data directly onto the PDF in Access. So that I only have to print once and not once for the form and once for the data? If so just answer Yes and I will post a new question.
0
 
Jerry MillerCommented:
I am sure it is possible, but a little out of what I have ever done. I know that you can export a report. Check out this link and see if it fits what you want to do.

http://office.microsoft.com/en-us/access-help/distribute-a-report-electronically-HA010206320.aspx
0
 
beatifiedAuthor Commented:
Ok thanks I will probably post a question anyway so your welcome to take a stab at it if you want.
0
 
beatifiedAuthor Commented:
One last thing everything is working fine except I'm getting 2 query reqests for data to match. As seen in the sreen caps. Any Idea what this is?
12
0
 
Jerry MillerCommented:
What does your query look like? Those are asking for parameters like you are expecting user input.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now