Recent content by haydenbottoms

OK I think I'm following the gist of that, but the second sentence didn't make sense to me (Then based the RecordSource of the Form from a query where JustAdded = True.). Can you clarify, please?

I have an append query that appends records to a table, and I have a form based on that table. Users will click a button that will run the append query and then open a form for users to fill in remaining empty cells. How can I filter the form to show only the newly appended records? This...

I have created a many-to-many relationship but am now having trouble figuring out how to add new data. I have a table PEOPLE: ID First Name Last Name 1 Participant A 2 Participant B 3 Participant C And I have a table BEHAVIORS: ID Behavior 1 Yelling 2 Grabbing 3 Smearing feces And I...

That works perfectly! I'm so excited. If you're ever passing through Iowa, I owe you a cupcake.

Getting close! Thanks so so so much!!! No errors this time, but the calculation isn't correct Here's what I'm getting vs what I expect to get: PRNs, 20, 8/2012, Michael Anderson, 20 (should be nothing) PRNs, 16, 9/2012, Michael Anderson, 18(should be nothing) PRNs, 11, 10/2012, Michael...

Yes, but don't make fun of me if I've done things in a stupid way -- I'm new at this.

This is working great! Well, kinda. It seems to be doing things right, except I'm getting #Error for MonthBegin, so then of course I'm getting #Error for MovingAverage Here's what the results of sub_ThreeMonthAverage look like: Behavior, SumOfCount, MonthBegin, Full Name, Linker, Month...

Hmmm good question. Hopefully this will never happen. It seems like it would make the most sense to do the average of the points that are available. for 4/2012, you would avg 4/2012, 3/2012, and 2/2012 (2 + ? + 1)/2 = 1.5 for 5/2012, you would avg 5/2012, 4/2012, and 3/2012 (3 + 2 + ?)/2 =...

Both, I think. Both of those variables have selection criteria. The record has to have a particular behavior (e.g., PRN) AND a particular Full Name (e.g., John Smith) to be returned in the query. By the way, I really really really appreciate your help with this.

You're right -- that was a typo. The query has criteria in it to only select PRN, John Smith data. That's what the HAVING line represents in the SQL code: This is the sql code for my query without the moving average: SELECT Data.Behavior, Sum(Data.Count) AS SumOfCount, Data.[Month Beginning...

Sorry. The query pulls simple data from a table (variable names: Behavior, SumOfCount, Month Beginning Date, Wing, Full Name). Everything I posted before is in the table, and the query just pulls that as is. Then, I want the query to compute the moving average, which I forgot to put in...

Query name: Individual Longitudinal Query (based on table: Data) Behavior, SumOfCount, Month Beginning Date, Wing, Full Name PRN, 8, 01/2012, Behavioral, John Smith PRN, 7, 02/2012, Behavioral, John Smith PRN, 4, 03/2012, Behavioral, John Smith PRN, 4, 04/2012, Behavioral, John Smith PRN, 5...

I'm having difficulty figuring out the sql code to compute a moving average. I've looked at other forum posts and looked online, and I can't figure out exactly what part of the code I'm supposed to replace with my own things. I have a query that pulls data from a table called Data. I'd...