Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Showing results 1 to 9 of 9
Search took 0.01 seconds.
Search: Posts Made By: sprion
Forum: Access January 13th, 2005, 09:31 PM
Replies: 9
Views: 1,692
Posted By sprion
haha .. ok how about the FIRST NOK listed for...

haha .. ok how about the FIRST NOK listed for Jack only .. instead of 3 ?
ANy ideas?
Forum: Access January 12th, 2005, 01:04 AM
Replies: 9
Views: 1,692
Posted By sprion
Very nice SerranoG, I haven't tried it but I...

Very nice SerranoG, I haven't tried it but I assume it should work.

Actually though, I'm hoping to see some SQL statements instead :)

Also, I think I need a random NOK of Jack's to be used,...
Forum: Access January 10th, 2005, 08:49 PM
Replies: 9
Views: 1,692
Posted By sprion
ahh .. i get it .. these is wat i should provide...

ahh .. i get it .. these is wat i should provide :X

[personnel table]
[SocialID] [Rank] [Name]
8403213D PTE John
8401234A MSG Dick
8404321B BG Tom...
Forum: Access January 10th, 2005, 12:35 AM
Replies: 9
Views: 1,692
Posted By sprion
SocialID Rank Name [NOK Relationship] ...

SocialID Rank Name [NOK Relationship] [NOK Contact No.]

8403213D PTE John Mother 93213343
Forum: Access January 9th, 2005, 10:08 PM
Replies: 9
Views: 1,692
Posted By sprion
Distinct or Group By?

8403213D PTE John Mother 9123456
8403213D PTE John Father 9321323
8403213D PTE John Sister 9111111
8221234Z MSG Dick Spouse 8321345
8323157G BG Tom Daughter 9236579

These are the current...
Forum: SQL Language January 6th, 2005, 01:02 AM
Replies: 5
Views: 827
Posted By sprion
Hi, yeah I'm using ACCESS, thanks again.

Hi, yeah I'm using ACCESS, thanks again.
Forum: SQL Language January 6th, 2005, 01:01 AM
Replies: 5
Views: 827
Posted By sprion
Hey thanks for replying.. I had used the "Ranking...

Hey thanks for replying.. I had used the "Ranking Table" so that the personnel queried from the MTL records can be arranged in order.

I wanted personnel of higher ranking to be at the top when...
Forum: SQL Language January 5th, 2005, 09:08 PM
Replies: 5
Views: 827
Posted By sprion
How do you query this complicated thing?

The Tables

MTL Table

--------------------------------------------------------------------------------

NRIC RANK NAME
8401234A PTE John
8321321B SGT Harry
3213121Z ...
Forum: Access January 5th, 2005, 06:38 PM
Replies: 1
Views: 996
Posted By sprion
Just how do you do it? Complicated!

The Tables

MTL Table

--------------------------------------------------------------------------------

NRIC RANK NAME
8401234A PTE John
8321321B SGT Harry
3213121Z ...
Showing results 1 to 9 of 9

 




Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.