asked on

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

Jerry Miller

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))

beatified

ASKER

Ok that worked but its converting the Uppercase "D" to lower case "d". Is there a way to fix this?
Image-007.jpg

ASKER CERTIFIED SOLUTION

Jerry Miller

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

beatified

ASKER

Thank you so much for giving me the newb version exactly what I needed.

beatified

ASKER

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.

Jerry Miller

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

beatified

ASKER

Ok thanks I will probably post a question anyway so your welcome to take a stab at it if you want.

beatified

ASKER

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?

Jerry Miller

What does your query look like? Those are asking for parameters like you are expecting user input.