Bantam
June 1st, 2004, 10:19 AM
Access queries are the pissiest things I come into contact with. *vent*
Can anyone give me a quick fix for retarded situations like the following:
We have a database that keeps track of people attending one of several yearly conferences. The partial list of tables include: Payments (includes a field for which year and which conference that payment is for), Registrations (tied to a specific year, person, and conference), and an actual Contacts table with all personal info.
Registrations are from several different years for seven different conferences (Labeled 1 through 7).
I have a query that looks for a list of people from Conference 4 and payments for that year, for that conference.
I want to set a filter in Access so that ONLY people that are attending conference 4 show. I want ONLY payments for that person, for that year, for that conference to show.
Access just frigging loves to include all payments from someone even if those payments are not from that year or that conference. Or maybe it'll just skip the person entirely because they have 1 payment for another year and that doesn't fit the criteria.
This bullsheeeit happens all the time in access. I'm about fed up with it and I'm really pissed. Does anyone have some pointers? Do I have to post my actual queries? Can I get a couple of samples from people that are getting it to work?
-Thanks
Can anyone give me a quick fix for retarded situations like the following:
We have a database that keeps track of people attending one of several yearly conferences. The partial list of tables include: Payments (includes a field for which year and which conference that payment is for), Registrations (tied to a specific year, person, and conference), and an actual Contacts table with all personal info.
Registrations are from several different years for seven different conferences (Labeled 1 through 7).
I have a query that looks for a list of people from Conference 4 and payments for that year, for that conference.
I want to set a filter in Access so that ONLY people that are attending conference 4 show. I want ONLY payments for that person, for that year, for that conference to show.
Access just frigging loves to include all payments from someone even if those payments are not from that year or that conference. Or maybe it'll just skip the person entirely because they have 1 payment for another year and that doesn't fit the criteria.
This bullsheeeit happens all the time in access. I'm about fed up with it and I'm really pissed. Does anyone have some pointers? Do I have to post my actual queries? Can I get a couple of samples from people that are getting it to work?
-Thanks