Art- Are you sure that first query gets you the number of people in each household? That would seem to count the households that have all applied under the...
Thank you very much for your help Mr.Viescas. The `lbl50' and the `line50' won't display until I added the line "intG50 = False" after the Else statement....
Yep!!! I duhhed it. THat works great.... ? What can I say, its Sunday and I am working. :) With warm regards, Arthur Lorenzini Sioux Falls, South Dakota ...
Hy Clive Thank you for your attention. I can't understand these conditions: "AND [nom_desc] = [tbl_med].[nom_desc] AND [nom_apres] = [tbl_med].[nom_apres] AND ...
John, Those numbers are coming from my household member table. There is only one household per application. I have to include the application table so I can...
Phucon- It should work with the code I gave you, assuming intG50 is declared at the module level. Option Compare Database Dim intG50 As Integer Private Sub...
Candrope- No, they're simply a filter on the subquery. The WHERE Clause of the outer query has this subquery: WHERE tbl_med.[nom_lab] IN (SELECT [nom_lab] ...
The tblApplicationHousehold is counting individuals in the household. Â This is the structure for tblApplicationHousehold: Â HouseholdID ApplicationID ...
I've just started working with a new client. They have a database created by self-taught users. It's been in use for many years. It's used by one person in the...
Sigurd- Replication has been "deprecated" – that means MSFT gave up supporting it. It's full of bugs, and isn't recommended at all. Which user has the...
It's not finding Sum(tblApplicationHouseholdIncome.IncomeAmount*12). Doesn't the tblApplicationHouseholdIncome need to be joined? With warm regards, Arthur...
It's not finding Sum(tblApplicationHouseholdIncome.IncomeAmount*12). Doesn't the tblApplicationHouseholdIncome need to be joined? With warm regards, Arthur...
I made the join and the qryHouseholdIncome is working. I do have another question. When I run the query I see a few records that are over $100,000 and I am...
Art- Tough to say. You could decide on a threshhold amount, perhaps $2000, and avoid the multiply. What's the SQL of your "fixed" query? It would take an...
Art- It's a simple matter to insert the expression I gave you: SELECT tblApplicationHousehold.ApplicationID, Count(tblApplicationHousehold.HouseholdID) AS...
John, Perfect as Always. With warm regards, Arthur Lorenzini Sioux Falls, South Dakota ________________________________ From: John Viescas <JohnV@...> To:...
I've only had preliminary conversations with the new client, but my understanding is that there's a "replication master" in Canada which is used to coordinate...
Sigurd- If the Master is not corrupted, then rebuild two copies from it and give them to the two users should be the first step. You can sort out the rest...
John, I'll need to have a strategy for synchronizing the two copies before I do as you suggest. The link you provided in your earlier reply was to information...
Sigurd- If the two users have synchronized with the master, then use the master to create two new replicas and have the users replace theirs with the new one. ...
I have been working on a few custom ribbons and it has been going surprisingly well. I now have three custom ribbons that work exactly like I want them to. I...
So you're suggesting this as a way to get past the "Repair" on starting the DB, not as a first step to getting rid of synchcronization? Sigurd ... [Non-text...
Yes. You'll have to know more about their network setup before you can suggest any alternative. John Viescas, author Microsoft Office Access 2010 Inside Out ...
I thought I'd ask this as a separate thread as the focus is not quite what my recent question (about a "Repair" every time a DB is opened). If I were to...
Sigurd- I have no experience with either offer. They both look interesting, and it would be worth scoping out the pricing. You haven't mentioned the version...
The EQL offering is "$35/month for 1 user at a time" (http://eqldata.com/kb/1074/pricing). As I understand it, once you've installed their MS Access plugin and...
