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
2GB Limitation by geebee
hi, I have a proces that updates tables, but during this update process, the size of the database reaches/exceeds the 2GB size limitation. Does anyone...
February 9th, 2007 11:36 PM
by Jerry Whittle Go to last post
1 112
can windows 98 download or can I copy by daphne11
I would like to copy a clip to a word document
February 9th, 2007 11:26 PM
by John W. Vinson Go to last post
2 124
sum n scores by Pete
I have a query which a previous visit to this forum gave me, it almost does what I require but not quite. Previous attempts to complete this have proved...
February 9th, 2007 11:12 PM
by Ken Sheridan Go to last post
1 92
alter table and order by by charlie
Assuming I have a table that has field "ttime" that represents time, and I want to add a column that contains an index that is corresponds to sorted ttime. For...
February 9th, 2007 10:50 PM
by Marshall Barton Go to last post
1 174
MakeTable query & split database by NetworkTrade
With a MakeTable query the resulting table is located on the Front End.... Is there a method to have it on BackEnd? -- NTC
February 9th, 2007 10:44 PM
by Marshall Barton Go to last post
6 190
Delete Query by hrskinn
THe delete query works if I enter the critertia 2006 But when I join the query to the history table, to make the delete dynamic. I get error message,...
February 9th, 2007 09:43 PM
by hrskinn Go to last post
2 101
Concatenate Function for unlimited characters by ALEX
I'm using a Concatenate Function, that works great. The only problem is that the new field created can only fit a certain number of characters. So not all...
February 9th, 2007 09:35 PM
by Duane Hookom Go to last post
6 117
Update query for removing spaces by Mike
I need an example of an update query to remove leading spaces in the values of a text field, e.g.: the value "_ABCD" should become "ABCD". Thank you in advance...
February 9th, 2007 08:16 PM
by Ember Go to last post
4 241
Calculating the Sum of two different fields in two different table by Moe
I am trying to find the "sum" of "OrderTotal" from "Orders Table" and "sum" of "PaymentAmount" from "Payments Table" then find the "Balance" by subtracting...
February 9th, 2007 07:57 PM
by Jeff C Go to last post
1 109
Need a non-replicating (duplicating) field by eatc7402
I am using Access 2002. I am writing a query can creates a 'flat' result from three other joined tables. One field is a memo field that contains a large amount...
February 9th, 2007 07:43 PM
by eatc7402 via AccessMonster.com Go to last post
4 116
Select Query on Continuous Form by SurveyorinVA via AccessMonster.com
Good afternoon, I have created a continuous form that has the following query has a record source: SELECT tblProjects.ProjectNumber, tblProjects.ProjectName,...
February 9th, 2007 07:38 PM
by tobesurveyor via AccessMonster.com Go to last post
2 91
Naming strategy, and math problem by BruceM
I have used the method described in Microsoft KB article 304458 to combine two Crosstab queries into a single Select (Totals) query in order to view more...
February 9th, 2007 04:57 PM
by BruceM Go to last post
0 84
Multiple Criteria in single field by Toullie1
I have a database that contains postcodes. I want to be able to search for multiple postcodes (the search criteria will change each time I run the Query) ....
February 9th, 2007 04:12 PM
by Klatuu Go to last post
3 84
Compile or Group field in Query by Pilgrim
I have a query that has 12 or so fields. In its records I have doubles in the code field. I would like to combine the the records that the code is the same....
February 9th, 2007 02:47 PM
by John Spencer Go to last post
1 133
Problem with concatenating multiple fields and records by Isaac Martin
I am fairly new to using Access and have recently completed the creation of a database used to track individual audit results. The audit has 28 questions, with...
February 9th, 2007 02:42 PM
by John Spencer Go to last post
7 113
How to get this table updated with a result from another query by Jennifer888
Hi, what I need to do is: query "a": select tbl1.name, tbl1.acctno from tbl1 group by tbl1.name, tbl1.acctno having...
February 9th, 2007 02:13 PM
by John Spencer Go to last post
2 105
QUERY DESIGN HELP by Malhyp
Hi there, I would like to know how I should be creating my query. I have listed an example of the database below. DATABASE NAME db1 DATABASE TABLES THEN...
February 9th, 2007 12:45 PM
by Malhyp Go to last post
2 112
Modified Date by Bill
Just noticed that all my queries have modified dates far more recent than any change by me. Any idea what could be doing this because I often need to order...
February 9th, 2007 11:58 AM
by Bill Go to last post
3 106
Help for pull out data from excel! by Danny
I got excel sheet with client's data For example: Name PO# Order Qty Price Ordertime David 12 1000 10000.00 ...
February 9th, 2007 05:39 AM
by [email protected] Go to last post
1 104
Converting column data into rows - reverse transpose by Amoun Raa
Hi, I need some help converting data as follows in an MS . Access database. Table Name: Table_Payments Currenlty the data looks as follows: Account ...
February 9th, 2007 05:36 AM
by Duane Hookom Go to last post
1 67
Post New Thread


Display Options
Showing threads 20241 to 20260 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 03:48 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.