f



Dsum , using numeric & Text help with the Text bit!

Acc 97
Hi,

I have the following in my query which works well if it is all set to
numbers on table design.

But what I want to do is where it states MC (short for machine name) use the
actual machine name of which there are 5 off. therefore, on the table design
I flick it over to text mode.

the query throws a wobbler! and all I get is Error!!

would a kind knowledgeable sole, show me how I need to modify this, so that
I can use Text setting only the end parts as identified as "MC="&[MC]


Note this works OK if all is numeric

 DSum("[tot]","[Query1]"," Expr1=  " & [Expr1] & "AND " & "  " & "MC=  " &
[MC])




Thanks, Alex



0
gerald1496 (13)
12/21/2003 11:42:42 AM
comp.databases.ms-access 42670 articles. 0 followers. Post Follow

1 Replies
476 Views

Similar Articles

[PageSpeed] 14

DSum("[tot]","[Query1]"," Expr1= " & [Expr1] &
    " AND MC = '" & [MC] & "'")

--
HTH
Van T. Dinh



"GERALD SHAW" <gerald@yas1.freeserve.co.uk> wrote in message
news:bs423h$r70$1@newsg4.svr.pol.co.uk...
> Acc 97
> Hi,
>
> I have the following in my query which works well if it is all set to
> numbers on table design.
>
> But what I want to do is where it states MC (short for machine name) use
the
> actual machine name of which there are 5 off. therefore, on the table
design
> I flick it over to text mode.
>
> the query throws a wobbler! and all I get is Error!!
>
> would a kind knowledgeable sole, show me how I need to modify this, so
that
> I can use Text setting only the end parts as identified as "MC="&[MC]
>
>
> Note this works OK if all is numeric
>
>  DSum("[tot]","[Query1]"," Expr1=  " & [Expr1] & "AND " & "  " & "MC=  " &
> [MC])
>
>
>
>
> Thanks, Alex
>
>
>


0
VanT.Dinh (6)
12/21/2003 8:02:16 PM
Reply:

Similar Artilces:

Get the real type of columns from MS Access databases(OLEObject, text, memo, numeric)
Hello, I made one application that opens MS Access databases.And I have one problem.How can I find the real data type of columns(text, memo, OLEObject, numeric) like it is into Access.I tried with resultSetMetaData.getColumnType(columnIndex) but I receive java.sql.Types.I have two columns that contains OLEObjects(images).But I receive two different types for columns : VARCHAR once, and for second column SMALLINT.I only want to see the types like in Access(OLEObjects, Text, Numeric, Memo...).Thanks in advance! Best regards, Calin Pop ...

text + text
What is "text + text" supposed to do right now? It doesn't seem very useful to me. What about making "text + text" as an equivalent for "text || text"? Most strongly-typed programming languages do this. And MS SQL Server too, I think (CMIIW). -- dave ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org Am Freitag, 8. Oktober 2004 12:57 schrieb David Garamond: > What is "text + text" supposed to do right now? Nothing. > What about making "text + text" as an equivalent for "text > || text"? Most strongly-typed programming languages do this. And MS SQL > Server too, I think (CMIIW). What would this gain except for bloat? It's not like SQL is utterly compatible with any programming language; users will still have to learn all the operators anyway. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match Peter Eisentraut wrote: >>What is "text + text" supposed to do right now? > > Nothing. Then are these bugs? (7.4.5 and 8.0.0beta1 give same results). Frankly, the current behaviour is quite strange to me. ------------------ =...

text-text
Wondering how what I input to my UTF-8 terminal gets passed along through my patched [1] trn ... Cyrillic: А Б В Г Д Е Ж З И Й К Л М Н О П а б в г д е ж з и й к л м н о п IPA: ᴀ ᴁ ᴂ ᴃ ᴄ ᴅ ᴆ ᴇ ᴈ ᴉ ᴊ ᴋ ᴌ ᴍ ᴎ ᴏ ɀ Ɂ ɂ Ƀ Ʉ Ʌ Ɇ ɇ Ɉ ɉ Ɋ ɋ Ɍ ɍ Ɏ ɏ [1] https://groups.google.com/d/msg/comp.sys.raspberry-pi/7Z37Hdrm0DM/6aqD-reXFzAJ ...

