Recent content by Nate74

Jon, Thank you for taking the time to reply. This will take me a while to work through but again, I really do appriciate you taking the time to help. Nate

Embarrassingly, I'm not even to the point where I can ask a specific question about the query(ies) I think I need. Here's where I'm starting from and where I want to go... maybe it will make enough sense for somebody to point me in the right direction. I have sales data that contains line...

SWEEEEEET!!!! That did it. You just saved me from about 2 hours of typing. Thank you, thank you, thank you!

Is it possible to construct a query that uses information from one table to run a series of Like OR Like... criteria? I have created a table that contains partial part numbers and would like to query a second table for all the part numbers that contain these partial part numbers. Meaning...

Thank you. I think you may put me over the edge on this one. I've encountered a dozen or so projects where naturalizing the data would be useful. Our part numbering structure really does not do well when queried... Thanks for the input.

Greetings all, It's been a while since I've had to turn to you for help. I'm usually able to find what I need in searching through previous posts, but no luck this time around. I am trying to write a query criteria that will return BAC-5, BAC-8 And BAC-12 I can get the -5 and -8 with: Like...

Cool, thanks Rich. Sounds like it will be simple. I've now managed to get monthly totals in one column, but is it possible to get each month into it's own column aligned with each customer? Thanks again!

I'm affraid my confusing topic title is an indicator of how confused I am by this. I can't even understand the variables well enough to fully utilize Access Help or the Search function here... What I have is a database hat has column headers that look something like this: Customer_Name...

A local recording studio that I've recorded at before has a banner that says something like "Blah Blah Studios: making good artists sound great, and crappy ones go back to their day jobs since 1984."

He He He. I'm jammin' now. I was able to use a similar query to figure out where 80% of our dollar value in bookings comes from (about 22% of our product line). They think I'm a wiz... uh oh... Seriously though, thanks to you all! If anybody ever comes to LA, I owe you a beer:)

Wow, I was in a meeting for no more than 20 minutes and my questino is already answered. Thank you guys so much. I just ran it on last week's data and all seem perfect! I'll be getting this weeks data shortly but man am I gonna look like a Hero. Thanks to you guys that is!!!

I recently took a Marketing Manager position at a local aerospace company here in Southern CA. While I was working on my MBA, my various study groups used Access alot for marketing research projects and now I'm trying my hand at similar uses. I've made some simple programs that the inside...