Search results

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

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

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

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

Hello, Is it possible to create a make-table query out of a join query? If yes, how do I incorporate the INTO statement in my join query? Whenever I change the type of the join query from SELECT to MAKE-TABLE, all my SQL statement gets deleted. Thanks in advance.

Dear experts, I have multiple records associated with the same person (name_id is a unique key per person). I need to create a list with one row per person and all records concatenated in that row. PersonA Record1 PersonA Record2 PersonB Record3 PersonB Record4 PersonC Record5 into PersonA...

Dear Access experts, I have a query where I want to distinguish between cases happened in my city versus others. There are multiple ways one can misspell that, so I am using wildcard search for this: IIf(Trim([dbo_nmmain].[city])="PORTS*","Portsmouth",[dbo_nmmain].[city])This works fine for all...

Hello, My apologies for probably a very simple question. I inherited various queries and forms. I sometimes need to slightly modify a form but cannot identify the query (table) that this form was built upon. How do I go about determining this? Thanks in advance.