Here are the requirements for this database, it has to be able to display all contacts with all amateurs anywhere in the world. I feel the terrain table will be. This table, which will be called contactT this will hold most of the information such as date, time, call sign strength of the signal. How clear the signal was there will be two fields, one called R another one S the record Wyman for this database will need to be able to get information such as first name last name from a table called fullinformationT which will hold first name last name, address details through several fields. Here is the way I see it offhand

The database will have to be able to filter contacts for each person from the in the form for addresses so this will be able to shoot look up that call sign, then it will show all contacts I had with that person over different bands

Will continue in the next message

The main table which will be the table, which is used to put all details of the contact in will have following

1 date
2 time
3 call sign
4 Frequency
5 strength
6 readability (how well I could hear the other station).
7 comments
8 QSL Sent
9 QSL Received


The secondary table will have the following

1 First name last name
2 address
3 suburb
4 city/town.
5 Region.
6 country

I will need to design a query to put the first name and second name in the main table using String Concatenation

I would appreciate any feedback on how to improve my goals in any help at anyone would be willing to offer but that's the basic layouts I can think of at the moment, there will be picture fields put in showing a picture in everybody's table which holds details of the address ETC.

Thank you in advance.

Michelle

Relationships
Access Expert Level 1

I recomend to start here this will provide a guid to where you will need to go.  After the videos if you still have questions come back will be happy to help some more.

Thank you very much. I'll be back as soon I run to trouble which I'm sure I will as queries are not my strong point, I have built one database way back. 2010 time error so I have forgotten quite a bit. I've got all the lessons right through to some of the developer which I haven't really watched yet but thank you all Michelle ZL4VGV

Michelle, I know and understand what you are trying to accomplish.  My amateur radio call is NC9W.  There are numerous points to consider, even with the basic info you have provided so far.
(1)  As I mentioned in your other post, I would combine the two tables into one.  One reason is that over time, a callsign can be assigned to a different person/entity.  You would want to keep the name and address for that particular contact.  For instance, here in the States, 1x1 callsigns are routinely assigned for a short period of time (even days or weeks).  So if you worked K1A on 1/1/2024, for instance, on 1/3/2024 it could be a totally different entity.
(2)  Items 5 & 6 on your main table should be changed to reflect RST-received and RST sent.  Then is CW you could enter 599 (or whatever); for SSB 59 (or whatever); for SSTV (whatever signal report you're using); etc
(3)  Include a field for the Operator's name (the name of the operator you worked).  You could be working a club station, and the op's name could be different than the name of the station associated with the callsign.  Also, many hams use their nicknames and you could use that field to hold that info.
Hope this helps a little.

Hello Paul, I was going to put operators name in must have missed that in the message. Good point that call signs can be reallocated, but saying that the waiver database. I am thinking of is there will be that table which will sort by callsign and name but I'll put that down on my list to do. Thank you. As nice to talk to another amateur may be. We may contact each other sometime in the future. Hopefully I'll be up on HF By the end of the month, but only on 20 m at the start and going down to 10 mEventually when I get the intent is up don't have much room to put anything outs up. But thank you for your feedback. If you feel comfortable talking to each other by email or messenger looked me up on messenger. If you would like 73

If your call signs can get reallocated, then definitely do not use that as a primary key. I recommend you always use an autonumber for your primary key. What you could do is in the user record, store a begin date and an end date for that call sign. That way, in the future, you can look up who had the call sign on whatever date. So, if it gets reassigned, you'll know who it was.

Can anyone tell me if you know where Richard put the information on UTC time. Better still using what was shown in the extended cut. I am no longer a member of the extended cut will be coming a member again when I require more assistance, but because of converting New Zealand dollars into American dollars that does make a big difference in price for me and I've had a few big expenses

Hello Richard, I deftly was not going to do that anyway use primary key as a way identifying call sign the table ID would have been used to connect different items good suggestion Would you store the callsign in the callsign is in the table which is now the main table which holds all the information about the contact but eventually this will be linked to a table with full details of this person. You could say contacts and customers whether contacts are the contacts I made in the customers would be their full information as shown in your beginner course so any suggestions how to do this would be gratefully appreciated. Richard you drove this into me from day one. Never use any thing but the table ID is the primary key

Richard show how to get the UTC time in this lesson.
Daylight Saving Time

Thank use Sandra still not sure if this will do all the functions I need you may know more. The situation is because I am running on a 24-hour clock and with being 12 hours ahead of UTC at the moment. Yes, this would change the UTC time but would it let me put the date in differently because the date needs to not kick over to the same day as myself until midday, but I appreciate you pointing me to this video. I have bookmarked it ready for when I am ready for actually doing it

Wondering if anyone could tell me where I could get the video to gget the coding for uppercase display as I don't have to do put things in L automatically or displayed on uppercase because call signs are always displayed on uppercase hope someone may be able to point me in the right direction. And if so, if over tell me where the coding goes e.g. in the table or form. Thank you

Change Case

Thank you Kevin

Hello Kevin, I have had looked at that video if I'm correct, I may have, to make a query to feed a certain field as I want really to be able to type in lowercase and it will automatically change to uppercase in my misunderstanding uppercase command
thank you

Can anyone help me with this error when I try to type a date in this error comes up

Just in case I didn't make it clear this field is a date, time, field I'm trying to put it in as UTC time, e.g. 1455 four 2:55 pm. Have I got one of my settings wrong for the date, time

You need the colon or you need to do this: Military Time

In the future, new questions = new post. Otherwise these threads get way too long. Thanks.

Michelle, My name is Jerry Fowler. I am a retired SQL Database Administrator, but nowhere close to the level that these fine people are on Rick's team. I have time on my hands and am willing to collaborate with you on a 1 on 1 basis. If this project is for your personal use I do not expect any monies to cross.  Just willing as I can, to help you out.  I am in the US in Illinois so that makes me 6 hours behind in UTC time. Also I only speak English if that will be an issue. We can talk over Google Meet or similar. We can ask Rick how we could give each other our email addresses.

Hello Jerry, that would be nice. Yes, it is for personal use. I may handed out to people in the future. For a small charge. If as alterations need. Mick done more than minor alteration such as callsign changed on the form. Would you approach Richard to talk to him about us working together. I would prefer using messenger as I am familiar with that and I can easily send you a copy of the database. One of thy requirements. I have come up with, which was not listed as old need to track everyone who has held other callsign for instance, my callsign is ZL4VGV one day someone hours they have had that callsign so I need to track this as it shows up on a separate form so as you will know from Richard. Never use the same fields twice. I'm just trying to figure out around how to do this when the purpose of this databases track people I've spoken to so need to work out a way of putting it together in a separate form and table for everyone who is held that callsign please get back to me. Thank you

Rick, how would you suggest I get my email address to Michelle? I don't want to break any rules

Thanks

That's perfectly fine with me. I'll send an email to both of you with the others' contact info so you don't have to post them publicly.

Thanks Richard, we'll keep you posted how it is going.