Search results

Pat, thank you.

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

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

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

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

Thanks a lot!

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

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

That's exactly what I have there right now. I should be getting Bs, NBs, and blanks, while I am getting Bs and NBs.

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

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

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

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

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

Thank you for your input!

Thank you. This makes sense on the front-end of this issue. notNULL & empty vs. NULL & Not Empty will produce different results. However, if I go to the back-end of it, to the table, I cannot see why I would have this difference. The blank cells in the table for both fields look very much the...

Please see attached the sample database. The query has two NZ functions - one works, another - does not. I believe this has to do with something very simple, but I cannot figure out what it is. Thanks.

Thanks a lot, jdraw! So, in this case "" is empty, but not isNull? The thing is that I have two fields (district and region). On the surface the query returns values and "blanks" (for not identified areas) for both of them. The data are coming from the table with all fields as text. The NZ...

Hello everyone, My query returns a numeric designator for the area that was determined and blank (null???) for those, that have not been identified. I cannot figure out why this does not work Region1: nz([Region],"Not Defined") but this works Region2: IIf([Region]="","Not Defined",[Region])...

Wow. I must admit that the syntax is not very much intuitive. Thank you, pr2-eugin!