Recent content by Victor70
-
V
Criteria in query is disregarded
Thank you very much for your responses. Apologies for being inconsistent with my data sample. I have the same problem not only with date fields. Pat, I think you are right that PKs matter. I just know that my peers sometimes even skip this step, and they don't have this issue. Moreover, SQL... -
V
Criteria in query is disregarded
Jdraw, thank you for your response! This is the query. It would be hard to mess up with the one as simple as this. SELECT INVCTRL.PO_NO, INVCTRL.REC_DATE FROM INVCTRL WHERE ((INVCTRL.REC_DATE)>=#1/1/2012#); I really cannot provide a sample file because I am experiencing the problem with... -
V
Criteria in query is disregarded
Hello, Access experts. I have an issue with my Access queries. Whenever I link an external table from one of our data warehouses and run a query off it, I receive much more (if not all) records than I was supposed to with the criteria I have entered. I have never seen anything like that, and... -
V
Operation must use an updateable query - "improvement" in Access 2003
Hello, everyone, I have a legacy query that used to work in Access 2000 fine. After installation of Access 2003 (now I have both 2000 and 2003), I started getting this message - "Operation must use an updateable query". I found a link to an article that explains this "improvement" -... -
V
Determine the code of a character
Hello, everyone. I have trailing spaces that do not appear to be spaces (they are not trimmed by the Trim function). How can I determine the code of a character in a string (like 160 for no break space)? Thanks in advance, V -
V
Left Join is returning wrong data
Like I said, this expression is in qryEmployeesB&N. I am using then a left outer join to join it with tblActivities, from which I should be getting all records from the table and only those records from the query where the joined fields are equal. The picture I attached before shows that the... -
V
Left Join is returning wrong data
That's exactly what I have there right now. I should be getting Bs, NBs, and blanks, while I am getting Bs and NBs. -
V
Left Join is returning wrong data
Thanks for your input, Bill! Group1: IIf([emsection]="UP",IIf(Mid([emshift],2,1)="B","B","NB"),"B") Your are right. The UP can be B or NB. This expression is part of the query. I am filtering out the emsections that I do not need in it. This query qryEmployeesB&N and tblActivities are left... -
V
Left Join is returning wrong data
Thank you, Bill. The false part of my iif statement is "B" highlighted red. The true part is somewhat convoluted because I have to "extract" the second letter from emshift and check if it is B or not B. The problem still persists (as it can be seen in the picture attached). I get Bs for... -
V
Left Join is returning wrong data
The expression in the query is Group1: IIf([emsection]="UP",IIf(Mid([emshift],2,1)="B","B","NB"),"B") The last "B" gets assigned all over the place in my final left join query. However, since the expression is only in the sourcing query, it is supposed to assign "B" to every non-UP entry in my... -
V
Left Join is returning wrong data
Thank you, PNGBill and Jdraw! I changed Group to Group1, Date to Date1. In fact I did not have Activity field (I simplified the name for this example, not realizing that this may impact the result). The result is still the same (see the picture attached). Field10 there is the ID. Everything... -
V
Left Join is returning wrong data
Hello, Access experts, I have query "qryEmployeesB&N" (unique records, certain employees but not all) ID LastName FirstName MName Suffix Department Group and table "tblActivities". ID Date Activity X 1/1/12 YYY X 1/2/12 YYY Y 1/1/12 YYY I am working on a query that would give me name and...