Query using expression for criteria retunring no results for one u

Hi I have a query using the following expression: [Forms]![Contacts]![Donations subform]![DonationID] which returns the subset for two users though the third user gets no returned results. I have no idea why this would be the case and need some advice on where to start looking. (relatively novice designer). The TABLE database is on a shared server and each user has the FORM / QUERY / REPORT database on their hard drives. TIA Sue -- Sue Compelling

By chance are there more than one table involved in the query with an inner join between the tables? If so nothing will be returned unless there is a matching record in both tables. You could try changing the inner join to a Left or Right join and see what happens. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Sue Compelling" wrote: > Hi > > I have a query using the following expression: > > [Forms]![Contacts]![Donations subform]![DonationID] > > which returns the subset for two users though the third user gets no > returned results. I have no idea why this would be the case and need some > advice on where to start looking. (relatively novice designer). The TABLE > database is on a shared server and each user has the FORM / QUERY / REPORT > database on their hard drives. > > TIA > > Sue > > > -- > Sue Compelling

Hi Jerry Yes there are two tables, however I'm not sure this is the issue insofar as ALL 3 users have exactly the same application (albeit - copies) on their desktops (with 'linked tables' to the table db on the shared server). Two of the users get results from the query - the third user gets no results from the SAME query. Cheers Sue -- Sue Compelling "Jerry Whittle" wrote: > By chance are there more than one table involved in the query with an inner > join between the tables? If so nothing will be returned unless there is a > matching record in both tables. You could try changing the inner join to a > Left or Right join and see what happens. > -- > Jerry Whittle, Microsoft Access MVP > Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. > > "Sue Compelling" wrote: > > > Hi > > > > I have a query using the following expression: > > > > [Forms]![Contacts]![Donations subform]![DonationID] > > > > which returns the subset for two users though the third user gets no > > returned results. I have no idea why this would be the case and need some > > advice on where to start looking. (relatively novice designer). The TABLE > > database is on a shared server and each user has the FORM / QUERY / REPORT > > database on their hard drives. > > > > TIA > > > > Sue > > > > > > -- > > Sue Compelling

Similiar Articles:

Multiple Active Result Setc (MARS) - microsoft.public.sqlserver ...
Hi, Using SQL Server 2005, .NET 3.5 A simple task; 1. Obtain a result set based on criteria 2. ... the > results of a ... Empty string in query calc returns no ...

Re: Copy is criteria met - microsoft.public.excel.worksheet ...
Sum A String - microsoft.public.access.queries They're ... Correct ... laptop, so with a little copy ... using expression for criteria retunring no results for one u ...

Ampersand in Query Criteria - microsoft.public.access.queries ...
I'm pretty savy with using wizards and criteria expressions, but ... Office.com... to limit the results of a query based on the values in a field, you use query criteria. ...

Data Not Displayed in Query - microsoft.public.access.queries ...
null data not showing up if "is null" query criteria ... have a a database with one column with sparse ... TableAdapter Query Results Not Being Displayed in DataGridView Newbie ...

Is this Regular Expression for UTF-8 Correct?? - microsoft.public ...
... that make the decision a bad one. If dysfunctional results ... as true as the statement that no one ... alpha - microsoft.public.access.queries ... Is this Regular Expression ...

Examples of query criteria - Access - Office.com
When you want to limit the results of a query based on the values in a field, you use query criteria. A query criterion is an expression that Access compares to query ...

Access Tips: Query and Filter Criteria - Martin Green's Office Tips
You can often get the same results by using mathematical operators ... at the beginning, this is not an exhaustive list of query criteria. Many of these expressions ...

Nest a query inside another query or in an expression by using a ...
Sometimes you may want to use the results of a query as a field in another ... Examples of query criteria; Guide to expression syntax; In Operator; Introduction to queries

How to Create a Microsoft Access Query That Uses Multiple Criteria ...
Creating a query that uses multiple criteria for a field is like running a filter on your query results. For example, if you have a table that contains complete ...

Creating and Editing Query Statements - Microsoft Corporation ...
If you want to sort the query results by using this attribute, in the Sort list ... In the example, there are no parts of the criteria expression that require grouping.

7/25/2012 8:29:17 PM