-
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.
where clause
-
J
Access 2003 Left Join with Subquery Confusion
I'm trying to use a Left Join to a subquery in Access 2003 and it isn't working as expected. When I run the subquery by itself it returns the expected results. Here's the subquery: SELECT 'T0901' AS TestNumber , NAME AS TestName , TUBE AS SOFTTube , '0901 -- ' & [ID] & ' / ' & [NAME] AS TestID...- JeffK627
- Thread
- access 2003 left join subquery where clause
- Replies: 19
- Forum: Microsoft Access
-
B
Sum function depending other columns
Hi every one, I am starting to use DAX Expression in Power Pivot. i would like to know how I could summarize a column depending another. Like =sum([CA]) where [ID] has the same value. I think it is a simply formula but I did not find how to write it. I was trying...- blackcat18
- Thread
- sum where clause
- Replies: 2
- Forum: Power Tools
-
A
DoCmd.OpenReport Error
Ok, I've been trying to figure this out for a few days and it just isn't working no matter what permutations I put it through. What I'm trying to do is open a report based on the record in the form (and only that one so that I can save it to a PDF individually instead of in one big congolmerate...- AlexaS
- Thread
- access 2010 docmd.openreport expression error where clause
- Replies: 6
- Forum: Microsoft Access
