Search results

Hello guys, I have a database that is used for the treasurer of a group. Everything is working well with the exception of the reports. I have the report grouped by month and would like to have a running balance in the footer of each grouping(month). Right now it only gives the amount total...

Hey, thanks for the tip. I was able to make my own pop-ups and still have the query work. I have the reports made, but can't seem to get the group header to be a running balance. Any Ideas? I attached the database, it's pretty small.

Hello, again guys I'm working on this treasurer's database. I want to be able to enter transactions with a form, which I already made, create a view(form) and report of transactions in any range of dates. User will push a button to choose a view or report, then takes them to a popup where you...

Thanks, I used the dSum and it worked great. I have another issue, but I'm going to post it as a new thread. Thanks

Hello, I have an "amount" field and a "balance" field in my table. I created a form to add transactions. I would like the form to have the previous balance show when a new record starts and change according to the amount entered (amount + balance) I'm sure there is an easy solution for...

Hey Guys, I think I figured it out. What I did is stopped worrying about the crosstab query and how to sort it. Instead, I made a simple query from the crosstab query and just sorted in descending order by each week's column and lastly by index. SELECT Query1_Crosstab.UserID...

Thanks for the response. This is the direction I was headed as well. The good news is that it is sorting them correctly. Bad news it is grouping them 13 times and giving me 353 records. I'm surprised you didn't' test this before posting. I am not sure how to fix the database for debugging...

I did get all the actions sorted by index now, but I still can't seem to figure out how to go about only using the index sort on the first two weeks and then just as the actions are added the rest of the weeks. Maybe use criteria or VBA. I just can't seem to get it. PARAMETERS...

Here, I uploaded a screenshot of what my form looks like now. It needs to resemble the excel file. Notice the first two weeks all the actions are X'ed (Row 10 is where all the actions for the first two weeks stop) and then as the plan goes from week to week. One action, or maybe two depending...

Hello all, So I decided to start a new thread since my problem is very different then what it was. In the project I'm working on I have one query that gets all the actions I need and then I have a crosstab query that is used in a form and a report. Query1 SELECT UserID, FullName, WeekNumber...

Hello, I have been busy putting a form into the project. I still need help getting the sorting down. The first two weeks should be sorted by the index(which you can use) and then from week 3 and on, any action added should show up on the bottom of the list. If an action is swapped and added...

So if you noticed there are no duplicates and I am using the index in the query. I figured out a way around the index problem. I put a WHERE statement in Query1 that filters out all the actions with an index > 200, which are all the duplicates. Should have done that in the beginning. Live and...

One last thing. I notice that I had no users with a complete 12 weeks. I just created one for the user "Thomas Deiter". The first two weeks are the same and 1 action added each week. I swapped an action in one of the weeks, so that week will have two new actions. Here is the link for the...

Ok, I'm going to bed after this post, but I wanted to get this out there. I took out the ORDER BY statements in Query1 and was able to add the TempVars as a Parameter(Thanks for that link). PARAMETERS [TempVars]![TmpUserID] Long; TRANSFORM First(Query1.Idx) AS FirstOfIdx SELECT Query1.UserID...

I will probably use the IN phase, I didn't forget about it, but was pleased to know that It will grab as many weeks that are in the database. I just updated the last entry, let me know what you think and I'll look over that link you sent.

I'm not sure why it didn't work either. I figured out how created a new crosstab query in the design view and got it to work(thanks to your example). My problem now is getting it to recognize a temporary variable. It gives me an error when I use them in either query. Here's what my queries...

June7 I am a little lost with what is going on with that crosstab query, but after making the "Query1" and using the SQL to create the 2nd query; it is asking me for a parameter "Query1.StandardAction" Also, it is showing all the users when I need the report to be designed around only one...

If you want to use a static value, use "4" for the UserId. The two tables represent all the actions that the client has chosen to be responsible for. I need to make two separate tables because of the timed value in the "Weekly_StartTime_Challenges" and the "X" value in the "Weekly_Challenges"...

Like I said I was just trying stuff. Union was just a guess. Yes, I will be needing pulling up the report per user at any time throughout the 12 weeks.

Also, that query is named "ActionsByPlanWeek"