Recent content by dbero

I apologize Skip. I do not have a calendar table. And must admit have not seen one. What is a calendar table?

Thank you Andy. If I'm not mistaken this would work to count each person upon entry. I need the ID counted for each month between the begin and end date range. So each person is counted in multiple months, depending on their duration.

Thank you Skip. What I need is to illustrate for each month, how many were in care. So, a person id would be counted as a person each month they are in. If they do not have an end date, I would use current date for the end date. In the strategy above, I would have to rest month value for...

Unfortunately I am at home today and don't have access to the db. But what I tried doing was the point in time, which isnt great but easily doable. I also tried the between function in a query as well as datediff. I was thinking the only way to do this is to use vba to write out to a table...

I need to identify how many folks were involved with our service each month. What I have are three elements; Person ID - 233358 Legal Status Begin date - 1/1/2012 and Legal Status End Date - 3/30/2014 for example. What I need to do now is count the folks that were engaged with the State each...

I am trying to open an ADODB recordset in a form and order by two elements, but it won't let me. It will order by one element, but not both. Any suggestion on how to modify the SQL in the form to sort by ARP ID first, then begindate? Dim OpenLegStatSeq As ADODB.Recordset Set OpenLegStatSeq =...

Thank you very much. i will give that a try tomorrow!

[highlight #FCE94F][/highlight] Hello, I have a table that has test results in it. Each question is a column, and each row is the demographic/date information. It basically looks like this. Name TestDate Question 1 Qestion 2 Question 3 Tom 3/15/2013 Correct Correct Fail...

Ihave several groups in a report. the records in each group vary, but the basic report groups fine but when it goes to a second page, the group does not display for the items that carried over from the prior page. Any way to make relabel the group on subsequent pages? thank you very much,

There may or may not be a record for each month. what i have are hundreds of names with various beg/end dates, and I want to write to another table each person and a record for each month of their beg/end period. For examplel, if Mike is in from jan - march, i want to load to a table the...

If I have a start date of 1/1/2013 and an end date of 5/17/2013, is there a query way to return Jan, Feb,March, Apri and May? I am looking for the query to return the months during the start and end period. Thank you!

Oh,so you're saying in the design, include the lookup table multiple times. I never thought of that, thank you. I was thinking I may need to run a seperate query for each lookup item, then bring the data together wth a cumulative query. I will give this a try. Thank you veyr much!

I have a table that has multiple data elements in it that require a lookup table. For example two fields may be seat color and paint color 2. each field has a number in it, say 1 and 2, so i need to relate both fields to a lookup table to find out what 1 is and what 2 is. But when i create...

Hello: I am using the general code below to load data from a non-bound form. Dim LoadErrorData As ADODB.Recordset Set LoadErrorData = New ADODB.Recordset LoadErrorData.Open "TblDemographics", CurrentProject.Connection, adOpenKeyset, adLockOptimistic LoadErrorData.AddNew...

Hello: I am using the basic code below to load data from a non-bound form. LoadErrorData.Open "TblDemographics", CurrentProject.Connection, adOpenKeyset, adLockOptimistic LoadErrorData.AddNew LoadErrorData!FamilyName = Family ... LoadErrorData.Update LoadErrorData.Close I now want the the...