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
1  1448 
DSum("[tot]","[Query1]"," Expr1= " & [Expr1] &
" AND MC = '" & [MC] & "'")
--
HTH
Van T. Dinh
"GERALD SHAW" <ge****@yas1.freeserve.co.uk> wrote in message
news:bs**********@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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: bandw |
last post by:
I am having a problem using Numeric-24.0b2 in conjunction with
the NetCDF module from ScientificPython (version 2.4.9).
This problem does not surface using Numeric-23.8. The problem
arises in...
|
by: Nathan Sokalski |
last post by:
I am using ASP to read code from a text file that I am displaying on my
page. Because I do not want the code from the text file to be executed, I
used the Server.HTMLEncode() method to display it...
|
by: Alex |
last post by:
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...
|
by: Sanka |
last post by:
I want to restrict users entering non numeric characters
in a text box
How can I do this?
If there is any code sample please answer or email I'll be
very glad
Thank you
|
by: Luciano A. Ferrer |
last post by:
look at
http://relojurbano.com.ar/ver.html
the idea is to obtain something like the bottom example
using ul & li... with a few breaks, and right aligned...
without change the 1234567890 order...
|
by: mmarif4u |
last post by:
Hi everyone,
I have a little problem in php coding.
i have mysql table guestbook:
Fields are Id,name,email,comment,datetime.
Now i want to search the database by php query using
a Dropdown menu...
|
by: Imicola |
last post by:
Hi,
I want to use primary key IDs in my tables which are autonumbers, with a text prefix. I.e. for table tblVillage, the ID's will by V1, V2, V3... and for table tblHumanCases, the ID's will be...
|
by: johnlim20088 |
last post by:
Hi,
Can someone tell me who to encrypt data using standard AES algorithm with 128 bit key in NET?
Also same go for Decryption.
We will have a key file for above encryption and decryption is...
|
by: FredZ |
last post by:
Hi all
I am a real pled here, so I am not entirely sure how to structure my question so I will just tell you what I want to achieve and what I have done and see if there is a solution.
The...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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,...
|
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...
| | |
