1,105,380 Community Members

Office XP/2002 Access not filtering

Member Avatar
ArtChess
Junior Poster in Training
90 posts since Jun 2004
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

hello, I am trying to help Jennifer who uses Access. The MS office is XP/2002.

When she keys in the information she needs it bring up all the data and not just the data she is asking for, so it's not filtering.

When she views SQL an astericks * shows up on one of the lines and it shouldn't.

I tried uninstalling and re-installing. Does anyone have any suggestions?

Also I asked when she used to have this problem. She statest she got the laptop in May and all worked well it had 2003 office then. But our company rolled back to 2002 b/c of compatibility issues, it was then the her issue occured.

thanks in adavance

Member Avatar
Tekmaven
Software Architect
937 posts since Feb 2002
Reputation Points: 258 [?]
Q&As Helped to Solve: 29 [?]
Skill Endorsements: 27 [?]
Team Colleague
 
0
 

Can you post the enitre SQL? Maybe give us a better idea about what she's entering, and what type of results you want?

If it's a WHERE sql clause, change the * to a 'whatever'.

Member Avatar
ArtChess
Junior Poster in Training
90 posts since Jun 2004
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

Select Dbo_customer.cust_nbr, Dbo_customer.cust_name, Dbo_ires_branch_daily.invoice_date, Dbo_ires_branch_daily.new_compl, Dbo_ires_branch_daily.used_compl, Dbo_ires_branch_daily.rental_income, Dbo_customer.br_code, *

Member Avatar
ArtChess
Junior Poster in Training
90 posts since Jun 2004
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

Select Dbo_customer.cust_nbr, Dbo_customer.cust_name, Dbo_ires_branch_daily.invoice_date, Dbo_ires_branch_daily.new_compl, Dbo_ires_branch_daily.used_compl, Dbo_ires_branch_daily.rental_income, Dbo_customer.br_code, *

Tek Maven the SQL is above:

Member Avatar
Tekmaven
Software Architect
937 posts since Feb 2002
Reputation Points: 258 [?]
Q&As Helped to Solve: 29 [?]
Skill Endorsements: 27 [?]
Team Colleague
 
0
 

I still don't understand what you are trying to acomplish..?

Member Avatar
ArtChess
Junior Poster in Training
90 posts since Jun 2004
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

I still don't understand what you are trying to acomplish..?

True. I am limited, as far as my experience and understanding of Access.. but the point of the matter is that a user used to be able to query a database and do filters so that it generates a list/report that she wants to see. She has been able to do so in the past using Office 2003, but when she reverted back to Office 2002 she is unable to.

You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: