Search results

I'm really sorry, I'm just not following you. I tried putting that into the SQL view but I'm not understanding the output. I did... this (photo attached) and now I get a count of the number of patients per county. I think I can use that with =Count(*) and do the math, right?\ Edit: Alright...

Not really. I think you've got me on the right track though. Crosstab query maybe? This is not elegant at all, and I suspect this is entirely the wrong way to do this. So I created crosstab query. On the left I have the counties, then the heading is PatientID. It's giving the right number in...

Would that only work for one county? Ideally I'd like to have all 4 counties and their percentages of total patients in a single report/page. Edit: Looking at my original post I see I said "just one county." My bad. I'll edit the OP and try to word that better.

Sure, here's a pic of the relations in that query.

Okay, I know this has got to be easy. I'm just in a sleep deprived state and I've hit a wall after designing reports all morning long and huffing insecticide. I've tried searching for what I'm missing, but I'm even having trouble explaining what it is I want, let alone coming up with the...

I'm not sure you could have made a leap to that from where I was. I was asking how to create the list of emails, not make an easy way to send emails. Or maybe you did and I missed it. Now I only have one more thing to figure out and this database is complete.

Oh, alright. Thanks Minty, that link made me understand what it was Ranman256 was saying. I don't know why that didn't occur to me while we were planning out the database. We probably just saw that multi-value was a thing and thought it would solve that problem for us. Oh well, we have our...

Well, I feel downright a fool. A team mate figured out how to do a mail merge. This is actually far better for our client because they can make a news letter in a word doc and then send it to the emails selected from our database. For anyone that comes across this, we have an on click event...

The first one, that initiates from within Access. Even better it looks like we can fill out BCC instead of To so that we aren't exposing their addresses to others. If I run into issues with Allen Browne's code I'll come back, but I think you just saved our bacon on a prototype deadline sneuberg!

Oh jeez, I totally misunderstood. I already have a query that just returns two columns, EmailAddress where EmailSolicit=yes. I should be able to take that code and just run it through that query and give me the email addresses separated by commas or semicolon. The only question then is the best...

It looks like those links for the email thing are to let outlook initiate either inputting data or pulling data from Access. Is there a feature in Access that would interact directly with Outlook in that manner to fill a To: field? I had glanced at the Allen Browne link earlier and could not...

I'm working on a pretty simple database, and one of the features we're looking to implement is creating a distribution group for email. When entering an individual into the system there's an entry for their email and then a binary option for if they want to receive emails from our client. I'm as...

Is that the phenomena where the entries on the table expand to show their relations? I wasn't seeing that after building those relationships. I did find a way to get what I wanted, and I meant to post it on here before getting to bed, but it was already 3 in the morning. What I did was break...

I'm working on a school service learning project in which we are creating a simple database for an organization that provides support to family's that have children with diabetes. They are interested in demographics in terms of where these kids are which is simple enough to handle with a query...

Hi MAHC, I'm attending school for networking/security and have had to take a few courses on MS Access. Unfortunately the classes haven't taught me much of anything. I was thrown into a service learning course where I need to create a simple database for a customer, and I've run into an issue...