Recent content by recyan

That appears to be the case. Thanks

Have noticed that irrespective of whatever, I was not able to use an alias in the GROUP BY in the query. For eg. In @TwinCams query, even using ( assuming there are similar multiple IncidentDate's ) SELECT IncidentDate AS IncidentYear, Sum(tbl_2c_Acc_1.VehicleOffRoadTime) AS...

Missed out typing : "In addition to pr2eugin's SUM() suggestion", Do not know if below is the problem. I once faced a problem using Alias field in the Group By. Ended up with : GROUP BY IIf([IncidentDate]>=#7/1/2012# And [IncidentDate]<=#6/30/2013#,'Last',IIf([IncidentDate]>=#7/1/2013# And...

Check if below pseudocode gives some guidelines : SELECT DateofReceipt as DateA,purchasesFrom as Purchase_Sold, Receipt, 0 as Issue FROM tblReceipts UNION SELECT DateofIssue as DateA,IssuesTo as Purchase_Sold, 0 as Receipt, Issue FROM tblIssues Thanks

Are you indicating that the result of your union query should look like below : DATE PURCHASES/SOLD RECEIPT ISSUE 01/01/2014 APPLE STORE 100 0 02/01/2014 DREAMSTORE 100 0 01/02/2014 MR.ABC 0 100 02/02/2014 MR.XYZ 0 100 Note : Try using the CODE # tags, when posting...

Condolences to ChrisO's family and loved ones.

Thanks Bob, I for one, have benefited a lot from your posts. Best of Luck in all your current and future endeavours. Thanks.

Thanksssss.

Thanks for the welcome back. Am tied up with solving problems that have come from all sides, hence the absence. Hope I get them sorted out soon & be back interacting with you guys / gals. Appreciate you remembering me, inspite of my long absence & also appreciate your concern for my well-being...

Don't feel bad. If I am not wrong, all of us, whatever level we are, do it quite often. In fact one of the reason, I like forums is, I can be as stupid as I want & people understand. At 2-3 am at night, I am dead to the world, forget working.:D Wish I could go back to those old days.:( Thanks

@Derevon, Is this what you are trying to indicate ? Location Backlog RecordedOnDate 00001 84 2/22/2014 00002 53 2/22/2014 00003 26 2/22/2014 00001 85 2/23/2014 00002 48 2/23/2014 00003 25 2/23/2014 or Am I totally mis-reading your problem ? Thanks

Check if below gives some guidelines : SELECT myTable.TheID, myTable.FieldToBeChecked FROM myTable WHERE 1=1 AND IIF ( [Forms]![frmModelling]![cboProcess]='ALL PROCESSES', myTable.FieldToBeChecked LIKE "*", myTable.FieldToBeChecked=[Forms]![frmModelling]![cboProcess] )...

Glad you got things working. Seems, you have VSArrive field in your table as Text Datatype. Correct me, if I am wrong. Thanks

In addition to pbaldy's suggestion Check out : IIF([VSArrive]="1","Yes",IIF([VSArrive]="2","No","N/A")) Thanks

Do not know why that is happening ? Ideally, you should be able to see it in Design mode. Am unable to understand your field names, as they are not appearing in English. Do you have a ( & ) in your field names ? eg : PhoneNumbers.電話番号（MSN） Call0CumulativeTbl.電話番号（MSN） If yes, think you should...