ID

Resolved · Urgent Priority · Version 2003

Mon 12 Apr 2010, 11:22 Delegate Mohammed said...

Mohammed has attended:
No courses

ID

Hi,

I have a problem,

I have made a query with several referrals and diagnostic codes:

Referrals ID Diagnostic ID Number
1 2 1
1 3 2
1 4 3
1 5 4
2 3 1
2 5 2
3 2 1
3 3 2
3 4 3

I would like to have the Third "Number" column generated
Any help on this matter would greatly be appreciated.

Regards
Mo

Wed 14 Apr 2010, 22:58 Trainer Simon said...

RE: ID

Hi Mo,

Thank you for your question.

Do you mean return the last number in the referral code as in the 3 in 323? If so you could create a query and add the fields you need. Create a new field by clicking in the next blank field. Click on the wand icon on the shortcut toolbar which opens the expression builder and type the new fieldname followed by a colon. Open the functions folder and look for the left or right functions which are part of the text category. You could use the right function to extract the last number from that field.

I hope this helps.

Regards

Simon

Mon 19 Apr 2010, 11:03 Edited on Mon 19 Apr 2010, 11:04 Delegate Mohammed said...

RE: ID

Sorry Simon,

the text above doesnt really explain it well as the tabs havent come across

Referral ID Diag ID Generated ID
1 a 1
1 b 2
1 c 3
1 d 4
2 a 1
2 b 2
2 c 3
2 g 4
3 f 1
3 g 2
4 d 1
4 f 2
4 e 3

I want to Generate ID for each Referral ID and Diag ID, until there is a new referral.

Thu 22 Apr 2010, 12:00 Trainer Jacob said...

RE: ID

Hi Mohammed

Further to your recent posts we have reviewed them and can confirm that we might be able to help but it is beyond the scope of this forum.

We would need to see your working files in order to scope out the work involved to reach a solution. Once we have done this we can relate duration and any costs.

If you would like to investigate this further please let us know.

Kind regards

Jacob

Thu 29 Apr 2010: Automatically marked as resolved.

Access tip:

Changing MS Programs Text Size

A handy way to increase or decrease the size of text in Microsoft Word, Microsoft PowerPoint, Microsoft FrontPage, or Microsoft Publisher, first, select the text you want to resize.

Then, to increase the font size, press CTRL+SHIFT+>.

To decrease the font size, press CTRL+SHIFT+<.

View all Access hints and tips

ID

ID

RE: ID

RE: ID

RE: ID

Access articles

Access tip:

Changing MS Programs Text Size