|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
|
|||
|
|||
|
I have a report that runs off a query in Access 2000. It worked perfectly until a secretary entered data all in lower case. The case was corrected directly in the tables. Would this change cause the query to not run properly? I've perused the tables at greater length than I liked and everything appears to be where it should be, yet my report is suddenly not running properly after this change. All information that was inputted properly runs properly in the report, it's just the case changes that won't run. Any ideas on how to fix this?
|
|
#2
|
|||||
|
|||||
|
I suppose you have been hoping for an answer and wondering why no one stepped up to the plate.
Quote:
Quote:
There is no way for us to know if this affects your reports without an exhaustive review of your Access database. Personally, since I am not very fond of Access anyway, I am not really eager to do this, but maybe someone here would, if you wanted to post your table layout, and list the relationships with other tables. Quote:
__________________
The real n-tier system: FreeBSD -> PostgreSQL -> [any_language] -> Apache -> Mozilla/XUL Amazon wishlist -- rycamor (at) gmail.com |
|
#3
|
|||
|
|||
|
However for data used in DISTINCT, GROUP BY, ORDER BY, and certainly WHERE clauses case matters.
__________________
Matt - matt@fanhome.com FanHome.com - Where Sports Fans Connect (our SYBASE-backed vB Forums!) Sybase DBA / PHP fanatic ![]() Sybase v. MySQL v. Oracle | Why I don't like MySQL | Download Sybase TODAY! | Visit DBForums.com for all your RDBMS talk!
|
![]() |
| Viewing: Dev Shed Forums > Databases > Database Management > Can changing capitalization cause a report to not run? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|