Search results

Thank you spikepl...and good night to you. :)

Good Morning all, Please disregards the tables/queries naming. I did that so i can easier to locate, but after feeling good about it, I will fix it. So this below query is working for me for the quarter (since including larger jobs). However, when I do small list of jobs, I am encountering...

ah i fix it. I should have unclick DONT SHOW...

I retraced my query again and tried to understand your initial post. I still dont get it. What i am seeing is that "like "*power*" finds all rows that consist the word "power". But, when i sum the cost, the cost didnt know that they have to add all cost that consist "power" since item...

[12 Material-Filter] would looks like JOBID /Cost /Item 1 / 20 / (aa Power) 1 / 30 / (bb Power) end result should be: JOBID Cost 1 50 Right now, with the query i have the result is: JobID Cost 1 20 1 30 [Joblist_all] has not come into the picture yet. I had...

Hi thks for the reply. I forgot to add that I have used like "*power*" function on criteria. It listed the items but I also need to group it by JOBID with sum of cost. It didnt do the sum. unless i missed something. SELECT [12 Material-Filter].JobID, Sum([12 Material-Filter].COST) AS...

Hi everyone, I am pretty new with access queries. Mostly done alot with excel. I need to know how to write this in access. for example: I have a table list of items and my specifically interested to pick up item description that have "power' in it. So, in excel, I wrote...

I am from bay area, California. Havent do much access except for being a user. Do most work with excel and now start to try to build myself database.