|
|
convert "Text" into "Number" by
ali
I have a a table (due to many reasons!), my query of "price" is text,
Now,
I want to convert it from "Text" into "Number".
(Because later on i need to...
|
|
7 |
166 |
|
|
Run 3 update queries at once by
ironwood9 via AccessMonster.com
I have a table with three Yes/No fields used as “flags” …. I run a update
queries to set the value of these fields to True if certain criteria is...
|
|
8 |
199 |
|
|
Append ODBC tables into Access Table by
Ross
To All,
I am ODBC connected to a Teradata table having about 10 fields and 300,000
records.
I want to append these records into my Access table and am...
|
|
5 |
177 |
|
|
|
|
3 |
176 |
|
|
URGENT MATTER by
RICHARD McKAY- LAWFIRM
HELLO IFEANYI COULD YOU PLEASE CONTACT RICHARD McKAY AT PENMENS LAW FIRM AT
205-207 SARACEN STREET, GLASGOW, G22 5TQ.
THIS IS AN URGENT MATTER
YOURS...
|
|
1 |
124 |
|
|
increace package no by
prem
If possible pl give me the detail
i am working on a transport project
i have a invoice bearing 15 card board (consignment 1-15)
i have a invoice bearing 35...
|
|
1 |
142 |
|
|
Delete Query by
Sean
I have 2 tables each have the fields Material and Qty. Table 1 is the master
table and Table 2 is a table of Material and Qty I want to delete from Table
1....
|
|
1 |
172 |
|
|
Use of date/time by
Anthony Ching
I am using MS Office 2007. I have a query using Now() for the date/time. When
I generate the run-time version on my machine, it worked fine. However, when...
|
|
1 |
129 |
|
|
Excluding email data by
Cloudbuster[_2_]
I want to make a query that will show me only parts of the email addresses in
a specific field. So, if I have an email like , and I...
|
|
3 |
142 |
|
|
Evaluate String for Value from Table by
yator
I have a table that contains a field for Primary Diagnosis but
only a semi-colon delimited list of Secondary Diagnoses. The list is variable
in length and...
|
December 28th, 2009 09:00 PM
by yator
|
3 |
166 |
|
|
revers minus by
mh_amri
hi guyz,we have little office and want to make some regular thing machinary
here it is:
we sell stuffs(for example think us as a newspaper company) , we give...
|
|
1 |
144 |
|
|
Blank field in form by
Bvdman32
I have a query that gets some criteria (City and State) from a form.
I have the State field set up as a ComboBox connected to a local
table
I created. If a...
|
|
1 |
127 |
|
|
Query using a date criteria by
Eric Starn
I have a query that I have set the criteria by a date field - "=#12/1/2009#"
What I would like to do is have the query run with the same operators but
with a...
|
|
3 |
160 |
|
|
|
|
1 |
139 |
|
|
Update Query Randomization by
Ian
I'm now trying to update some of the data in a table with
UPDATE rawdata SET rawdata. = Int((1200-1+1)*Rnd()+1);
but it updates all the values to a single...
|
|
6 |
162 |
|
|
|
|
2 |
134 |
|
|
|
|
6 |
172 |
|
|
Where Not Exists by
Sue Compelling
Hi
Following on from Sunil's query - I had a similar time lag on my query below
- which works but takes forever (only across 7,000 records though) and tried...
( 1 2)
|
|
11 |
304 |
|
|
Double Booking Query by
Andy Day
At present I am developing a database for room bookings at work.
The point I am at is to put in a query to check for double bookings. So far this is fine, if...
|
|
1 |
155 |
|
|
|
|
1 |
167 |