Search results

I am stuck on this one, any help would really be appreciated. I have 5 simple queries which all draw upon the same customer data. They just cut the data into different groups based on various criteria. All of the queries output the same fields including the name of the group they're in. Now...

That was it. Sheesh! I hate missing something so obvious. Thank you!!

I'm trying to create a macro which executes different saved imports. I've read on a few different forums, along with this one, about either the 'runsavedimport' action as well as the 'texttransfer' action. I can't find either of these in the action drop-down when you create the macro. One...

I'm limiting the year to only 2008 and doing a filter on 'Current'. The rest of the fields are grouped (Geo, CustID, etc) Since this is only for one year, there shouldn't be any dups.....shouldn't :) SELECT [Invoice Data].[EndUser POCN:], [Invoice Data].[EndUser OCN:], [Invoice...

I have a question on the accuracy of the 'min' total. When I run the query without the 'min', it returns duplicate lines for years where a customer made more than one purchase and one of them does not have maintenance. IDA Current 2008 IDA Expired 2008 etc... Now I filter the items listed...

I just found that out and had a question about that. I did the aggregate and made the Total a 'Max' and it removed all the duplicates and made them unique with 'expired'. I thought that may have to do with the ASCII value for 'current' vs 'expired' so I changed it to 'Min'. Now the dups are...

Actually, this is just for a query. I need to find out how many customers meet certain criteria. As a secondary question, they want to know what customers, which meet the criteria, are current on their maintenance. I was hoping to get this done in one query. Have a basic query with an added...

I'm really stuck on this one and need your expertise. I have a simple query which checks to see if someone is current on their maintenance for the year. The problem is sometimes they purchase more than one item and don't always purchase maintenance for the other items. Maintenance...

So, what it looks like is you can't edit a saved import, but you can create an import script?

I've searched this forum and others and haven't found an answer. Please forgive me if I missed a post. Every quarter I have to import about 30 large files into my database. I've been renaming the files to a standard, running a saved import, and then repeating. This is a complete pain...

Question using IIF... I have an IIF statement which looks at the ending date of a customer's maintenance to see if they are 'current' or not. Maintenance Status: IIf([Invoice Data]![Maint End:]<Date() Or [Invoice Data]![Maint End:] Is Null,"Expired","Current")For the most part, it works...

No, these are local databases. The biggest is only about 350M (390K records). I didn't think it was that big but maybe it is I guess. And yes, I always backup my databases anyway. Since they're local I don't have a tape or anything on them. I create a backup in Access and then copy to a...

OMG!!! That was too simple. I thought if you appended the data the field types had to be the same. I feel stupid, but I'll get over it :) Thanks for the help! Not to keep the thread going since the the question is already answered, but why didn't the ALTER TABLE or the DESIGN VIEW work...

I have a simple table with about 20 or so fields and about 390K records. This same structure is in three local databases (one for each business unit). One of the fields was incorrectly imported as text instead of date. I would go back and re-import the data but that is a complete pain. It...

Won't a UNION query get you what you need (if IT won't pull their heads out that is)? SELECT [Data A].[Job_no] FROM [Data A] UNION SELECT [Data B].[Job_no] FROM [Data B] UNION SELECT [Data C].[Job_no] FROM [Data C];

Interesting solution. Instead of having 6 dynamic queries you created a couple tables and did it in two queries. I can easily enough add a 'group' field to each of my queries, run a union query to build a main table with all the customers and their groups, then run the different queries to...

It's very possible. We're talking about psychographic marketing groups. For example: GroupA contains all the customers who have spent 10K or more in a year, but have not purchased maintenance or a warranty. The high-rolling risk takers. GroupB contains the customers who buy all your...

Yes, I was thinking the same thing. Instead of binary, I just assigned values to each one. A=1 B=3 C=5 D=10 E=20 F=40 In fact, I already have an Excel file with all the different combinations and their values. What I don't know how to do is get the customer count for each combination without...

I'm not even sure what to call this thread let alone how to search for it in the forum. Query Array is as close as I could get :confused: I need to find out what customers exist in each of 6 groups as well as the combination of those groups. I know the customers in groupA, groupB, groupC, etc...

Gemma, you're spot-on describing the issue. It's simple to get the areas accurate, but the overlap takes a bit of doing. However, I disagree with your assertion that a VENN shouldn't be used to reflect accurate ratios. That's where the real power of the data comes to life. Look at the...