Networks and queries

[Kassie42 via AccessMonster.com]

Hello,

I have a database from Access 97 set up in a network drive. The operating
system is Windows XP, SP 2. When viewing a query, two of the computers are
able to see all the information pulled from the query. The third computer
opens the query, but no information populates the fields. The fields are not
grayed out. We checked permissions and they are fine. This does not seem to
happen with all the queries in this database. It seems specific to this one,
but there is a possibiltiy that it is occuring in other queries and I have
not noticed it yet. We tried uninstalling and reinstalling Access, but still
have the same problem. Does anyone have any suggestions? I appreciate any
and all help.

Thanks,
Kassie

 

[Jerry Whittle]

Open the query in design view. Next go to View, SQL View and copy and past it
here.

 

[Kassie42 via AccessMonster.com]

Jerry,

Thanks for responding. I am not sure that I understand what to do. Can you
tell me what I should be pasting. I wasn't sure if it was the query from the
query screen or something from design view. Also should I paste over top of
what is on the SQL view?

Thanks so much,

Kassie

Open the query in design view. Next go to View, SQL View and copy and past it
here.[quoted text clipped - 11 lines]

Thanks,
Kassie

 

[Jerry Whittle]

Hi Kassie,

Assuming a version of Access before 2007, open the query in design view.
Next go to View on the menu and select SQL View. You should see some some
text that says something like:

Select this, that FROM TheTable WHERE......

Highlight this text and copy it. Put that text into a reply to this subject
here.

Some of us can read these SQL statements and get a good idea of what the
query is trying to do. This will help us to help you better.

--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Jerry,

Thanks for responding. I am not sure that I understand what to do. Can you
tell me what I should be pasting. I wasn't sure if it was the query from the
query screen or something from design view. Also should I paste over top of
what is on the SQL view?

Thanks so much,

Kassie

Open the query in design view. Next go to View, SQL View and copy and past it
here.[quoted text clipped - 11 lines]

Thanks,
Kassie

 

[Kassie42 via AccessMonster.com]

Oh my lands! Sorry about that. I was having a moment there. I was reading
into what you were asking. Here it is: SELECT [Employee Information].
LASTNAME, [Employee Information].FIRSTNAME, [Employee Information].LB_DATE
FROM [Employee Information]
WHERE ((([Employee Information].LB_DATE) Like "9/**/1998" Or ([Employee
Information].LB_DATE) Like "9/**/1993" Or ([Employee Information].LB_DATE)
Like "9/**/1988" Or ([Employee Information].LB_DATE) Like "9/**/1983" Or (
[Employee Information].LB_DATE) Like "9/**/1979"))
ORDER BY [Employee Information].LASTNAME;

Hi Kassie,

Assuming a version of Access before 2007, open the query in design view.
Next go to View on the menu and select SQL View. You should see some some
text that says something like:

Select this, that FROM TheTable WHERE......

Highlight this text and copy it. Put that text into a reply to this subject
here.

Some of us can read these SQL statements and get a good idea of what the
query is trying to do. This will help us to help you better.

Jerry,

[quoted text clipped - 13 lines]

 

[Jerry Whittle]

Hi Kassie,

I can't see anything specific with your query which would cause the problem,
but there are some problems with the query!

First if you open the tables in problem computer, can you confirm that there
are records that match what you are looking for? It's possible that the
database is linked to the wrong database file. I've done that myself.

Next it's a real shame that LB_DATE seems to be a text field. It's much
easier to work with dates that are actually dates and not text. Below is a
query worth trying on the problem computer to see if it returns the correct
records. Notice that it should be easier to maintain and read. Could even run
faster.

Val brings in the first numerical characters in a string so it should return
the month. I had to add the NZ function as Val doesn't play well with Null
values. If there isn't anything in the field for a record, the NZ returns a 0
instead which Val will see as a 0.

The Right function will take the last 4 characters off the string. Then you
can use In to put the list of years between the ().

SELECT [Employee Information].LASTNAME,
[Employee Information].FIRSTNAME,
[Employee Information].LB_DATE
FROM [Employee Information]
WHERE Val(NZ([Employee Information].LB_DATE,0)) = 9
AND Right([Employee Information].LB_DATE,4)
in ("1998", "1993", "1988", "1983", "1979")
ORDER BY [Employee Information].LASTNAME;

Is 1979 right? Seems that the years are 5 apart and it should be 1978.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Oh my lands! Sorry about that. I was having a moment there. I was reading
into what you were asking. Here it is: SELECT [Employee Information].
LASTNAME, [Employee Information].FIRSTNAME, [Employee Information].LB_DATE
FROM [Employee Information]
WHERE ((([Employee Information].LB_DATE) Like "9/**/1998" Or ([Employee
Information].LB_DATE) Like "9/**/1993" Or ([Employee Information].LB_DATE)
Like "9/**/1988" Or ([Employee Information].LB_DATE) Like "9/**/1983" Or (
[Employee Information].LB_DATE) Like "9/**/1979"))
ORDER BY [Employee Information].LASTNAME;

Hi Kassie,

Assuming a version of Access before 2007, open the query in design view.
Next go to View on the menu and select SQL View. You should see some some
text that says something like:

Select this, that FROM TheTable WHERE......

Highlight this text and copy it. Put that text into a reply to this subject
here.

Some of us can read these SQL statements and get a good idea of what the
query is trying to do. This will help us to help you better.

Jerry,

[quoted text clipped - 13 lines]

Thanks,
Kassie