I gang

Microsoft Access 2003 - query

I want a query or similar to remove the first 8 characters of item codes.

For example 8614-95-10 with the first 8 characters removed leaves "10".

Please see attached image. The "pack quantity" column has been manually

typed in. I would like a query or similar to automatically do it.

Færdigheder: Microsoft Access

Se mere: n query, leaves, image query, query query, access codes, codes access, image leaves, terry888, microsoft access 2003, query access, quantity example, access 2003 access, access 2003, similar access, courses need microsoft action pack, online course assessment microsoft action pack, easiest course microsoft action pack assessment, microsoft action pack subscription, telerik radgrid image column, microsoft action pack assessment, microsoft action pack, visual basic 2008 query access database, access microsoft exchange java, web query access database

Om arbejdsgiveren:
( 3 bedømmelser ) Bristol, United Kingdom

Projekt-ID: #998015

Tildelt til:

simplicityq88

FRIEND HERE IT COMES FOR FREE DON'T ACCEPT NO ONE'S OFFER! Right([TYPEFY],Len([TYPEFY])-8) To remove the first 8 on right. Best regards! :)

$30 USD in 0 dage
(3 bedømmelser)
2.0

17 freelancere byder i gennemsnit $34 for dette job

winghei

Hi, I see your needs and I want to help. ready to start if you are interested.

$30 USD in 0 dage
(30 bedømmelser)
5.4
cyware

Dear sir, please check your PM.

$30 USD in 0 dage
(16 bedømmelser)
5.0
Wonderer

Hi Can do that perfectly Thanks Al

$30 USD på 1 dag
(33 bedømmelser)
4.8
svet63

This isn't hard to do. Regards, Svet.

$30 USD på 1 dag
(3 bedømmelser)
4.5
hungndl

Please, check PM

$50 USD på 1 dag
(0 bedømmelser)
0.0
PakTimes

I am ready to do ur work.

$60 USD in 3 dage
(0 bedømmelser)
0.0
thenomader

Dear sir For your issue, you have the right person here to do exactly what you need. you just have to give me a chance and you will see yourself the pleasing result. Soon

$30 USD in 0 dage
(0 bedømmelser)
0.0
feroitconsulting

Please see my PM

$40 USD på 1 dag
(0 bedømmelser)
0.0
AImran

Please check PMB. Thanks

$30 USD in 0 dage
(0 bedømmelser)
0.0
RHAMMUD

will finish it in a couple of hours. haven done this thousand times.

$30 USD på 1 dag
(0 bedømmelser)
0.0
superMena2001

sir please check your PM for a Free Sample

$30 USD in 0 dage
(0 bedømmelser)
0.0
abduhai

please check my bid and decide in my favour i am fully confident you to give me a chance to solve your problem. Thanks

$35 USD på 1 dag
(0 bedømmelser)
0.0
clgarcia

Hello, I am very interested in working on this project for you. I have extensive experience developing formula- and macro-driven Excel spreadsheets, and specialize in VBA automation. Based on the information provid Mere

$30 USD in 0 dage
(0 bedømmelser)
0.0
kostas505

There is no need for You to pay anything for this. Try this: Open your query in design view. In first empty grid insert: 'Pack Qunatity:Mid([ItemNumber];InStrRev(snumber, "-") + 1)' If Your field "pack quantity" i Mere

$30 USD in 0 dage
(0 bedømmelser)
0.0
apuchades

Hi, I can help you with your access query. Regards, Toni

$30 USD in 0 dage
(0 bedømmelser)
0.0
Parthiban85

Hai i get the results SELECT mid( Product_id,9,8), TQuantity FROM TableName;

$35 USD på 1 dag
(0 bedømmelser)
0.0