Search results

Plog, If I change this it will mess up with all existing records. Anyway. What shall I do with the new TASKs?

Please see current database relationship image The new (potential) database will require the following fields: However, I don't want those new tasks to link to the table T_qa. In the new database I want to see the old and new tasks (from both databases) I need to be able to enter...

Your reply makes no sense. Another solution: Create a separate front end for the existing TASK table, and add records unrelated to table INCIDENTS... Would it work?

Hello all, We have one database with table Incidents and table Task, every task must be assigned an incident to it (one-many). We will also have another database with table task. Those are singular records, not related to anything, just task and due date, completion date. Yesterday, my boss...

Re: calculate completion - transformed Query Still struggling, but I think I understand my problem now. I am trying to make a query calculate completion for each month, based on 2 fields [dDateFound] and [dDateClosed]. I run a query that counts all found records and then group it by...

Well, actually they both work, no errors, all data loading etc... I have records with [entryDate] and [closureDate]. I want to calculate completion for those records, then group them by month, thats why I created pivot query. The problem is: there is approx 30 records with 16 of them completed...

Hello all, This works: SELECT sum(iif(dDateClosed is null,0,1))/sum(iif(dDateFound is null,0,1))*100 AS Calcul FROM Q_Defects WHERE (Q_Defects.dAreaFK)=[Forms]![F_MainMenu].[cboStatsArea]; This doesn't, can't find out why... TRANSFORM nz(sum(iif(dDateClosed is...

I had a similar issue a while ago and found the use of word "between" was causing issues, therefore try this: >=[Forms]![FormName]![StartDate] And <=[Forms]![FormName]![EndDate]

remainings of the old code (try if that works). removed now, Thanks Paul

as below, had to add this: me.filter and add all PK fields to the query. If IsNull(Me!dPK) Then MsgBox "No Records available for print", _ vbOKOnly, "Error" Exit Sub End If If Len(Me.[dDateClosed] & "") > 0 Then DoCmd.OpenReport "R_Open_defects", acPreview, , Me.Filter Else DoCmd.OpenReport...

Ha! found the solution, Had to reverse the calculation completed*100 and the divide by total TRANSFORM sum(iif(tTaskDueDate>=tTaskComplDate and tTaskTypeFK=2,1,0))*100/sum(iif(tTaskTypeFK=2,1,0)) AS PercPREV SELECT month(tTaskDueDate) AS PREVmonth, sum(iif(tTaskTypeFK=2,1,0)) AS CountPREV...

used this: Private Sub cmdPrintOpen_Click() Dim i As Integer i = DCount("*", "Q_Open_defects", "dAreaFK=cboStatsArea OR cboStatsArea IS Null") 'MsgBox "The count of rows is " & i If i = 0 Then MsgBox "No Records available for print", _ vbOKOnly, "Error" Exit Sub End If If cboStatsArea <> 0 Then...

Hello, The following code supposed to let me print all records OR only those where dAreaFK = myCBO currently I get an error message "Object missing" if i remove this: Or Me!cboStatsArea Is Null from the last line the it works but only if i make selection in combo. Private Sub...

Try this: Nz([Old Stock],0) + Nz([New Stock],0) or this: Nz(sum([Old Stock]+[New Stock]),0)

Plog, I tried this way, already, and whether I make a selection or not, results are exactly the same. Brian, This works lovely, Thank you :) I Did try it before writing a post here, but I believe my brackets were in different places, perhaps thats why it didn't work in first place. Many...

just tried it, it shows the same results no matter if cboStatsArea has been selected or not, and doesn't recognise value between selections. :/

Still struggling here, How do you calculate completion in your databases? I imagine it this way: CompletedRecords / TotalNumberOfRecords = Completion 2/10=0.2 0.2=20% Thank you

Hello, I have a form with 2 cbo. I want query to show all data if nothing has been selected, or show specific data to whatever has been selected in cbo1 AND/OR cbo2. My query was working ok for couple of days and then stopped. I don't know why, as no changes has been made. if both cbo are...

Selecting tTaskTypeFk =2 ... What about task completed on time, how will I be able to verify this? Thanks.

But the query itself doesn't give an error, just returns 0. So how can I go around it? I'm basically trying to get a percentage of on time completed tasks for each month. Thanks.