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
Dup Entry Query by Peter Carlson
All of my records should have a unique ID (imported from a text file so it's NOT a key). I am looking for duplicate ID#'s My select should look something...
September 21st, 2005 04:39 AM
by Peter Carlson Go to last post
4 92
Change data name by Alex Martinez
Hello - Sorry for the double posting I am using Access 2002 and I need some help on my query. I have a field name "claim examiners", which I use the first...
September 21st, 2005 06:11 AM
by John Vinson Go to last post
1 97
Problem with Nested IIF by Laura_Christian
I am trying to set up a query with a calculated field (let's call it ) that contains a number of conditions. The query includes the following fields: , , ,...
September 21st, 2005 06:28 AM
by Laura_Christian Go to last post
2 133
Update query using Sum function by chilvs
Hi, I have a databse with a customer table and three seperate account tables all linked by CustID. Each account table contains a field called profit. I am...
September 21st, 2005 08:22 AM
by [email protected] Go to last post
4 94
Query by Jologs
Hi: I have 2 tables that have common structure. Both have 2 colums, (1) Account Title (2) Amount. I want to sum the Amount colums of the 2 tables. How will...
September 21st, 2005 10:17 AM
by Dennis Go to last post
1 149
Field contains no character by Steve Crowther
Trying to find out how to Query a field that doesn't contain any characters, alpha or numeric. I'm using 'Like "*"' for find records that do contain...
September 21st, 2005 10:57 AM
by Steve Crowther Go to last post
2 87
Primary Key re-setting to "0" by Richard Sunderland
I have a form with an underlying query for data input. It is brought up by entering the primary key in a search parameter box. All works fine, except when...
September 21st, 2005 12:41 PM
by Richard Sunderland Go to last post
4 83
Add records if do not exist? by SusanV
Hi all, I have a table with the following fields: PlanID PlanName LOM (plus other fields to be copied into the missing records, and a couple fields to be...
September 21st, 2005 01:16 PM
by SusanV Go to last post
7 141
Cross table Query by Paramasivan
Hi All, I have created a cross table query and exported the results manually to the other table. Can any one please help me to write a cross table query which...
September 21st, 2005 01:55 PM
by Paramasivan Go to last post
2 106
generate a temporary table by Darryl
Greetings, I am using Access 2000. Can a query be created that generates a temporary table, and then a report uses that temp table for input ? How about a...
September 21st, 2005 02:28 PM
by Darryl Go to last post
3 114
Format A Field In A SQL UNION Query by William Horton
Could anybody please instruct me on how to format a field in a SQL UNION query? My SQL statement is like the following: SELECT #1/1/2005# As...
September 21st, 2005 02:55 PM
by William Horton Go to last post
4 103
postcode search, lookup, finder by michael duncan
Anyone looking for an address finder or postcode search? Try postcode anywhere for a great range of online address...
September 21st, 2005 03:25 PM
by [email protected] Go to last post
1 199
Trim Spaces by Garry
Hi I need to trim some reference numbers in the form of B D AAA D A BCD etc too BD AAA DA BCD i.e. removing the first space
September 21st, 2005 03:41 PM
by Dennis Go to last post
1 114
Finding First, Last, Second Records by r. howell
Each job has a variable number of consultants (ranging from 0 to 5) The names and addresses of these consultants have to be printed out across the bottom of...
September 21st, 2005 05:07 PM
by r. howell Go to last post
2 97
Full OUter Join Help Needed by [email protected]
I have a trial balance master table (TB Master) with the following fields: Period (text, YYMM format) CoNo AcctNo AcctName Balance This table contains trial...
September 21st, 2005 05:29 PM
by [email protected] Go to last post
6 244
Cannot group on fields selected with '*' - bypass? by kennyharrill
I'm trying to develop an aggregate query for a table to summarize sales. I"m using Design View, selecting my table, clicking close, then double clicking what...
September 21st, 2005 05:47 PM
by kennyharrill Go to last post
2 165
Autonumber in specified format by DD
I'm creating a table with the help of a make-table query.One of the fields in the table REP_ID needs to have a start value of 1000 and should be incremented...
September 21st, 2005 06:38 PM
by oozyscab via AccessMonster.com Go to last post
1 125
help with error-new user by sigm
I'm trying to pull the max values within a certain field, but I need to keep the max values with the respective values in another table. I've got a device name...
September 21st, 2005 06:49 PM
by sigm Go to last post
1 73
how do i get my screen ,keyboard and mouse to work by sean caffrey
my computer turns on but the screen ,keyboard and mouse doun't come on, I have tryed them on another computer and they work fine. so please help
September 21st, 2005 06:51 PM
by Rick B Go to last post
1 189
Charting with Access by Ana
Hello u all, Were can I learn on Howto draw charts from query data? TIA Ana
September 21st, 2005 06:51 PM
by Duane Hookom Go to last post
1 80
Post New Thread


Display Options
Showing threads 10201 to 10220 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 11:46 AM.


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