By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,327 Members | 1,805 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,327 IT Pros & Developers. It's quick & easy.

Show certain records in 1 table - yet able to add new.

P: n/a
This may have been missed, so I appoglize if I am reposting this. (I
also want to thank Larry and James for their previous help)

All,

Table1
Field1 Field2 Field3 Field4 ...
RC1: MedRec1 SOCDate1 CertDate1 Memo1

Example:

RC1: MedRec SOCDate CertDate Memo
100 01/01/05 01/01/05 1stCert Period in 2005 for MR100
100 01/01/05 03/01/05 2ndCert Period in 2005 for MR100
100 10/01/04 10/01/04 1stCert Period in 2004 for MR100
100 10/01/05 12/01/05 2ndCert Period in 2004 for MR100
103 02/01/05 02/01/05 1stCert Period in 2005 for MR103

Output (perhaps via VB?), shows only:

RC1: MedRec SOCDate CertDate Memo
100 01/01/05 01/01/05 1stCert Period in 2005 for MR100
100 01/01/05 03/01/05 2ndCert Period in 2005 for MR100
103 02/01/05 02/01/05 1stCert Period in 2005 for MR103

P.S.: I will need to be able to add records in the form after the
output as well, therefore, filtering may not work (i.e. inner joint may
not work, right?)

If I had known this DB is going to transform into this, I would have
split this into 2 tables to begin with. Then, we won't have any
problem. I hate to have to go this route right now.

Thanks in advance,
Perry

Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.