Search results

Well, linking your subform on Weekday so you're right that won't work. Since you are showing all the Students why are you linking those Forms? That said, if you want to store which Students attended sounds like you are going to need an update query. Also, the Sessions subform should not be on...

So the Staff log on and see there Sessions? If so then why not show the Students attending that Sessions? Or do you just want to who all the Students?

Hmm, not getting it. Do students sign up for these classes? Because it seem to me you pick the Staff Member and then the Session which should then show the Students signed up for that Session. You can then enter the date and check off those that are present.

Hmm, might also help if you post the Function.

-2 🤣

Hmm, too much information :LOL:

I got excited about Power App's for all of a hot second then came the cost and what it couldn't do that Access could do but that was back when it first came out. Be interested to see if it *grew up*.

Considering one is now in college I feel I am in a good position.

Hmm, I am hopeful that there are great grandchildren in my future so the learning\teaching continues.

Hmm, watched Sharknado with grandchild then gave her a lesson about tornado's and hurricane's after I got asked "Can that happen?". Another grandchild asked "Where does Godzilla live?". Yep, learned all about dinosaurs and why those, on TV, don't live and technically, that one never lived...

You know for a minute I thought that reply was from someone else. :unsure: Nope, not helping retarded people, only helping people willing to learn from the mistakes I ALREADY made many moons ago, And this is my break in between writing Functions.

Correct or run an update query for the States. Also, view it before you actually append it.

Not sure I understand you appended the Churches and then appended the States. You should append the Churches and then UPDATE the State based on the Churches. Appending is adding so when you *added* the States it created duplicates.

Hmm, well going to need to see the SQL of the append query to determine why the record count difference and the other differences. (May be mute if you do the below.) As for the ID's if you are using the Autonumber field in your table they will not match ,y table and you shouldn't try to...

Others may disagree but I would NOT do this in Access unless I was using a backend with some serious security. So, yes I would look into some external service. I would them log in to some website that handles these types of transactions. You do not want to be responsible should their...

Nope, not stupid, been there and done that. ;) Get some sleep or some coffee... your choice.

Did you just drop them in the window? Where is the JOIN?

Have a look at... https://www.fmsinc.com/microsoftaccess/query/crosstab-report/index.html

I would say it what you are joining on (or not joining on). Please post eh SQL of Query 3.

I think I covered that in the *Starter Kit* I posted. In tlkpServices you have Sunday School or Wednesday you can select from and then once selected you can enter the Time for that Church also allowing you to select a Service multiple times as there may be more than one Service Time on a...