Search results

1. please see the attached file. Open Db, 2. this is a split DB, you will most likely have to use the Linked Table Manager to get it work in first place. 3. F_CompLvl form will open automatically 4. I made a comment in red with a line pointing where the report is placed on the form. 5. on top on...

right, I found something really strange.... "tTaskDueDate" - basically a user chooses a due date for a task, and then upon completion, user enter "tTaskComplDate", and then the query I've attached code from earlier, works out if the task was done before of after due date, to rate it ON TIME or...

I was considering this option as my next step. But then when I actually tried it, it doesn't work. As soon as I add anything to Header or Footer section, it comes with the same error.

Hello all, After couple of weeks of using the DB one of the reports which load up automatically when main form opens, stopped working, and gives an error message: the expression is typed in incorrectly or is too complex.... report has 13 txtboxes, in every single one of them ive placed...

Works like a charm! So simple and so clever. Thank you very much :)

In theory it should do the magic :) But the field in the table this department field will always have a value And I understand if I select is null the query will look for records where department fields is blank,but I want it to look for ALL, or am I wrong?

Hello, I have a TRANSFORMED query: TRANSFORM nz(count(T_qa.qaQAPK),0) AS SumOfQAs SELECT month(qaDate) AS QAmonth, Count(T_qa.qaQAPK) AS QAs FROM Q_ALL_qa GROUP BY Month(qaDate) PIVOT month([qaDate]) IN (1,2,3,4,5,6,7,8,9,10,11,12); This query is record source for a report, then this...

Thank you namliam for all your help. I will look into this and probably create a new thread.

Ok I see. I will skip the nesting then and will try to research more about vba. What are the keywords I need to look for? Thank you.

Also, Can I have a calculated field in WHERE ? ... WHERE count(IIf(Forms!F_CompLvl!cboDeptStats=0,Count(fieldA),Count(fieldB)) ... Basically, if a combo has selected department, count data for this department, otherwise count for all departments. Thank you

Can I nest a transformed query inside another transformed query? Q1: TRANSFORM nz(count(T_qa.qaQAPK),0) AS SumOfQAs SELECT month(qaDate) AS QAmonth, Count(T_qa.qaQAPK) AS QAs FROM Q_ALL_qa GROUP BY Month(qaDate) PIVOT month([qaDate]) IN (1,2,3,4,5,6,7,8,9,10,11,12); Q2: TRANSFORM...

This works like a dream :) Thank you Im going to have to create probably 6 queries that calculate all my fields. I would like to have all this final calculation shown in one report, Is it possible to have a multiple record source for one report (based on all those queries? Or do I need to...

the stacking query seems to be easier to do, but i will end up with lots of "little" queries.. I tried the second option, to recalculate, SELECT month(qaDate) AS [month], Count(tTaskPK) AS totalTASKS, count(tTaskDueDate) AS haveDUEdate, count(tTaskComplDate) AS haveCOMPLdate...

Been trying to find any hints on the web, but all examples include JOIN, in my situation, all data comes form one table/query, therefore i couldn't understand how to do it properly. Would you mind to create a sample query for me, and then I will try to take if from there. I am not sure in what...

And also, how can I make calculation inside the query statement? as it gives me an error if i try divide one field by another. SELECT month(qaDate) as month, Count(tTaskPK) as sumOFtask, count(tTaskDueDate) as dueD, count(tTaskComplDate) as ComplD, sum(iif(tTaskDueDate>=tTaskComplDate,1,0))...

it won't be a problem, as I will always have records for 1 year only, so its ok to sort it by months excluding years. In one of the first post you have explained to me, I can have all this data from 1 query and it would be x-1 times faster :) Thats why If possible i would like to have all...

ok, thats my latest code: TRANSFORM nz(count(T_qa.qaQAPK),0) AS SumOfQuantity SELECT Count(T_qa.qaQAPK) AS QAs, count(T_qa.qaQualityIncidentNo) AS QIs, Sum(qaSeverity * (-1)) AS Sev10, Sum(qaFrozen * (-1)) AS Frzn FROM Q_ALL_qa GROUP BY Month(qaDate) PIVOT month([qaDate]) IN...

Silly me. Ok it's just months now. Fully working :) Can I combine 2 different fields into one query? Like I had at the begining, count qaQAPK, qaqualitysomething... And then show results the same way as I do now? Is it possible? Or do I need a separate query for each field name I want to...

thanks namliam, what am I missing, as it doest show any data in "months" TRANSFORM count(T_qa.qaQAPK) AS SumOfQuantity SELECT Count(T_qa.qaQAPK) AS QAs FROM Q_ALL_qa GROUP BY Month(qaDate), Year(qadate) PIVOT Year([qaDate]*12) IN (1,2,3,4,5,6,7,8,9,10,11,12);

ok googled one of my answers, need to use WHERE where qaDeptFK = Forms!F_CompLvl!cboDeptStats but still unsure what to do with my months, if quewry produces resoults for all months, so to assosiate a text box on the report to show only values (calculation) for specific month. Can I do it...