-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
inner join
-
P
SQL Join - Syntax error (missing operator) when using two Joins in query
Please help... In Invoices table record in my "Excel database" i keep supplier ID and customer ID when I list all invoices for a certain period i need names instead of IDs. With one INNER JOIN (for only one "BusinessPartner") the query works, as soon as I use two it reports an error. SELECT...- PavelSimek
- Thread
- inner join sql
- Replies: 2
- Forum: Excel Questions
-
Z
Ran out of memory while merging queries (inner join)?
As you can see in this screenshot (https://imgur.com/unBLKFd) which I took minutes before it crashed, memory usage for excel wouldn't pass 500mb (I have 16 GB). This are my Query Options (https://imgur.com/JVvMycs) and I stablished 8 GB as maximum allowed in 'Data Cache Management Options'. What...- Zrakk
- Thread
- inner join merg power bi power query [this
- Replies: 2
- Forum: Power Tools
-
E
Create Query to combine data
Hi all, I'm trying to combine two different data sources. Unfortunately, since I'm quite new to Access, I don't seem to be able to figure it out. I have the following two tables that I need to combine: Raw Data Table: <tbody> Store ID Store Name Store Type Retail Channel SLS RTL 30001...- esbencito
- Thread
- fss grand inner join query select
- Replies: 8
- Forum: Microsoft Access
-
A
Create new sheet
so I have 2 sheets and need to create a third one as follows: Sheet1 <colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody> ID Name Code A001 A C1 A002 B C2 A003 C C3 A004 D C4 </tbody> Sheet2 <colgroup><col width="64"...- AbuFawaz
- Thread
- create create sheet data inner join vba
- Replies: 6
- Forum: Excel Questions
-
A
Table Field Issue, Potential Removal of offending Table, and Inner Join "ghost" queries
Hi all, I'm working on a db I inherited, and I'm troubleshooting a query that returns duplicate values. The problem is a table that either generates a timestamp, or the timestamp is passed from VBA during some other query, BUT the timestamp is invalid, inconsistent, and changes frequently...- AlexB123
- Thread
- inner join join sql table
- Replies: 12
- Forum: Microsoft Access
-
L
Excel-VBA, MS Access with INNER JOIN
Hello, I have a problem with importing data from ms access to excel with <acronym title="visual basic for applications">VBA</acronym>. I use "ADO Connection" to connect excel with acces. I have 2 tables in ms access. I want to get the newest comment from table p_comment for products. I...- luffy88
- Thread
- inner join ms access
- Replies: 1
- Forum: Excel Questions
-
C
Another MAX(Date) query issue
Hi there, I've tried 2 different ways to do this, (below) but cant get to work. I have one table [Activity-Opp-Data-Wenda] which is populated with OpportunityID - this is unique. I have another Table, (Activities) that contains Activity data: ActivityID (unique), OpportunityID, (not unique in...- clueless1
- Thread
- inner join max date update
- Replies: 7
- Forum: Microsoft Access
-
E
Creating a 1-1 relationship between fact table and date table
My fact "sales" table contains transactions between 01/01/2011 and 06/30/2014. My date table contains consecutive dates from year 1998 to 2017. When I use year column from date table in a slicer all the year numbers prior to 2011 and after 2014 are displayed "greyed out" on the slicer. I will...- Euler59
- Thread
- date table inner join left join relationships
- Replies: 2
- Forum: Power Tools
-
A
VBA question on SQL statement multi Joins and Where clauses
Ok, well first off, I am very new to Excel/Access. Have used other scripts/DB's in the past ... granted a while ago. So please know that first when replying as I need responses in kindergarten form. I think this would go here, but since it's really an SQL question it might need to go in...- Archide
- Thread
- inner join multi sql
- Replies: 9
- Forum: Excel Questions
