I am not sure where to begin with the question. So I will begin by trying to describe what I have and what I need. I have a table (tblSpotter) with Info about people, i.e. First Last Name, address, phone, etc. I have another table (tblStormVer) that List phone calls received. The idea is that I would like to keep a log of the phone calls that I receive from the individuals in the first table. In the tblStormVer table I have Contact_Moment (an autonumber), call_datetime (current date/time), Remarks, First Name, Last Name, In-Out (whether the phone call is incoming or outgoing).
Now what I would like to do is Link the First and Last Name data in the tblStormVer to the First Name Last Name data in the tblSpotter table.
Ultimately I would like to be able to create a Report (that includes much of the data from the tblSpotter) sorting out records from the current day or current week or last week, etc. Not sure if I described this well enough, if not please let me know and I will attempt to do a better job. I have a basic understanding of Access but this has me scratching my head. Thanks in advance for any assistance. I can upload data if that will help.
Now what I would like to do is Link the First and Last Name data in the tblStormVer to the First Name Last Name data in the tblSpotter table.
Ultimately I would like to be able to create a Report (that includes much of the data from the tblSpotter) sorting out records from the current day or current week or last week, etc. Not sure if I described this well enough, if not please let me know and I will attempt to do a better job. I have a basic understanding of Access but this has me scratching my head. Thanks in advance for any assistance. I can upload data if that will help.