Normalization of DB Tables (1 Viewer)

MajP

You've got your good things, and you've got mine.
Local time
Today, 11:07
Joined
May 21, 2018
Messages
8,463
TY I'm really going to try not to bother you too much. I think I've bothered you enough in the last few weeks. TY so much!!!!
No problem. However, like I said you have some pretty complicated data relations. This looks simple and straight forward, but it is not. I think this would have challenged most people. So understanding this may take a lot of time. So no issue if you need to come back for explanation.

Just in the calculation of allowable staff credits per waivered site there are three different many to many relationships. That is enough to give anyone a headache.
 

sribblett

Member
Local time
Today, 11:07
Joined
Aug 24, 2020
Messages
89
No problem. However, like I said you have some pretty complicated data relations. This looks simple and straight forward, but it is not. I think this would have challenged most people. So understanding this may take a lot of time. So no issue if you need to come back for explanation.

Just in the calculation of allowable staff credits per waivered site there are three different many to many relationships. That is enough to give anyone a headache.
I wouldn't ever have gotten by just you telling me what to do. I definitely will let you know if I have any more issues. I hope though once I get trainings all in for all staff and if there is a glitch some where (hopefully not) that you can text me through it to correct it. I don't want to redo the training log .... to make it right I will of course if need be. TY again!!!!!
 

sribblett

Member
Local time
Today, 11:07
Joined
Aug 24, 2020
Messages
89
I wouldn't ever have gotten by just you telling me what to do. I definitely will let you know if I have any more issues. I hope though once I get trainings all in for all staff and if there is a glitch some where (hopefully not) that you can text me through it to correct it. I don't want to redo the training log .... to make it right I will of course if need be. TY again!!!!!
I've been put in data and I really love it. It's getting used to how things get done. I'm getting it though. Is there a way I can have Trainings dates go in order: Like newest to oldest or visa versa?
 

MajP

You've got your good things, and you've got mine.
Local time
Today, 11:07
Joined
May 21, 2018
Messages
8,463
Is there a way I can have Trainings dates go in order: Like newest to oldest or visa versa?
You can change the subforms recordsource. Currently it is sorted by name of training. You can sort by date first.
 

sribblett

Member
Local time
Today, 11:07
Joined
Aug 24, 2020
Messages
89
You can change the subforms recordsource. Currently it is sorted by name of training. You can sort by date first.
Everything was going good, but I thought I would number the 9 categories where you add new trainings. So it would be much easier to know the categories for my supervisor to know. When I did this it doesn't show me the hours in the trainings I've entered for staff. I am so sorry, that I cannot figure out how to get the hour amounts back in the credit hours subform. It shows the totals but all 9 categories are blank as well as no credit hours. Can you please tell me what I have todo to get these amount back on?
 

MajP

You've got your good things, and you've got mine.
Local time
Today, 11:07
Joined
May 21, 2018
Messages
8,463
In a cross tab query you can specifically force the column headings. The reason for this is you may want to show a column even if no data exists in that column. If you do not specify the column headings then a blank column is not included. Since you changed the column names they no longer match. You can either delete the Column Headings in the Xtab or make them match your new values. I recommend the latter, but the names have to match exact. In the property sheet it is the 3rd row down. If you delete the headings then each column with no values will not show up and likely to give you an error in the form.
xtab.png
 

MajP

You've got your good things, and you've got mine.
Local time
Today, 11:07
Joined
May 21, 2018
Messages
8,463
In the query you show look at the 10th column onwards. Since you changed the names of the xtab they need to change in those columns.
 

sribblett

Member
Local time
Today, 11:07
Joined
Aug 24, 2020
Messages
89
In the query you show look at the 10th column onwards. Since you changed the names of the xtab they need to change in those columns.
Yes I did finally figured that out. I remembered from working with access before. However, know I have a different issue. All credit hours for the 9 categories all have #Name?. OMG! just by adding that 1 thing - I didn't realize it would've cause so much changing. One good thing in all of this - it's making understanding each step better.
 

MajP

You've got your good things, and you've got mine.
Local time
Today, 11:07
Joined
May 21, 2018
Messages
8,463
On the form itself, the textbox control source still references the old name. You need to reference the new name.
 

sribblett

Member
Local time
Today, 11:07
Joined
Aug 24, 2020
Messages
89
TY so much!!! Everything all good again.
I thought all was good. However, I see on the same form the totals are very large for staff. The numbers are in high hundreds and thousands. What can I do to fix that so it shows just that staff's total.
 

MajP

You've got your good things, and you've got mine.
Local time
Today, 11:07
Joined
May 21, 2018
Messages
8,463
That sounds like instead of breaking it down by staff it is showing the total for everyone. Verify that the subform's record source is "qryCreditTotals" and not 'qryCreditTotalsPerSite". Without seeing the db it is hard to guess.
 

Users who are viewing this thread

Top Bottom