A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Running & Setting Up Queries Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
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...
December 30th, 2009 02:29 AM
by John W. Vinson Go to last post
7 163
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...
December 30th, 2009 02:02 AM
by Bob Barrows Go to last post
8 196
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...
December 29th, 2009 09:25 PM
by Duane Hookom Go to last post
5 175
Changing existing primary key to autonumber by StageRight
Hi there, We have a database that has main and other tables linked based on primary key. Initially having the primary key be a manual entry was useful,...
December 29th, 2009 08:54 PM
by Bob Barrows Go to last post
3 175
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...
December 29th, 2009 08:13 PM
by Larry Linson Go to last post
1 122
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...
December 29th, 2009 07:09 PM
by John W. Vinson Go to last post
1 140
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....
December 29th, 2009 02:31 PM
by John Spencer Go to last post
1 170
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...
December 29th, 2009 03:44 AM
by John W. Vinson Go to last post
1 128
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...
December 29th, 2009 03:42 AM
by John W. Vinson Go to last post
3 141
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 10:00 PM
by yator Go to last post
3 164
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...
December 28th, 2009 09:11 PM
by Clifford Bass via AccessMonster.com Go to last post
1 143
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...
December 28th, 2009 07:36 PM
by Duane Hookom Go to last post
1 125
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...
December 28th, 2009 06:22 PM
by John W. Vinson Go to last post
3 158
Adding New Record to a linked table from Query by Steve Stad
Is it possible to add a new record to a linked table from a query. eg. Add new data record to table1 in db1 from a select qry in db2 on the linked table1. I...
December 28th, 2009 05:39 PM
by Steve Stad Go to last post
1 138
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...
December 28th, 2009 03:26 PM
by John Spencer Go to last post
6 159
Quick way to put all records in email field of query in Bcc of Outlook by Song Su[_4_]
Is there an easy and quick way to grab all the records in email field of query to put in Bcc of Outlook's new message? Looping each record in the set takes...
December 28th, 2009 03:58 AM
by Song Su[_4_] Go to last post
2 133
trying to create a sample table with 31,000,000 rows by Ian
I'm trying to create a table with 31 million rows so I created an append query. INSERT INTO rawdata ( , Data, UsageDate, ) SELECT 1284 AS Expr1, 10.586 AS...
December 28th, 2009 02:34 AM
by John W. Vinson Go to last post
6 170
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...
(Multi-page thread 1 2)
December 27th, 2009 11:36 PM
by PieterLinden via AccessMonster.com Go to last post
11 300
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...
December 27th, 2009 08:11 PM
by John Spencer Go to last post
1 153
Dynamic query -How? by AxisNovice
what are the types of dynamic queries? how can we use this ?
December 27th, 2009 03:11 PM
by bhicks11 via AccessMonster.com Go to last post
1 167
Post New Thread


Display Options
Showing threads 1821 to 1840 of 43289
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:45 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.