Search results

The requirement on this particular question is pretty much me trying to figure out a way to do what I really need to do. So there is no data structure for this question. I'm trying to determine if there is a way to populate a table (one field name) with all the years from a range. So, the input...

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...

I'm not really sure how to do that either. I was just saying that if I could figure that part out, I could work with it that way.

Just thought also, that if I could just get it to create a table, with the Report years each with their own column, I could work with that.

okay.. i was just thinking, that If I could do a cross tab query .. that could probably do it. But I haven't been able to get that to work because I'm not really trying to sum anything up..... so maybe not.

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...

Brian, that is perfect. I think it will do exactly what I want it to do, with minimal changes. Much obliged. I just wasn't searching the site with the right keywords to get to where I needed to be. Thank you again.

Thanks. I'll check it out. And I appreciate your help.

and I, by no means, want anyone to do the work for me. But def need a nudge in the right direction.... and very much appreciate all help previously provided so far.

No worries on the confusion. I'm a bit scattered on this as well. I needed the list of companies, to make it unique to those that had a Value (based on the variable) for all years chosen. (so if it was 2000-2010, I'd get only those Companies that had a value for all 10 years.). now, I need to...

Thanks to both of you. I was able to get it working with a combination of the two. Now on to the second part of the problem. I may open a new question for this one. I think I may only be able to do this with a VBA script, in which case I'm in for a lot of learning on the fly :) Is there a way...

Thanks. Yes. Year is actually just what I threw out here. all of the info in there is bogus, as i didn't want to give away the DB structure. So thank you. Sorry, I wasn't clear. The only data that i want to retrieve is where VALUE has a value for all years in the Range entered, for the...

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...

perfect. Thanks much. Took me a little while to get that to work(my bad, not yours), but once I did, it's doing exactly what I want it to. Thanks again.

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...

What's kind of interesting here, is that I created the query, and the intial one still has multiple rows coming back for the Product Code. Which I think is a bit odd, but can't really tell why. So, I then took that query, and made another query based off of it's results.... and Voila! the data...

Thanks much. Code was just an example.... That is what I was attempting to do when I finally started banging my head on this..... Unfortunately it was still bringing back multiple rows...But. I think I see where I screwed up. I still had a column in there that would have had unique values in...

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...

Thank you! This works perfectly for me, and keeps me from having to redo the queries that I was given. I'm still shaky on forms, and this is great.