Search results

Getting the same error: An action query cannot be used as a row source.

I have a query that correctly 'Unions' unique values for two fields from 6 tables. How can I insert those two unique fields into another table? This is what I've tried which gives me an error (action query cannot be used as row source): SELECT F1, F2 into myTb FROM (SELECT F1, F2 FROM T1...

The_Doc_Man, works great. Thanks. I'll see how it performs on more data.

theDBguy, yes, tab1 & tab2 are linked and grpTab is local.

Monthly imports to separate linked tables. Importing to same table would exceed Access max size. Thanks.

I have multiple table with same design: e.g., tab1: PID, SID, QTY tab2: PID, SID, QTY I have another table with design: grpTab: PID, SID, QTY1, QTY2, QTY3 How can I update: grpTab.QTY1 FROM tab1.QTY where tab1.PID = PID and tab1.SID = SID grpTab.QTY2 FROM tab2.QTY where tab2.PID =...

I have three identically designed tables. I do not want to combine rows with a Union or Union All. What is the query that would give me the distinct pairings of field1 and field2 for all three tables? Thanks for your help.

Thanks MajP. Sounds good. How do you do that? Can you please give an SQL example?

Thanks plog. The sales transactions are imported monthly. To house them all in one appended table would exceed Access capacity. The example in parenthesis is a record example where 's100, p123, 10, 022019' would be a record with 's100' as Person_ID, p123 as Product_ID, 10 is quantity and...

I'm new to 'union' queries and need some help, please, with creating queries that span tables. I have six tables. The first four, call them 'Sales_Master', have identical structure with these fields: Sales-ID, Product_ID, Quantity, and MMYYYY. Each of these tables represents a month's worth...

I'm going to give Access a try. I've managed to reduce the amount of data but still need to split into multiple databases. I will be asking for help under the 'Queries' forum. Thanks again to all who contributed.

Each salesperson and product will have unique identifiers along with other descriptive information that are contained in other tables. This will be text field, several characters. Products will start at 6 and may go to a dozen or so but not much more. Probably a rolling13 months. Archiving...

To Doc, Attributes always 12. Number of groups and subgroups can change. Regarding using Access, we're trying to see if it's a fit before jumping to something like Azure SQL Server. To Mark, Nothing exotic. Who's selling the most of group x and in what subgroup and attribute? Which...

Don't mean to be argumentative and I really do appreciate all of your comments, but these databases will be read-only and updated once a month with backups. There will not be any 'transaction' queries where instantaneous results are needed. Once the data retrieval queries are developed, there...

If I understand your question, the answer is yes. The number of items sold (i.e., > 0) per sales rep per month ranges 1 to 100 +. When you say back-end, I was thinking more along the lines of linked tables (or do linked tables always imply a back-end?). What if I created a separate database...

Thanks for ideas and help with setting up the tables. I've done some analysis of the incoming source .txt file. The 780,000 records hold about 350 million sales quantity buckets (Excel cells). Of these, about 3% are non-zero. That means, by importing only non-zero sales quantities, I'd...

You've been very helpful. Thanks.

I tried to import a .txt file with 229 fields and 780,000 records. Access said it ran out of resources, which I did not expect. There may be a problem with that .txt file. I'll take a look at your solution.

No, I'd split the 450 fields in the .txt file horizontally by group number into separate .txt files. To analyze the data, I split the .txt file vertically into multiple files of 10,000 records each, and then I imported one of those files into Excel. I found that one group has 2 subgroups, and...

Please see my updated comment above.