Search results

Within each category there are multiple descriptions. For this report, the user wants the top three categories along with each of their top three descriptions both including their counts. When I run the query I get the correct information but it looks like this: CountOfCategory Category...

Hello - I am using Access 2010 and have a report that uses the following query: SELECT t.CountOfCategory, t.Category, t.CountOfDescription, t.Description FROM qryTopThreeCategoryBehaviors AS t WHERE (((t.Description) In (SELECT TOP 3 Description FROM qryTopThreeCategoryBehaviors WHERE...

Thank you all for your responses. I appreciate all of you taking your time to help me. And thank you spikepl for attaching the fix so I can see what needed to be done.

Hello - I am wondering if it is possible to create running sums across two different groups on the same report. I have a report in which I would like the tote cube column to increase as picks are added and the module cube column to decrease as picks are added. I do want the running sum for...

Thanks for your response. My field names are actually Pick Date and Pick Time. I shortened them for the post just to save a few keystrokes and space. The information is in two separate fields because this information is imported from a .csv file and it is two separate fields in that file so I...

Hello everyone! I am wondering if it's possible to have a running total either in a query or using the Running Sum function on a text box on a report that will reset after a specific value. Here is what I would like to have happen: The RunningTotalCube field to reset when it has reach...

Ah! I do see that! That would give them another line to use. I will try implementing that too. Thanks again!

Thank you all so much for your help!!! I replaced the original code with the code JHB posted and it works just how I want it to now! I racked my brain for so long on this :banghead: but, like I said, I'm a beginner and learning VBA code as I go so I'm nowhere near the level of expertise that...

Hi everyone - I have posted this issue on this forum in the past so I apologize for posting it again but I have not found a solution and am getting to a point that I have to roll out this database and I need to get this resolved. My issue is when there are 4 records (store numbers) for any...

This works. Thought I'd post in case it could help someone else. With xlApp .Sheets("Spoilage").PageSetup.Orientation = 2 .Sheets("Spoilage").PageSetup.LeftMargin = (9) .Sheets("Spoilage").PageSetup.RightMargin = (9)...

Hi everyone - I have the following code in a module to set certain formatting properties when exporting an Access 2010 query to Excel: With xlApp .Application.Sheets("Spoilage").Select .Application.Cells.Select .Application.Selection.ClearFormats .Application.Range("A1:K1").Select...

Hi everyone - I was able to find a snippet of code online that did what I wanted (entering blank lines on a report) and was able to adapt it to suit my needs. Here is the code I am using: Function SetCount(R As Report) TotCount = 0 R![RowNumber].Visible = True R![Position].Visible = True...

Thank you for the response namliam! I do have a bad habit of not renaming controls. :o I was able to make the changes you suggested with a little tweeking of my own and...it works perfectly now!! Thank you for taking the time to help me out.

Hi again everyone - I have racked my brain for days on this problem and cannot see where I am going wrong. Hopefully someone will be able to help... I am attaching a sample database to this post because I think it would be easier to see it and be able to move through it than for me to post...

Hey! That works perfect!! Thank you so much for your help! I really appreciate it! :)

Thank you for the quick response. Yes to both of your questions. It is a sub-query in a larger query and without the statement everything runs fine. I continued to try different things after I posted and found that when I set a sort order on the fields in the grid (EmployeeID, PickDateTime)...

Hi Everyone! I have the following in a query to assign a sequence number to each record: (SELECT Count(*) FROM [qryPTLActivity] AS T WHERE T.EmployeeID=[qryPTLActivity].[EmployeeID] AND T.PickDateTime <= [qryPTLActivity].[PickDateTime] AND T.PickAisle=[qryPTLActivity].[PickAisle]) I have...

Thank you JHB! It works perfect now! I knew it was possible, just didn't know exactly how to do it. Thank you all so much for your help!

Well, I'm getting closer to getting this to work. :banghead: I have a module that contains the following: Public Sub SelectorAssignment() Dim i As Integer Dim db As Database Dim rs As Recordset Set db = CurrentDb Set rs = db.OpenRecordset("qryRandomizer1st") For i = 0 To...

David - Thank you for your responses and advice. spike - I do have a query created that uses the RND function to assign a random number to each available selector. Although I struggle a bit with code and am not much above a beginner level :o, I have seen loops so I will do some research and...