Search results

Thanks for the quick response. How would I enter that in design mode without using VBA? Sorry, I'm a noob when it comes to VBA and SQL. :p

Hello - I know there are a ton of threads about age, and I did read through several, but the most common answer isn't working. Everyone here has been extremely helpful in the past, so I'm hoping you can help me here. ^_^ I have two update queries to return a person's age at the beginning of...

It's working! I started out with the response in gray below and then decided to try adding the CrtTable back into the equation since the BaseTable and CrtSubTable weren't joined together, which negated my response. It's working across the board and looks great. So this is what I wound up...

I just thought of something. I don't need to use Quarter in the query at all. All I need is for the date I'm looking for to fall within the dates I specify on the report form, that way I don't need to look through both the last and current quarters.

LOL :D Will post the database later this morning. Ok - it's later! Here it is. There are a few dummy files to work with. Let me know if you have any questions. Thanks again!

I'm near the U of I's Champaign Campus. I'm off work in little while so I will clear out a dummy database and post it tomorrow. Thanks!:o

Hello Again! First I just want to say thanks to everyone because you guys are great and have helped me with more than one database. Now for my problem... I've been searching the forum and reading a lot of the posts about how get the most recent date from a query using Max. My problem is that...

I'm sorry I never posted back - I ended up adding another field that always equaled 1 and then used Sum to "count" those instead. DCount just wouldn't work, no matter what I tried. Thanks for all your help!

Update Added Later: I abandoned both of the COUNT functions and created a work around for SUM. So far so good. If I experience problems with it, I'll post again. Thanks for all your help. I have no idea why the count functions weren't working properly, but at least SUM is getting me...

I've toyed with the fake data to check those out and they don't count correctly either. The Prairie Center control is just the one I've been working with the most. For some reason, it seems to disregard the ID #'s when counting the fields. I'll try to export and see if that works.

Ok, here is the zip file. There is only the one report and one query right now since I needed to get this figured out first. ;)

Yes. I'll have to check to see if this pc has it. (it is the work pc). In the meantime, maybe this will help: Service Provider control is in a table called “BaseTable” and one example field is [Prairie Center Qrt Cent]. There are seventeen in all, but on any one report, only up to ten will...

This is probably a dumb question - how do I do that? :) I've uploaded pictures and videos, but never a document-type file. I appreciate your help.

Yes Recidivsim is a seperate field in a seperate table. I've tried DCOUNT, but can't get it to work. For some reason it is counting all of the records in every instance, disregarding checked boxes and record ID #'s.

Hello! I did a search and can't quite find what I need. I've put together several databases, but still consider myself a novice. I don't know any VBA or SQL. I have a report based on a query and I need to calculate recidivism totals based on checked boxes for service providers. Example...

I did a search and read through the other threads, but I'm not sure if they'll help me or not since this is new to me, so sorry if this is mere duplication. ^_^ I tried to repair and compact one of my databases this morning and then noticed that this table appeared. In it it says -...

Don't know if it helps at all, but I noticed that sending reports in Rich Text Format makes them less chaotic. The formatting just needs to be simple in design.

I am looking for something similar to this, too. I have a field for email address and want Access to pull the address to send an email at the click of a button without having to type the addresses in. Is this possible? I don't know VBA or any code, so I'd have to be able to do with queries...

Hi - I've been searching the net & MS's site for about an hour and can't find what I'm looking for. Maybe I'm not phrasing it right or something - please help! ^_^ All I want is a list of the commands under the Run Command option that explains what each command does. I can't find stuff in my...

This is something I need, too, but the cycle suggestion isn't working. In the events for On Current I have a maximize macro, would that be keeping the focus off the form? I don't really know VBA at all, so I hope there's something I can do outside of that. It's not that the form is lengthy...