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
Paste errors when copying column name in a group by function by Anton
I have this really strange and annoying problem when using a group by in a query. To avoid names like sumOffTotalVolume I try to copy the file name 'Total...
June 25th, 2008 11:27 AM
by bhicks11 via AccessMonster.com Go to last post
1 220
Running Sum in a Query by NEWER USER
I am struggling with the DSum function in a query. I have 4 fields and want to calculate a Running Sum in the last column of the query. Number Group ...
June 25th, 2008 09:20 AM
by Allen Browne Go to last post
3 208
Linked SQL query performance after upgrade 97 to 2003 by SusieN
Following upgrade of a database from Access 97 to 2003 we are experiencing noticeably worse performance. We have a Find button (using the Access in built...
June 25th, 2008 03:17 AM
by Tony Toews [MVP] Go to last post
6 192
UPDATE query - Macros??? Visual Basic??? SQL??? Help! by Student Databaser
Ok so i need to populate a field with the contents of two other fields in this table and . Essentially this is what i need it do do, however i know i...
June 25th, 2008 01:14 AM
by John Spencer Go to last post
2 126
Query Exceeds the limit of data for a single record by Chi
I have designed a database for tracking results from surveys filled out by participants attending various workshops. I am running into problems with a query...
June 25th, 2008 12:32 AM
by fredg Go to last post
7 194
Access Query not working properly by Jean
Hi I have the following query that i am trying to make it work: SELECT ., . FROM INNER JOIN AS ON . = . AND . =. AND .=. And .=.+15 GROUP BY .,...
June 24th, 2008 11:59 PM
by KARL DEWEY Go to last post
1 113
Multiple queries vs. one query by shannaj via AccessMonster.com
I need help. Right now I use three queries with certain criteria in each one to access three versions of the same format of form. It is kind of a nuisance...
June 24th, 2008 10:11 PM
by shannaj via AccessMonster.com Go to last post
3 174
forms queries by elima
Hi, I need to create a form which has a button when the user clicks on the button it generates a query and produces a report from info in different tables. I...
June 24th, 2008 08:28 PM
by Klatuu Go to last post
1 117
Find the first value in a crosstab query by John
I have a crosstab query with YYYY-MM as column headings and cost codes as row headings. It looks something like: Cost Code, 2008-01, 2008-02, 2008-03,...
(Multi-page thread 1 2)
June 24th, 2008 08:08 PM
by John Go to last post
11 244
Using IIF on Exclusive Fields by Roger Denison
I'm trying to develop a query on a table that rather than have one column for the day ("Mon", "Tues", etc or "2", "3", etc), it has 7 columns of type...
June 24th, 2008 07:50 PM
by Roger Denison Go to last post
2 139
Union Queries - Parameter Value Prompt by Larry
I would like to combine information from two tables with identical data fields into one. I have used a UNION query. One of the fields contains numerical...
June 24th, 2008 06:08 PM
by John Spencer Go to last post
2 134
Query to create new table format by [email protected]
Hi, I'm trying to make a query that groups a table on 2 columns, then takes all the numbers from 1 of the ungrouped columns and puts them into rows, with a...
June 24th, 2008 04:23 PM
by Jeff Boyce Go to last post
4 133
Combine crosstab with other query info by LadyIlsebet
I have a database with many tables. One of them tracks employee ID (linked back to the main table), a requirement ID (linked to a table defining the...
June 24th, 2008 04:16 PM
by KARL DEWEY Go to last post
3 126
Crosstab Query: Column Headings! by Kath
Hi, I had tried to do the following in order to get the column headings in a crosstab query to appear with different names -- other than the default: 1....
June 24th, 2008 04:13 PM
by J_Goddard via AccessMonster.com Go to last post
2 199
Input and return multiple values from a query by Bill Beshlian
I have a query where I input claim number(s) and I want returned the claim number, last payment date and a check value of "OK" or "NO". Here is the SQL...
June 24th, 2008 04:07 PM
by Bill Beshlian Go to last post
2 129
Date and Time Problems by Jurrasicway
Can anyone please help with the following: I have a database of transations that are time stamped. The time stamp is as follows: 24/05/2008 23:22:47 What...
June 24th, 2008 03:17 PM
by Jurrasicway Go to last post
5 167
Can I use a drop-down list from a table as source 4 a parameter qu by venajoe
I am in the process of building a "Equipment Service Request" database. I want to create parameter queries that promptsusers for a value, say, manufacturer,...
June 24th, 2008 03:11 PM
by venajoe Go to last post
2 110
whitespace at end of data by jez123456
Hi Experts I have a table with the following user_names "Bill" "Fred" "Andrew" "Fred " As you can see, there are 2 Freds (one without a space at the end,...
June 24th, 2008 12:58 PM
by John Spencer Go to last post
4 211
Update - fill blank fields based on match by John
I have a table that is imported where two columns contain the same data for a number of rows. Unfortunatley, the second column only has data in the first...
June 24th, 2008 12:45 PM
by John Spencer Go to last post
5 137
Using wildcards in iif in expression builder by filip
I'm stuck in creating a selection criteria for a query. Based on a value in a Form, I need to select all records which are "Yes", if this text in the form is...
June 24th, 2008 11:43 AM
by Allen Browne Go to last post
3 146
Post New Thread


Display Options
Showing threads 10241 to 10260 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 10:01 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.