Dsum , using Numeric and Text fields ????
Acc 97 Hi, I have the following in my query which works well if it is all set to numbers on table design. But what I want to do is where it states MC (short for machine name) use the actual machine name of which there are 5 off. therefore, on the table design I flick it over to text mode. the query throws a wobbler! and all I get is Error!! would a kind knowledgeable sole, show me how I need to modify this, so that I can use Text setting only the end parts as identified as "MC="&[MC] Note this works OK if all is numeric DSum("[tot]","[Query1]"," Expr1="& [Expr1]& "AND " & " " & "MC=" &[MC]) Thanks, Alex When you're querying against a text field, you need to enclose the value in quotes. You can do this using single quotes, but you'll run into problems if your string contains an apostrophe in it (O'Reilly), so my usual advice is to use Chr$(34): DSum("[tot]","[Query1]"," Expr1= " & [Expr1] & "AND MC= " & Chr$(34) & [MC] & Chr$(34)) If you're not concerned about apostrophes: DSum("[tot]","[Query1]"," Expr1= " & [Expr1] & "AND MC= '" & [MC] & "'") Exagerated, so that the quotes are easier to see: DSum("[tot]","[Query1]"," Expr1= " & [Expr1] & "AND MC= ' " & [MC] &...

Text & MS Access (David)
Hello, David, Since you were able to answer so many DBT questions really well, I hope you can help with mine. I have this file in notepad and I want to insert the data into MS Access db.&nbsp; DO you know how to do that ? Thanks<img height="16 src= http://forums.ni.com/i/smilies/16x16_smiley-happy.gif" width="16" border="0">. (Anyone else is welcome to answer.) Here's the attachment: TextData.txt: http://forums.ni.com/attachments/ni/170/165958/1/TextData.txt Do you already have an Access database table with four fields aka columns? And does each ...

Unbound text box, text>255, MS Access/PostgreSQL
Hello. I have the following problem with MS Access/PostgreSQL combination: There is a form in Access that has an unbound text box, used for entering a commentary of a batch of records. There is a DAO Append Query that has a parameter that is passed from the text box using parameter of DAO QueryDef object. I adjusted B7 parameter (Text as LongVarchar) in connection string (ODBC driver) to 1, so that Access links PostgreSQL Text fields as Memo fields in Access. The intention was to be able to enter unlimited length commentary into the field. But, although I can enter unlimited text by using bound text box in some other forms, in this particular form I can't use bound control, so I need to pass text from UNBOUND control to the linked table by using DAO or ADO code. It seems that DAO query can't accept Memo as parameter, but only text. If my text exceeds length of 255, I have an VBA error 3271. If text in unbound text box is shorter that 255 everything is OK. So, is there any way to pass text of length >255 from unbound text box to Memo field of linked PostgreSQL table, by using DAO or ADO ? Thanks in advance, Zlatko On Mon, 3 Oct 2005 01:15:54 +0200, "Zlatko Mati�" <zlatko.matic1@sb.t-com.hr> wrote: >Hello. >I have the following problem with MS Access/PostgreSQL combination: >There is a form in Access that has an unbound text box, used for entering a >commentary of a batch of records. >There is a DAO Append Query tha...

Importing text files into MS Access using a Macro
I have 2 problems: 1. I want to import a single text file into an access table using a Macro. I am however getting an error that I need to put a specification name argument. What does this mean? It also suggests that I add a schema.ini in the source folder. What does this .ini do and how do I create and use it? 2. After this is resolved, I would like to be able to import several text files using a macro into the same table. Thanks I'm sure others will be able to shed more light on this: To create an import/export specification, launch the Import Wizard: File | Get External Data | Import... Point to the desired txt file Select the "Advanced..." button Specify the field delimiter, the text qualifier (you might want to select "" in case some of your incoming text fields have punctuations, etc.), and the field names and data types, etc. Then select "Save As" and give that set of specifications a name. You can now use this set of import/export specifications in a macro or in a VBA module. To see these specs as they are saved in the mdb file, select Tools | Options | View, and check System Objects. You'll now see the tables, MSysIMEXSpecs and MSysIMEXColumns. PS you might want to "unshow" these system objects once you've looked at them so you don't accidentally hose them... chimambo@googlemail.com wrote: > I have 2 problems: > > 1. I want to import a single text file into an access table using a &...

How to import a tab delimited text file into MS Access database
Hi, I have the following task to be done in VC++ 6.0. I have a tab delimited text file that needs to be imported into a MS Access table. The table is created and the table structure is defined using DAO methods. So now I have to fill this table with the data in the text files. For a few rows in the text file, the number of columns could be less than the number of columns in the table. Can anyone please post me the code to do this. Thanks a ton in advance. Pradeep wrote: > I have the following task to be done in VC++ 6.0. We'd be happy to give you the VBA code, but do you really want to throw away your C++ and use Microsoft Access for the job? If you want to keep C++, you can ask for C++ code in another newsgroup, because we'd just be guessing. -- Message posted via http://www.accessmonster.com ...

Forcing a New Line in a Text Field in MS Access using VB
Heya! I feel I'm beating an old horse to death with this question but I can't get around the problem. I want to update a text field on a form with a string from a VB module. I need enter/linefeeds in the string. I've tried: Chr(10) & Chr(13) Chr(13) & Chr(10 vbnewline vbcrlf none of which seem to work. I've set the properties for the text box to [Enter Key Behavior] = 'New Line In Field' and [Can Grow] = 'yes'. At the moment, my code looks like this: celsql = celsql _ & "Program: " & encname _ & vbCrLf _ & vbCrLf _ & "Start Time: " & sttim _ & vbCrLf _ & "Participants: " & numpart _ & vbCrLf _ & "Confirmed by Curator: " & cbc _ & vbCrLf _ & "Client: " & clntnm _ & vbCrLf _ & "Contact: " & cntct _ & vbCrLf _ & vbCrLf Forms(frm)(bts) = celsql If I toss this string into a [MsgBox], it comes out fine. It's just something about the text field... I'm working in MSAccess 2007, but need it backwards compatible to 2003. I'd really appreciate any advice. Cheers, KG I've seen this type of problem before, but I typically just use a separate text box for each data field. Is there a par...

HELP! Retriving field names and properties from MS Access database using ASP
Hi everyone! I have a really frustrating error and need help. I&#8217;m trying to do a function that gets the properties and names of the fields in a MS Access database using ASP. I haven&#8217;t programmed in a while so I&#8217;m quite lost. Once I have the my database structure I will insert the corresponding fields from a web form but the database is huge and I want to be able to change the database and form without changing the ASP code all the time. This is my function that is not working yet. I cant seem to connect properly to the database... Function InsertDataBase() ...

how to import text field from MySQL db to MS Access 2003 using ImportXML
Hi Guys, I'm trying to import data out of MySQL db to MS Access 2003 using ImportXML. I don't have any problems doing the import, except for one table with a "text" field defined. I'm getting an error message saying "The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.". Thanks, Do you have to use ImportXML? Why can't you use the ODBC driver to MySQL? Linda <nepifanio@gmail.com> wrote in message news:1137431763.824498.100740@g44g2000cwa.googlegroups.com... > Hi Guys, > > I'm trying to import data out of MySQL db to MS Access 2003 using > ImportXML. I don't have any problems doing the import, except for one > table with a "text" field defined. I'm getting an error message saying > "The field is too small to accept the amount of data you attempted to > add. Try inserting or pasting less data.". > > Thanks, > MS Access is not allowed to directly access the data from mysql db. The data from mysql db is exported in xml format using a system (with user login/password) and then imported into MS Access. I'm not exactly sure what cosmic events make it work for me, but I do it all the time. I access tables in a MySQL database using MS Access. I make edits and run reports. Linda <nepifanio@gmail.com> wrote in message news:1137532447.886457.233460@g14g2000cwa.googlegroups.com... > MS Acces...

Accessing MS ACCESS database using Data Environment
HI, I have developped a program in Visual Basic 6.0 using MS Access database. I have created all my reports through Data Environment where I have entered the location of my database file (for e.g c:\project\app\test.mdb) in the Connection properties. I have installed my application on another PC using Package & Deployment wizard. When viewing the reports on the other PC, I have to enter everytime the new location of the database. How can I solve this problem, please? nadia wrote: > HI, > I have developped a program in Visual Basic 6.0 using MS Access database. >...

Using Control-a to select all text in a text widget
I'm having a difficult time binding Control-a so it selects all the text in a widget just like the default Control-/ binding does. I've tried: ..t bind <Control-a> [.t bind <Control-/>] But [.t bind <Control-/>] returns nothing. If I do: ..t bind <Control-/> {puts "Selecting all"} ..t bind <Control-a> [.t bind <Control-/>] When I hit Control-/ I get at the prompt "Selecting all" and all the text is selected. But when I hit Control-a all I get is the "Selecting all" at the prompt and no text is selected. I've also tried: ..t bind <Control-a> {.t tag add sel 1.0 end} And that doesn't work either. In fact, with this code if you do Control-/ and then Control-a it unselects everything. And dumping the tags for the entire region show the tagon/tagoff for sel are gone. Does anyone know the semantics of Control-/? There's got to be more to it. - Ian I've just found this thread: http://groups.google.com/group/comp.lang.tcl/browse_thread/thread/5c1df73696e94962/38ec894e32bafcd2?lnk=gst&q=select+all&rnum=8#38ec894e32bafcd2 Which seems to suggest there's nothing fancy about Control-/. - Ian And to answer my own question, the following works: bind .t <Control-a> {%W tag add sel 1.0 end; break;} - Ian On Wed, 01 Aug 2007 16:54:06 -0000, sniff.scratch@gmail.com wrote: >I'm having a difficult time binding Control-a so it selects all the >text in a w...

Old ms-access file, showing wrong text in access xp
Dear sirs: I've one old .mdb file ( since 97). now when I open it, it converts most of text to strange unicode characters. can I stop this conversion and ask access to just show original non-unicode characters? Thanks Bijan ...

Wrapping Text
I'm trying to export an Access table to a pipe-delimited text file (with no text qualifier) and it keeps wrapping the text for one of the tables. None of the fields are particularly long, so I'm not sure why it's doing this. Any ideas how I can stop it from wrapping the text in the text file? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200803/1 Leviathan wrote: >I'm trying to export an Access table to a pipe-delimited text file (with no >text qualifier) and it keeps wrapping the text for one of the tables. None of >the fields are particularly long, so I'm not sure why it's doing this. Any >ideas how I can stop it from wrapping the text in the text file? Nevermind, figured it out. Looks like there was a carriage return in defining one of the cells in the query. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200803/1 ...

Using Crystal Reports in MS-Access & Use of timer event
Farid Khan wrote in an e-mail message to me: > dear sir would you tell me how to use the crystal reports > in ms access and the use of timer. > thank you. Alan Webb ...

$1 Month
FYI - If you're shopping for a Usenet provider, Newsguy.com's current special may be worth a look. Get 2 newsgroup accounts for the price of 1. Includes all account types & service terms (1, 3, 6, or 12 months). For example... buy a 6-month newsgroup account for $12 (3GB month) and get a second 6-month account free. Give the free account to a friend, or combine the two accounts to make one. That works out to $1 month for newsgroup access, and all their accounts include... - Text & Binary newsgroups - NNTP & Web access - Newsgroup search engine - Unused...

Footnote text disappears if used inside \mbox...any suggestions on how to keep text together within a line without using \mbox?
Hello, At the end of a paragraph I have a footnote and the footnote doesn't fit in the last line (Latex puts it in the next line and it doesn't look ok a line with a single footnote number). I tried to solve the issue using mbox, but although the footnote number stays in the last line together with the last text of the paragraph, the footnote itself disappears from the text. The text: ....As a result, $W-eH-Z$, where $Z\sim U[\underline{Z},\bar{Z}]$. \footnote{Alternatively, blabla.} My solution (footnote text disappears): ....As a result, \mbox{$W-eH-Z$, where $Z\sim U[\underline{Z},\bar{Z}] $. \footnote{Alternatively, blabla.}} Any ideas on how to force \mbox to show the footnote text? Any suggestions on how to keep the footnote number together within the last line without using \mbox? Thanks, Herman hzb.hhh@gmail.com wrote: : Hello, : At the end of a paragraph I have a footnote and the footnote doesn't : fit in the last line (Latex puts it in the next line and it doesn't : look ok a line with a single footnote number). Guess why. : ...As a result, $W-eH-Z$, where $Z\sim U[\underline{Z},\bar{Z}]$. : \footnote{Alternatively, blabla.} An EOL is equivalent to a space when TeX/LaTeX reads a file. In linear representation you've written (Watch this space!) v \bar{Z}]$. \footnote{Alternatively, blabla.} You either do \bar{Z}]$.\footnote{Alternatively, blabla.} or better (depends on your desired style) \bar{Z}]$\footnote{Alternat...

