Query using expression for criteria retunring no results for one u

  • Thread starter Thread starter Sue Compelling
  • Start date Start date
S

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
 
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.
 
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 said:
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 said:
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
Click to expand...
Click to expand...
 
Back
Top