Solved

Access 97 Query Error

Posted on 2014-04-08
5
224 Views
Last Modified: 2014-04-16
I have a query that stopped recognizing the number 2, only the number 2. it's a field called T-SHIFT NO, there are 5 shifts, 1,2,3,4,5. all other shifts are working as intended only shift 2     can not be searched for and it's only this one query.
0
Comment
Question by:Denthion
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 27

Expert Comment

by:MacroShadow
ID: 39987125
Can't answer without seeing the file.
0
 

Author Comment

by:Denthion
ID: 39988450
This is the SQL, Hope this helps a bit more.


SELECT TOTES.[T-TOTE#], TOTES.[T-DATE PROC], TOTES.[T-SHIFT NO], TOTES.[T-SHIFT NO], TOTES.[MI-LOT#], qryNetweight.Netweight, TOTES.[FPC-ID NUMBER], TOTES.[T-SUGAR], TOTES.[T-STARCH], TOTES.[T-MELOJEL], TOTES.[T-SAPP], TOTES.[T-SO2], TOTES.[RP-DESCRIPTION], TOTES.[T-TOTE COMMENTS], TOTES.T_MAJORDEFECTS, TOTES.T_MINORDEFECTS, TOTES.T_MOISTURE, TOTES.T_GRADE, TOTES.T_SUBGRADE, TOTES.[T-COST], TOTES.T_METALDETECT, TOTES.[T-DERIVATION]
FROM TOTES INNER JOIN qryNetweight ON TOTES.[T-TOTE#] = qryNetweight.[T-TOTE#]
WHERE (((TOTES.[T-DATE PROC])=[Enter Process Date]) AND ((TOTES.[T-SHIFT NO]) Like [Enter Shift Number or * for all] And (TOTES.[T-SHIFT NO])<>"4"))
ORDER BY TOTES.[T-TOTE#];
0
 
LVL 27

Expert Comment

by:MacroShadow
ID: 39988462
The SQL doesn't help, the data is needed. There is no reason that number 2 wouldn't be recognized. Perhaps the two's have a leading or trailing space.
0
 

Accepted Solution

by:
Denthion earned 0 total points
ID: 39995173
Access had become corrupted from an outside source. backed up the data and re-installed access, working fine again thank you
0
 

Author Closing Comment

by:Denthion
ID: 40003498
I traced back both the problem and what was going on when it happened, I was able to figure out that someone had imported bad files. I was not able to repair access, but was able to save the data and then reload the system after re-install.
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question