Microsoft Access Question/Query?

Microsoft Access Question/Query?

I have only used access for about a week now. Ive built an append query that gets info from a table and appends to a report when i run the query.
The query contains Description, Location, Part Number, Part Number. Description appends to description, Location to location, part number to partnumber and partnumber to barcode. Criteria for Partnumber is [Enter Part #]

The second part number actual gets converted to a barcode font when appended to the report. What i cant figure out how to do is this.

When i enter a part number in, it grabs all the info and puts it in the report. For the barcode (Part Number) i want an astric before and after that number everytime it is inserted into the report. In other words i want the partnumber inserted in between two astrics so when the text is converted to barcode font automatically in the report, it converts the astric,partnumber,astric into one barcode.

Tags: , ,

Under Forum

1 Comment for Microsoft Access Question/Query?

  • 1. doug a  |  December 9th, 2010 at 8:20 am

    In your query create a new field called barcode No

    then the new field should look like this

    barcode No: “*” & [part number] & “*”

    this will create a new field you then pass that field like all others to you report.

    then whatever you use to create the barcode parse that field instead of the basic [part number] field.

    as the Barcode No will contain *1234567*

    Hope this helps

    Doug

Leave a Comment for Microsoft Access Question/Query?

You must be logged in to post a comment.

Trackback this post  |  Subscribe to the comments via RSS Feed

Categories