sueb
Last Activity: Sep 29 '11, 07:37 PM
Joined: Apr 24 '10
Location: Ventura, CA
-
Clarity is the key, isn't it? So thanks for sticking with me until I made sense! -
Oh! See, I didn't even know the "GroupBy" and "Count" options were available except in a Crosstab query!
Thanks, nico5038! This is perfect now!Leave a comment:
-
(Oh, and just as an aside, "two contacts of the same patient with the same social worked counted for one" is exactly the result I'm going for!)Leave a comment:
-
The thing about that is that I don't know what to put in the Value entry. I'm really only interested in date and unique patients, so what's the "value"?Leave a comment:
-
How can I count unique values in a report?
I have a very simple, flat database [Contacts] that has, basically, a date of patient contact [Contact Date], the identification of the social worker who contacted the patient, and the medical record # of the patient [Patient MR] (along with some notes about the contact).
I want to create a report that displays a line for each month (of a specified period) containing the month/year and the count of patients that were contacted (as... -
I guess I assumed that the SQL I posted was clear--my apologies.
But thanks for the fix, anyway!Leave a comment:
-
NeoPa, by "third field", I just mean another of the Long Integer fields.Leave a comment:
-
They certainly could be....Leave a comment:
-
How to update one field by summing two other fields
I have a table with some number fields in it, and I'm trying to write a query (an extremely straight-forward one, I thought!) that will add together two of the fields and place the sum in a third (all fields are Long Integer). Here's the query I currently have:
I get no error, but the third field remains blank. What's going...Code:UPDATE [ACE Volumes] SET [ACE Volumes].Approved = [Ace Volumes].APP+[Ace Volumes].NAN;
-
Okay, will do--thanks!Leave a comment:
-
Am I able to create queries on the fly? I'm thinking of the day when the user creates a new Hospital Category; it would be lovely if the code could just handle that.Leave a comment:
-
OMG, so that's what's missing! Yes, in the original database, there are a slew of queries named exactly this kind of thing! Lovely--I'll just copy them all over. Thanks, NeoPa!
(the dawning of that particular light was more of a lighting bolt--almost gave me a headache! :D)Leave a comment:
-
Okay, since it looks to me like I've defined an object called queryname that has a value of "qryEmergen cy", where in the database do I need to create the QueryDef object, and how do I do it?Leave a comment:
-
When I set a break at line 18, queryname = "qryEmergen cy", which is what I would expect, and Sort = " ORDER BY [DSCHRG_DT] ASC, [ACCT_BAL] ASC, [PAT_ACCT_NBR] ASC", which is also what I would expect. However, qd = Nothing -- does that seem quite right? When I hover over qd.sql in line 19, it says "qd.sql = <Object variable or With block variable not set>". Does that just mean that .sql hasn't been set yet? Or does...Leave a comment:
-
Well, my form does have all the combo boxes referenced in the code. I couldn't copy the whole form (attached to my original post) from the original database into mine, but I could (and did) copy the combo boxes into a new form in my new database. All the properties copied, so I assumed that the code would work (certainly at least to the point of being able to create the query).Leave a comment:
-
Let me apologize, starting off, for not having had time to do my homework with the filtering example you posted, NeoPa, but maybe you'll be willing to clear up this one thing for me anyway.
I'm borrowing some code from the original database, but I'm getting an error that I don't understand. Here are the lines of code in question:
...Code:Dim DB Dim qd As DAO.QueryDef Dim Sort As String DimLeave a comment:
-
Thanks! You're the best, NeoPa!Leave a comment:
-
I still can't access that page today, and I'm not allowed to use another browser here at work. I don't suppose you could sort of paste the gist of it in a message could you? Or maybe email it to me or something?Leave a comment:
-
I thought I'd just check out that thread now, even though I can't start on it yet, but something must be wrong with the link or page or something cuz I get an error every time I click on it.Leave a comment:
-
Thanks for this, NeoPa! I certainly will dive into this this evening after work, and will report back (of course, you know I will, since there will be further questions! :D)Leave a comment:
No activity results to display
Leave a comment: