Search results

Thank you! That worked and was much simpler than I anticipated. Is there a way to have it show any absent data as zero? It isn't needed but would be nice to add.

Hi, I have built a query from 4 different tables. Simply, I want to maintain the data from the first table and add in data if present from the other 3 tables. My first table has all employee numbers, I am using that to link to the other 3 tables. My issue is not every employee shows in the...

Is there a way to add an OR type statement to this? Something along the lines of =IIf(nz([txtAction2s],0)=0 OR nz([txtAction1s],0)=0 ,null,[txtAction1s]/[txtAction2s]. I am working with a similar statement but I have the possibility of either number being 0

Thank you! That is exactly what I needed. I was placing the NOT in the wrong place which was breaking it. I do plan to fix the spaces. I uploaded an external excel file into my base tables and they all came with spaces. Going to go back and update at some point. I've learned the hard way they...

Hello, I am working within a Link Query and have several filters I've put in. "WHERE ([Contract #] NOT LIKE "") AND [Acct Code] NOT LIKE '72801011*' AND ([Pay Status] NOT LIKE 'L')" Now I would like to add another criteria essentially saying, "exclude if Acct begins with 1234 and Contract...

Not sure if it was the '*' I was missing or not but it was not cutting them out. Now it is. Thanks.

It is Text, but it does not have to be. I could convert it to numeric.

So below is my code. SELECT [Location], [DeptID], [Name], [ID], [1], [STD Hrs/WK], [1], [Acct Code], [Pay Status], [Eff Date], [Last Start], [Reg/Temp], [Full/Part], [Mail Drop], [Expected Return Date], [Action], [Reason], [Job Code], [Job Code Descr], [Contract #] From [Support Active Table]...

I have a union query and I was trying to write a WHERE.... does not contain or does not begin with. However, I cannot seem to get the syntax of it all correct. How should I write it? Thanks!

I had attempted that at the beginning but could not conceptualize how to add the people quantity by area break out as well. Part of my issue as well is that the original table is the main data for the entire database which predates me. So I am concerned to make to many edits to it as it could...

It took a few attempts but I did manage to work through the union query. Slightly difficult to explain but, essentially I have a group of areas that have a total plan. I then need to take some of those areas and break out their plans. So area 1 has 5 people in total. I am taking 3 people...

This would be similar to my data.

I believe the answer to my question may be a union query but I am not sure how to create. I have three groups of data that all need to be pulled together into either a master table or query since it needs to all reflect the same data. How can I take table A, B, and C and pull together the...

This seems to work. THank you Thank you!!

I have attached the tables and queries.

SELECT [T59 CS - Reimagine].[E Grouping], Sum([T59 CS - Reimagine].[CS Hrs]) AS [SumOfCS Hrs], [T59 B - Reimagine].[E Hrs], Sum([T59-AreaSuffixStore].BaseWeekHours) AS SumOfBaseWeekHours, ([SumOfBaseWeekHours]-[SumOfCS Hrs]) AS [E Hours Needed] FROM ([T59 CS - Reimagine] INNER JOIN [T59 B -...

Thanks! That did run it. But I am now getting a parameter message for "T59 CS - Reimagine.CS Hrs". It is also no longer returning values for "SumOfCS Hrs" or "E Hours Needed"

No, it is a bit massive and predates me. So I am working off of someone else's work. I did resolve the syntax though. Now I have a "Cannot have aggregate function in Group By clause (Sum(([T59-AreaSuffixStore].BaseWeekHours)-[SumofCS Hrs])"

I received a syntax error in the join operation. (I am not SQL knowledge able so I am not sure how to resolve)

It is actually asking for one for "SumofBaseWeekHours" which is my BaseWeekHours sum column and then "CS Hrs" which is my CS Hrs sum column.