RE: [MS_AccessPros] Query not working properly

There is a master file with customer names & certain data related to pricing for direct service points (we are a trucking company). There are six other tables with location specific pricing or sales representative data. Only the five location specific tables are included in the query. The query has inner joins between the main table and the other location specific tables. Very simple. Worked fine until yesterday. Nothing else I know has changed. I won't provide the list of all the table field names. This is the part where the joins are expressed.

FROM ((((Tbl_rTPDirect INNER JOIN Tbl_rCalif ON
Tbl_rTPDirect.TPID = Tbl_rCalif.TPID) INNER JOIN Tbl_rIdaho ON
Tbl_rTPDirect.TPID = Tbl_rIdaho.TPID) INNER JOIN Tbl_rOROther ON
Tbl_rTPDirect.TPID = Tbl_rOROther.TPID) INNER JOIN Tbl_rOtherStates ON Tbl_rTPDirect.TPID
= Tbl_rOtherStates.TPID) INNER JOIN Tbl_rWash ON Tbl_rTPDirect.TPID =
Tbl_rWash.TPID;

Please remember, this still works fine for records entered prior to yesterday. It even picks up changes in those records. It just won't yield results from new records.
To: MS_Access_Professionals@yahoogroups.com
From: JohnV@msn.com
Date: Fri, 29 Mar 2013 17:07:45 +0100
Subject: RE: [MS_AccessPros] Query not working properly


























Lon-



What is the structure of the table and the SQL of your query?



John Viescas, Author



Microsoft Access 2010 Inside Out



Microsoft Access 2007 Inside Out



Microsoft Access 2003 Inside Out



Building Microsoft Access Applications



SQL Queries for Mere Mortals



http://www.viescas.com/



(Paris, France)



From: MS_Access_Professionals@yahoogroups.com

[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Lon

Sent: Friday, March 29, 2013 4:54 PM

To: MS_Access_Professionals@yahoogroups.com

Subject: [MS_AccessPros] Query not working properly



I have a 3,600 record database split into front and back ends. Users have

the front ends on their PCs. The database itself is in Access 2000 format on

a Windows 2003 server box.



I also have a Microsoft Word 2010 document with multiple fields linked to a

query in my database. To find the correct data to use in the Word document,

I used a filter based on an indexed code that is assigned to each customer

for which I want information.



Starting yesterday (March 28), any new customer entered in the database will

not show up in the Word document. If I change information in an customer's

record that existed prior to March 28, that information shows.



I finally have determined the query itself is at fault. If I run the query

itself with the new customer's ID code, the query won't find it.



I've never run into a query that quit working like this. Anyone have any

ideas? If you need more info to respond, ask away.



[Non-text portions of this message have been removed]


















[Non-text portions of this message have been removed]



------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/