473,320 Members | 1,854 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Looking up redundant occurences

I have a progress note table where a person's social is entered, the
current date and then the note. I can have serveral notes entered
under the same date and I can have several notes entered on the same
social. My question, how do I lookup and display a certain note based
on the social and date of the note?

03/09/06 999-99-9999 Note
03/09/06 222-22-2222 Note
03/10/06 222-22-2222 Note
03/10/06 999-99-9999 Note

If I base the lookup on Date, it pulls the first occurence of the date.
If I base it on social, it does the same. How would I display the
note of 03/10/06 for 99-99-9999?

Thanks!

Mar 10 '06 #1
1 1344
As you have not, exactly, defined what you mean by "a certain note", I doubt
anyone can tell you in detail. One way that can be done is to enter the
Social Security Number and display a list of Notes in either Ascending or
Descending order by Date, from which the user can pick one.

The _specific_ date in your example could also be retrieved if you either
specified or had a rule that you were going to retrieve the most recent note
for the person identified by the SSN.

Larry Linson
Microsoft Access MVP

"Ryker" <ra*****@choctaw.org> wrote in message
news:11**********************@e56g2000cwe.googlegr oups.com...
I have a progress note table where a person's social is entered, the
current date and then the note. I can have serveral notes entered
under the same date and I can have several notes entered on the same
social. My question, how do I lookup and display a certain note based
on the social and date of the note?

03/09/06 999-99-9999 Note
03/09/06 222-22-2222 Note
03/10/06 222-22-2222 Note
03/10/06 999-99-9999 Note

If I base the lookup on Date, it pulls the first occurence of the date.
If I base it on social, it does the same. How would I display the
note of 03/10/06 for 99-99-9999?

Thanks!

Mar 11 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Cam Bevis | last post by:
I'm having trouble getting my head around this, and no one in the groups has posted exactly the problem. The table below tracks site traffic across a network. There is 1 row per pageview and...
1
by: AstroFred | last post by:
hello, how can i sort events in mdb database in order to display the most frequently events in database ? (count the occurences of a field) for example : 28/12/2004 08:18:14 U_D671/FC667...
14
by: Ian Pilcher | last post by:
It's pretty common to see declarations such as: static volatile sig_atomic_t caught_signal = 0; C99 defines sig_atomic_t as a "... (possibly volatile-qualified) integer type of an object that...
4
by: Jason Gleason | last post by:
What's the most efficient way to get the number of occurences of a certain string in another string..for instance i'm using the following code right now... private int CharacterCounter(String...
40
by: Neo The One | last post by:
I think C# is forcing us to write more code by enforcing a rule that can be summarized as 'A local variable must be assgined *explicitly* before reading its value.' If you are interested in what...
4
by: Dameon | last post by:
Hi All, I have a process where I'd like to search the contents of a file(in a dir) for all occurences (or the count of) of a given string. My goal is to focus more on performance, as some of the...
7
by: shubharamaswamy | last post by:
Reading standard input and printing the number of occurences of each letter in graphic format as follows: a: ..... b: .. . . . z: ... where no. of dots= no.of occurences
3
by: Gilles Ganault | last post by:
Hello I'd like to make sure there isn't an easier way to extract all the occurences found with re.finditer: ======================= req = urllib2.Request(url, None, headers) response =...
2
by: kasala | last post by:
I get an xml document as input from other department. The input xml document i recieve has a particular word "rnx" which should not be there and my system doesn't support it. And there is also...
18
by: Neehar | last post by:
Hello For one of the interviews I took recently, I was given an offline programming quiz. In 30 minutes I had to write code in C++ to counts the number of times each unique word appears in a...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.