Search results for query: *

Ok, I'm not sure what happened to my first thread, but I am going to post again. I currently am using the Date diff formula to get the age of patients. =DateDiff("yyyy",[DOB],Now())+Int(Format(Now(),"mmdd")<Format([DOB],"mmdd")) This displays the age of the patient in years, so if the patient...

Thank you so much, I have gotten it figured out from there. Now I'm having trouble with a separate issue and will post a separate thread about it. Again, I really appreciate your help on this.

I'm running into trouble using the union query because it will just pull out the name of the patient (whether first or last) and doesn't actually pull out the number of each immunizations given during a specified time. Please keep in mind that I'm a beginner in even using coding to assist with...

It seems that I was very wrong about being able to figure out how to sort/report based on the date and get the number of each immunizations given in a certain time frame. If you (or anyone on this forum) can offer me help with that, I would greatly appreciate it. It just wasn't as simple as I'd...

Ok, I got it now. Thank you!!!!!!

Thank you, it seems like it will work. Although, now that I have split up patient name into First Name and Last Name columns, I am unsure of how to put that into the simple totals query. I would definitely appreciate your help in rewriting that code to include the two columns. Thanks again!

Sorry I didn't include the information about the dates, because I thought it would just complicate what I am trying to learn on this forum, and that I would be able to figure it out on my own later. I have attached the link to the Access DB. I have not done much with the DB, because it will not...

While the patients will be recorded in the record, the most important information is which immunizations are given. At the end of the month, or another specified time, I will need the total of each immunization given. This is sort of like an inventory per month. Preferably, there would be a...

Maybe I am just missing something, but I am still unsure of where to put the =Sum(Abs([YourYesNoFieldName])). You say in the control source, but is this while I am in a query or is this just straight from trying to create a report?

Hi, I am new to this forum and was hoping that someone would be able to help me with my Access issue. I have a form/table set up to count the number of immunizations are given. The immunizations are set up as checkboxes and I need to be able to count the number of each separate immunization...