Query using expression for criteria retunring no results for one u

[Sue Compelling]

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

 

[Jerry Whittle]

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.

 

[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

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.

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