Assistance parsing text file using Text::CSV_XS
Hello. I'm trying to parse a text file into a 2-d array using Text::CSV_XS. The input file is structured as follows. "Fields" are separated with a "\x0d\x0a" (CRLF) and are enclosed in double-quotes. "Records" are separated with a "\x0c" (FF). My fields can contain embedded CRLF's hence the need for double-quoting. How can I use Text::CSV_XS to solve my problem? My code below only outputs the first line in the input file. Thanks in advance. #!perl use strict; use warnings; use diagnostics; use Text::CSV_XS; our $g_file_input = shift @ARG...

Pages
I have a titel-textfield over a pic (headline) , text is black, background for text transparent. A second textfield should overlapp the first textline..... When i arrange the second field with the same settings like the first, the first text disappear... How can i do, that the second text overpapps the first, all over the pic. Any help appreciated! Thanks for replies! I am german and hope that the engish speaking people understand my problem! Soory! Gerd In article <611db9e2-b085-4fe5-907a-ca714b0c32dd@m74g2000hsh.googlegroups.com>, hurlebaus <gerd.schenk@freenet.de> wrote:...

Surrounding text with text
I was wondering if it was possible to surround a text body with text like so: +--------------+ |ABCDEFGHIJKLM | |H N| |A Main Body O| |L Text goes P| |B here Q| |-=+_ZYXWVUTSR | | | | | | | | | +--------------+ This seems far-fetched, but just curious. I suppose that I could just move stuff around by hand in the GIMP later on, but there's probably a {better,more {extensible,clean}} way of doing it from (La)TeX. -FreeSmith ptjm@interlog.com (Patrick TJ McPhee) wrote in message news:<bffbhe$per$1@news.eusc.inter.net>... > Peter Flynn had an example like that, which he either posted here or > posted a link here. It was something to do with a certificate -- try > searching for his name and that word in google. > > It wouldn't be hard to do with metapost. I have a macro called `pathalong' > which puts text along an arbitrary path. Well, it's been a while, but I finally finished it. It's a little job I was doing for an upcoming wedding. At any rate, I used pstricks to make the text go along a path, along with a couple of hacks for sizing (from graphicx) and kerning along the line (from soul). Here's the code (don't laugh): CAUTION:THIS CODE MAY MAKE YOU WRETCH ---SNIP--- \documentclass{article} \usepackage{graphicx} \usepackage{pstricks,pst-text,nopageno} \usepackage[width=8.5in]{geometry} \usepackage{soul} \begin{document} \thispagestyle{empty} \set...

How do I use a text file as a database ?
I am trying to populate a vb6 datagrid control using the adodc control and a database file. Everything works well when I use an ms access database, but if I try to use a text database it doesn't seem to work. Any ideas ? thanks rex "Peyter" <Peyter@btinternet.com> wrote in message news:<bp3a2c$mmh$1@sparta.btinternet.com>... > I am trying to populate a vb6 datagrid control using the > adodc control and a database file. Everything works > well when I use an ms access database, but if I try to > use a text database it doesn't seem to work. Any > id...

text 2 text
I'm rather new to ustation and am having trouble finding replacements for all of my Acad lisp routines. One that I'd like to find changes a selected text string to read like the second selected text string. I realize this can all be done in the text editor but it's not all that quick. Does anyone know of a macro or mdl which can handle this task? Thanks in advance.---Calvin I don't know of any application that will do what you describe, but have you looked at Edit > Find/Replace text? You may also find Bentley's discussion groups of assistance. Over there you can meet other users of Bentley products, exchange ideas, and discuss a wide range of technical subjects. These groups are an excellent technical resource for all users of Bentley products and services. Hope to see you there! For more information take a peek at this page: http://selectservices.bentley.com/discussion/index.htm -- Best Regards, Inga Morozoff [Bentley] www.askinga.com "jgonzales24" <jgonzales24@cox.net> wrote in message news:xcLMb.13975$zs4.2376@fed1read01... > I'm rather new to ustation and am having trouble finding replacements for > all of my Acad lisp routines. One that I'd like to find changes a selected > text string to read like the second selected text string. I realize this > can all be done in the text editor but it's not all that quick. Does anyone > know of a macro or mdl whi...

Text from required text box to read-only text box
Hello, I am fairly new to JavaScript and its use in Acrobat Professional. My situation is this: I have a form with a text box field which is required for the user to enter his/her name. I would like the required text box to display the name in all caps. I also need the user's name to appear in a read-only text box later in the form, which I would like to have the first letter of the user's first, middle initial, and last names to be capitalized. I would also like to have all required fields on the form highlighted in yellow, but the highlighting not printed. Lastly, I would like the...

Web resources about - Dsum , using numeric & Text help with the Text bit! - comp.databases.ms-access

Numeric keypad - Wikipedia, the free encyclopedia
A numeric keypad , numpad or tenkey , is the small, palm-sized, seventeen key section of a computer keyboard , usually on the very far right. ...

App Store - Numeric Convertor
Read reviews, get customer ratings, see screenshots, and learn more about Numeric Convertor on the App Store. Download Numeric Convertor and ...

Sesame Street: Numeric Con (Preview) - YouTube
The greatest number lover's convention is coming to Sesame Street this year! Big Fan of the number 5? number 2? The dark number 9? Well then ...

How-to: Strengthen your iOS security with a multi-numeric passcode
Num pad with secure passcode While many of us know about and use the simple four digit passcode or more complex alphanumeric passcode to secure ...

Filling In The Boxes Is Harder Than It Looks In SeQu, The Numeric Puzzle Game On iPhone
... entertained for quite some time, especially if you like dealing with numbers. Filling In The Boxes Is Harder Than It Looks In SeQu, The Numeric ...

Price Drop: Numerics
Numerics - Dashboards to visualize your numbers 1.1 Device: iOS Universal Category: Business Price: Free, Version: 1.1 ( iTunes ) Description: ...

Satechi Wireless Numeric Keypad available now
... keyboard and a number pad on an 11 or 13 inch laptop. Those two sizes have become increasingly popular. Typically, a number pad, or numeric ...

Numeric Con And Cosplay Comes To Sesame Street
Sesame Street introduces us to it's version of Comic-Con, Numeric Con, in this trailer for an upcoming episode. We also get to see muppet versions ...

Bernanke Says Fed Looking ‘Carefully’ at Numeric Thresholds
Federal Reserve Chairman Ben S. Bernanke said U.S. central bankers are looking “very carefully” at proposals to link changes in monetary policy ...

Man Group in talks to buy Boston fund manager Numeric
... The world's largest listed hedge fund manager Man Group PLC (EMG.L) confirmed Thursday it is in talks to buy Boston-based fund manager Numeric ...

Resources last updated: 3/21/2016 7:57:51 PM