Search results

What I need, is to populate a column with incremental number based on 1 column and the previous rows result. Will be easier to see it. Let's says I have the following: ID_NUM RPT_YR CS 1 1989 0 1 1990 0 1 1991 1 1...

OKay, this code has been working for a while now. Today, I open up the database and test it before moving on to another project and it is no longer working. And I don't know why. On Error Resume Next Exists = IsObject(CurrentDb.QueryDefs("NameofQuery")) If Exists Then DoCmd.DeleteObject...

Okay. I'm still somewhat new to this, and I've been unable to find what I'm looking for. I don't have any code for this at this point, but I can try to demonstrate what I want. (Do not want anyone to write this for me, but nudge me in the right direction.) TIA Pseudo-codeish SQL Query to pull...

Okay, this is a long shot, but y'all have helped me out a lot in the past, so I figured I'd see if anyone had any ideas. Let's say I have a table with the following information. ID ORDER_TYPE Payment 245 Sub_Basic_Free 0.00 245 Sub_Renewal 125.00 300 Sub_Basic...

I hope I am explaining this well. Before I try to spend a lot of time beating my head against a wall, I was wondering if there was any direction someone wanted to point me. I have a couple of VBA modules that I have set up to create a Query that will join 5, 10, 0r 15 Variables. These are...

Okay, I am unable to find an answer for this, so if it's already been answered, I apologize. Any help being nudged in the right direction here would be very appreciated. What I am trying to do is run a series of SQL Queries looped based on a Variable. The Variable in question is VN, and it's...

Hello, I converted a database to accde, but when I pull up the accde an then run the query it still allows me to get to the design level, and make changes. I thought that wasn't possible in accde. Am I doing something wrong?

Okay, I feel like an idiot. But I am not a programmer. I found the below VBA function, and I bet it will do exactly what I need it to do. But I'm not sure how to actually use it. I want to use a Query to display the results. But I'm not sure how to do this with the code. Any help? Private...

In an every more frustrating attempt at something more complex than I think I can actually do with my limited knowledge, I'm trying to find ways around my lack of ability. So..... Is there a way to set up a make table (Select into) query that can create a table the data based on a date range...

Okay, been struggling with this for a while. To preface, I am not a VBA developer, and I don't want anyone writing the code for me. But need some help. Any given is very appreciated. I have a situation where I have a range of data that I need to be displayed, but the number of columns can...

First, I want to thank all the people who have helped me in the past. I have a bit of a dilemma for this current query. Okay, As an Example, I have a Company Code, a Variable, a Date Range and a Value. I know how to do the Date Range to pull between any two dates. (in this case, years). What...

Okay, I have a doozy of a report, and I'm not sure where to begin on this. Any suggestions would be greatly appreciated. I was originally making a bunch of queries, but then as it got more complex, I started wondering if there was a better way to go about this. So, I don't need a complete...

Okay, I'm a bit new to Access development, and I'm wondering if this is possible to have returned as a query. I know how I can do it in a Report, but a Query would be better for later manipulation and data analysis. What I have is something along the along the lines of the following: Company...