Search results

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...

Glad you got things working. In case you have not already done so, just check the Data Type of TheID in the new table Table2_New. If it is AutoNumber, you should be able to change it to Number, if required. Thanks

Till someone comes along, do not know if this is what you need, all the same : Table1 - This is the main table containing all the Phone Numbers TheID - Autonumber PhoneNumber - Text Table2 PhoneDetailsID - AutoNumber PhoneNumber - Text Details - Text A Make-Table query SELECT...

Am a bit confused. Why do we have 4 tables with the same primary key? Why not a single table ? Thanks

Have you checked out VAL() ? Thanks

Or is it a something similar to people taking to alcohol, drugs, etc when faced with situations that they are not able to handle such as work stress, family stress, lack of or insufficient income, unable to handle or tolerate intelligent wom a/e n, unable to handle the questioning of females...