I'm running a simple summary query. Prior to summarizing values in three columns I get the text values (i.e., "Medicare") for column 1. If I summarize I get "䄂" in place of the original text values.
Using Access 2003, SP2 under WinXP
The query:
SELECT Qtr_Report_In_C ounty01.Memo, Qtr_Report_In_C ounty01.Program , Qtr_Report_In_C ounty01.Units
FROM Qtr_Report_In_C ounty01
GROUP BY Qtr_Report_In_C ounty01.Memo, Qtr_Report_In_C ounty01.Program , Qtr_Report_In_C ounty01.Units;
Sample rows being summarized:
Memo Program Units
Medicaid Crisis Intervention 2
1st/3rd Party CSP - Child 10
I'd work-around by taking the data out to excel, but my source is > 88k rows and over the 65k limit.
tia for any leads.
Dave Ebert
4 2236
I'm running a simple summary query. Prior to summarizing values in three columns I get the text values (i.e., "Medicare") for column 1. If I summarize I get "䄂" in place of the original text values.
Using Access 2003, SP2 under WinXP
The query:
SELECT Qtr_Report_In_C ounty01.Memo, Qtr_Report_In_C ounty01.Program , Qtr_Report_In_C ounty01.Units
FROM Qtr_Report_In_C ounty01
GROUP BY Qtr_Report_In_C ounty01.Memo, Qtr_Report_In_C ounty01.Program , Qtr_Report_In_C ounty01.Units;
Sample rows being summarized:
Memo Program Units
Medicaid Crisis Intervention 2
1st/3rd Party CSP - Child 10
I'd work-around by taking the data out to excel, but my source is > 88k rows and over the 65k limit.
tia for any leads.
Dave Ebert
Hi Dave
Try this
SELECT Qtr_Report_In_C ounty01.Memo, Qtr_Report_In_C ounty01.Program , SUM(Qtr_Report_ In_County01.Uni ts)
FROM Qtr_Report_In_C ounty01
GROUP BY Qtr_Report_In_C ounty01.Memo, Qtr_Report_In_C ounty01.Program ;
MMcCarthy 14,534
Recognized Expert Moderator MVP
Hi Dave
You've called your first field memo. Is it by any chance a memo data type. They often seem to cause problems in queries.
Other than that the main reason that ascii values get returned is because there are characters like carriage returns in the text. If you're not sure take some sample text out to notepad with the word wrap switched off it should all just appear as one line. If not then you will need to remove the line down characters. Find and replace should do it.
Thanks, it turns out the field was indeed a MEMO type. Changing it to text fixed my problem.
Thanks again.
Hi Dave
You've called your first field memo. Is it by any chance a memo data type. They often seem to cause problems in queries.
Other than that the main reason that ascii values get returned is because there are characters like carriage returns in the text. If you're not sure take some sample text out to notepad with the word wrap switched off it should all just appear as one line. If not then you will need to remove the line down characters. Find and replace should do it.
MMcCarthy 14,534
Recognized Expert Moderator MVP
Thanks, it turns out the field was indeed a MEMO type. Changing it to text fixed my problem.
Thanks again.
You're welcome.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Tron Thomas |
last post by:
What does binary mode for an ofstream object do anyway? Despite which
mode the stream uses, operator << writes numeric value as their ASCII
representation.
I read on the Internet that it is possible to change the behavior of
operator << so it will stream numeric values as their actual values
when an ofstream is in binary mode. I did not, however, find any
information on how this can be accomplished. What is involved in
getting this...
|
by: Pam Ammond |
last post by:
I need the code to update the database when Save is clicked and a text field
has changed. This should be very easy since I used Microsoft's wizards for
the OleDBAdapter and OleDBConnection, and DataSet; and all I'm doing is
showing one record in text fields, allowing the user to modify the text
fields, and then updating the database again when the user clicks the Save
button. The fields already show the correct data record since I have...
|
by: Arif imen |
last post by:
Hi to everybody,
I have chnged a button text in design mode. But After compiling and
executing the program
the text of the button do not change to new value.
Any Ideas?
Thaks for helps.
|
by: joelagnel |
last post by:
hi friends,
i've been having this confusion for about a year, i want to know the
exact difference between text and binary files.
using the fwrite function in c, i wrote 2 bytes of integers in binary
mode.
according to me, notepad opens files and each byte of the file
read, it converts that byte from ascii to its correct character and
displays
|
by: Martin Herbert Dietze |
last post by:
Hi,
I need to calculate the physical length of text in a text
input. The term "physical" means in this context, that I
consider 7bit-Ascii as one-byte-per character. Other characters
may be longer, e.g. cyrillic would be 2 bytes per character.
Is there a safe and easy way to notice non-7bit-Ascii input?
Cheers,
| |
by: Gregor Kovač |
last post by:
Hi!
Does DB2 handle extended ASCII table?
Example:
VALUES(CHR(65)) =A
VALUES(CHR(129)) =null, but according to www.asciitable.com should be u
with umlaut.
Any idea ?
|
by: apotheos |
last post by:
So I've got a problem.
I've got a database of information that is encoded in Windows/CP1252.
What I want to do is dump this to a UTF-8 encoded text file (a RSS
feed).
While the overall problem seems to be related to the conversion, the
only error I'm getting is a
"UnicodeDecodeError: 'ascii' codec can't decode byte 0x92 in position
|
by: sparks |
last post by:
I am working on a database that has a lot of calculated values on the
forms. These were never put into the tables. But were tied to unbound
fields on the forms.
Now 8000 records later they want these values in the tables.
All of this is done in modules after update of certain values entered
on the forms.
The calculations are called on current of the forms so they are
recalculated each time the form is opened.
I have no idea why it was...
|
by: JamesOo |
last post by:
I have the code below, but I need to make it searchable in query table,
below code only allowed seach the table which in show mdb only. (i.e. have 3 table, but only can search either one only, cannot serch by combine 3 table)
Example I have the query table below, how do I make the code to seach based on the query from this:
SELECT Product.ID, Product.Description, Quantity.Quantity, Quantity.SeialNo, Quantity.SupplierID,...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, well explore What is ONU, What Is Router, ONU & Routers main usage, and What is the difference between ONU and Router. Lets take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |