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
Showing all subrows in crosstab query by Ragnar Midtskogen
Calling all query gurus! I have a crosstab query where I group on two fields, and I can get the query to show all the first field but not the second. By...
May 26th, 2004 08:16 PM
by Michel Walsh Go to last post
3 1,085
GROUP BY/ORDER BY Question by BobRoyAce
I inherited a database which had the following query: SELECT MonthData.FiscalMonthNumber, (100* (SumOfKits/SumOfHours)) AS KitsPerHour FROM MonthData INNER...
May 26th, 2004 08:29 PM
by Go to last post
2 531
Parameter query question by Gina
I have a report that is pulling a form, which is pulling two subforms all attached to two queries with a parameter to pull employee number. All the parameters...
May 26th, 2004 08:32 PM
by Lynn Trapp Go to last post
1 337
Count Group By by Patrick
I have a table of transactions for multiple iterations of the same policy number. The Group By function works to LIST the distinct policy numbers, but how do...
May 26th, 2004 08:55 PM
by Michel Walsh Go to last post
2 628
Select Latest Records by dave
Didn't work for me. In addtion to returning the details for checking out on the latest date, it appears to return records that have a Checkout date that...
May 26th, 2004 09:27 PM
by dave Go to last post
1 581
Can't use memo field when using unique by Peter-Dave
Hi... I have a multi user database and one report they frequently use is based on a query that returns unique values with on of the fields being a memo...
May 26th, 2004 09:31 PM
by Peter-Dave Go to last post
3 390
Update Query by Leif
I'm trying to move information from a table to a set of normalized tables. To do this I'm trying to use an append query. The destination tables has one main...
May 26th, 2004 10:19 PM
by Leif Go to last post
2 632
Update Query by James Stephens
I have used this similar construction to do update from text boxes to a table but this one doesn't seem to work right and I am not sure what exactly is...
May 26th, 2004 10:41 PM
by James Stephens Go to last post
2 333
Query to List Reports and their recordsource by Dave F
Is it possible to create a query that will list all the Access reports and their recordsource? The database documenter gives too much information. I'm trying...
May 26th, 2004 10:46 PM
by Joan Wild Go to last post
1 531
Newbie: Using Left in query for report? by Ed
A co-worker and I are muddling our way through Access to try and build a report. I do Word, Excel, and VBA, and have tied myself in knots with Access before;...
May 26th, 2004 11:26 PM
by Ed Go to last post
3 933
Criteria for make table Query by Allison
I would like to use the Nz()function but your suggestion below is not working??? Here are the names of each field in my make table query. DIFF1: - tblIMPACT ...
May 26th, 2004 11:59 PM
by Ted Allen Go to last post
3 546
Updating 2 tables with 1 form - Access 2003 by Linger1974
Hello, I'm using Access 2003 with an Access 2000 database. I've got 1 form which is correctly pulling data from 2 tables. I'm having problems updating both...
May 27th, 2004 12:30 AM
by Ken Snell Go to last post
4 863
Multiple Drop Down by Dennis
I have a combo box that displays three related pieces of data. Grade1, Grade2 and Rate. I update the Rate field in my form with this combo box. What I would...
May 27th, 2004 01:52 AM
by Dennis Go to last post
2 322
Using Several Queries in a Calculated Field by Muraii
Hi there, A bit of background: I have 33 simple select queries, of the form recruit1 recruit2 recruit3
May 27th, 2004 03:00 AM
by Muraii Go to last post
3 362
Subtract in the same field by Jenna
How can I subtract the first row data to second row data within a column, for example: I have this columns Effective Date 5/1/04 5/3/04 5/4/03 I want to...
May 27th, 2004 04:49 AM
by Ken Snell Go to last post
1 445
Un matched query on more than one field by Mary
Gary, Thank you so much, it worked beautifully. I had fiddled around in SQL but didn't really know what I was doing. Your reply helped me understand a bit...
May 27th, 2004 07:29 AM
by Gary Walter Go to last post
1 317
Using a custom function in a query by BobRoyAce
Let's say I have a function in a global module called GetNames (which returns something like 'ARM','CAT') and I want to run a query like the following: SELECT...
May 27th, 2004 07:54 AM
by Gary Walter Go to last post
5 681
COMPARE THE TWO TABLES by Rick
PLEASE HELP!!! I HAVE TWO TABLES WITH THE SAME FIELDS, BUT TWO DIFFERENT SOURCES. ONE IS MY BROTHER'S ADDRESS BOOK AND ONE IS MY MOTHER'S BOTH TABLES HAVE...
May 27th, 2004 11:22 AM
by Michel Walsh Go to last post
3 462
Adding new record to query by Roy Goldhammer
Hello there I have table of citys with two fields CityID autonumber, city text(20) I've bilt the current query for adding new city: PARAMETERS prmCity...
May 27th, 2004 11:33 AM
by Michel Walsh Go to last post
1 312
Joining Queries: Problem by Tom
Hi all, I am trying to join two queries together, but the join is on a normal field in one query to a calculated field in another. The join is working fine,...
May 27th, 2004 11:54 AM
by Tom Go to last post
0 505
Post New Thread


Display Options
Showing threads 81 to 100 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:28 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.