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
Two Crosstab with one total by Nick
I am trying to get a running total on figures but am unable to do so. I can get them to show up on a query but unable to understand how they can be added...
March 22nd, 2008 05:54 AM
by Nick Go to last post
2 190
Inserting a period into a string by TLuebke
I'm having a braincramp. I want to count from the right 2 spaces and insert a "." so 12345 becomes 123.45 Also in the case where a dollar amount has...
March 22nd, 2008 01:23 AM
by John Spencer Go to last post
2 126
Calculated fields by Flofies
Hello my name is Carlos, this is the first question I post, if you need more infro in order to provide some help, please let me know: I'm creating a Database...
March 22nd, 2008 12:05 AM
by rpw Go to last post
2 126
Return (display) only part of a field by Brett[_2_]
Hello, How would I go about in SQL - Access to display only part of a field after a specific character? For example, In Invoice.Memo, there would be...
March 21st, 2008 10:58 PM
by Jeff Boyce Go to last post
2 162
Search by Text String Question by Qaspec
If column a contains a word contained in a list from a table I want another column to list that word. Example Table Data Comments Red...
March 21st, 2008 10:40 PM
by KARL DEWEY Go to last post
3 193
Execute query from textbox input by dboollu
I have a form which has a query made up of a few other queries (this may be an incorrect thing to do) as the Record Source. It has a three textboxes on the...
March 21st, 2008 09:23 PM
by Allen Browne Go to last post
3 177
Grouping by people already in the waiting room by Zb Kornecki
I would like to run a select query that groups the results by the number of people already waiting. this could be done based on either 2 or 3 columns. ...
March 21st, 2008 08:46 PM
by Zb Kornecki Go to last post
2 177
using the IIF by ACSer
i am having trouble with getting the statement to work like i need: IIf(.Counter=1,"First Request","Second Request ") AS Expr1 What I need to do is nest...
March 21st, 2008 08:43 PM
by John W. Vinson Go to last post
3 103
Counts of dates and sum of sales by month by rpw
Hi all, I don't know how to go about this and would really appreciate help on it. I have a table with the following...
March 21st, 2008 07:27 PM
by rpw Go to last post
2 145
Exporting query using the outputto or transfertext method by Emma Aumack
Hi all, Is there anyway to get around the row limitations in the outputto method. I have only 30,000 rows that I am trying to transfer and I like this...
March 21st, 2008 06:57 PM
by Emma Aumack Go to last post
0 158
Query Date Help by aldunford
I need to create a query that will do the following: these are my fields: resign date, hire date I need to subtract the resign date from hire date but I want...
March 21st, 2008 03:59 PM
by aldunford Go to last post
2 156
append query by Ernst Guckel
Hello, I am trying to add 1 record to a table using an append query... but it does not stop at one record... here is the code... strSQL = "INSERT INTO...
March 21st, 2008 12:27 PM
by John Spencer Go to last post
2 124
dsum in query by D
I have a field in query: New_Cost: +. I want a new field called Cost_Percentage which needs to Sum the column and divide by each record to get that...
March 21st, 2008 12:23 PM
by Gary Walter Go to last post
3 103
SQL to get all products ordered together by JRough
I need help with T-SQL syntax. I need all products ordered together. This would give me all products in an order. I don't want the orders with only one...
March 21st, 2008 12:14 PM
by John Spencer Go to last post
4 122
how do I setup a subcategory lookup based on category selected? by Brian
i'm setting up a table which has categories and subcategories. I want to do both with lookup listboxes in two seperate fields. I created another table with...
March 21st, 2008 09:27 AM
by Allen Browne Go to last post
1 210
Queries not running by TotallyConfused
What does it mean when you run a query and do not get results? However, if I create a new query it runs. I have had this db for awhile. Recently I had to...
March 21st, 2008 09:23 AM
by Allen Browne Go to last post
1 110
Tying records by Jeff
Hi I am working on an existing database. I want to create a query which pulls data from 2 child records of a parent. The first record in my query would...
March 21st, 2008 06:33 AM
by John W. Vinson Go to last post
2 91
summing duplicate data (--help a rookie please) by Dan
Hello - I have a table which looks like the...
March 21st, 2008 04:36 AM
by MGFoster Go to last post
1 88
OLE server? by TT
I'm using MS Access 2003 and doing homework about Pivottable. When I select Query that I would like to create Pivottable. There is a message shows" The...
March 21st, 2008 04:31 AM
by TT Go to last post
0 79
OLE server? by TT
I'm using MS Access 2003 and doing homework about Pivottable. When I select Query that I would like to create Pivottable. There is a message shows" The...
March 21st, 2008 04:30 AM
by TT Go to last post
0 92
Post New Thread


Display Options
Showing threads 12001 to 12020 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 01:39 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.