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
Working with Auto-Incrementing field by quartz
I am using Office 2003 on Windows XP. Please note that the use of spreadsheets is per boss and user preference - this is mandatory and beyond my control. I...
September 16th, 2005 03:43 PM
by Carl Rapson Go to last post
1 81
Please Help!? Show/Don't show fields by A. Smart
How do I use criteria to show or not show a fiel, for example, I have an IIf function: IIf(!!="Text",(.)=True) I would only like to show this field when the...
September 16th, 2005 04:31 PM
by Jeff Boyce Go to last post
4 156
Merge Records by CCloud
I have a database with student names, student id numbers, parent names, a family number and email addresses. Every student in the school is listed multiple...
September 16th, 2005 04:52 PM
by Allen Browne Go to last post
3 149
Best Way to Dynamically Alter the Select List of A Query by A. Smart
With respect to my earlier post, I am trying to find the best way to dynamically alter the select list of a query. Any suggestions!! Cheers -- Regards Ashley...
September 16th, 2005 05:01 PM
by oozyscab via AccessMonster.com Go to last post
2 150
Report from Query - Select Max value by Gil Lopes via AccessMonster.com
Hi! I' m trying to build a report based on a select query. One of the querys fields states a price for a date series. I would like to retreive to my report...
September 16th, 2005 05:45 PM
by Gil Lopes via AccessMonster.com Go to last post
9 181
SQL Aggregate AVG function and GROUP BY Clause by ktm400
I have a query that goes like this: SELECT Avg(!) AS FROM ; I assume that this is going to add all the fields in the CurrentSteamflow column and average...
September 16th, 2005 06:27 PM
by ktm400 Go to last post
4 135
pivot table by AccessAddict
I can create a pivot table to show data from a query in the view that the user would like to enter the data into. However, the pivot table will not let me...
(Multi-page thread 1 2 3)
September 16th, 2005 07:16 PM
by AccessAddict Go to last post
21 1,041
Sorting records in a form by Jeff S via AccessMonster.com
I have a form that captures a lot of information on actions involving different products. This information is organized in a datasheet subform where each line...
September 16th, 2005 07:20 PM
by Jeff S via AccessMonster.com Go to last post
8 128
IIf help by DN
I have a query that uses IIf statements to calculate a point system from current horse shows based on place and number of entries. This is the query: SELECT...
September 16th, 2005 08:05 PM
by DN Go to last post
2 69
Returning a wildcard or value by Nathan Hughes
I have created a form from which to create tailored reports via several unbound input fields. There is an underlying query to form these reports. What I am...
September 16th, 2005 08:38 PM
by Bill Wilson Go to last post
3 80
Current report group as a query parameter by Jeff Polack
I have query that is the source for a sub-report. The main report using grouping (person, client). The query uses the client ID that appears in the client...
September 16th, 2005 08:54 PM
by [MVP] S.Clark Go to last post
1 99
HELP WITH "WHERE" clause by tamxwell
This is a complex query that shows debt agings for all our customers from CURRENT, 1-30, 31-60, 61-90, 91-181, 181-360, 360+ days. I have 2 tables joined,...
September 16th, 2005 09:03 PM
by tamxwell Go to last post
2 78
No Quary Results by Jay
Thank you for your readings. I have Quary1 and Quary2. Quary1 has text1 and Quary2 has text2 as fields. tex1 is same as text2 except it's orientation in a...
September 16th, 2005 09:10 PM
by [MVP] S.Clark Go to last post
2 86
import flat file into a table by gv
Hi all, Simple: I want to write a query to import data from a flat file(comma delimited) into a exisiting table in access using Access 2003? I don't want to...
September 16th, 2005 09:12 PM
by [MVP] S.Clark Go to last post
1 88
Question by JimS
I am trying to apply a label field to a query record based upon where it falls in a second lookup table. The look up table has a start date and an end date...
September 16th, 2005 09:14 PM
by Lori Go to last post
2 92
Using Calculated Fields to Calculate other fields by Clint Marshall
In Access XP, I'm trying to use the values of several calculated fields to create additional calculated fields, all within one query. Is there a way to do...
September 16th, 2005 09:32 PM
by Clint Marshall Go to last post
4 133
Access criteria expressions by Rynorem
I don't have a ton of Access use experience but: Job Titles is a column in the database. In Queries, the user can type in a word and it will find the job...
September 16th, 2005 11:10 PM
by Amy Blankenship Go to last post
4 128
how do i create multiple tables from a master table automatically? by Panos
i have a table that includes records for multiple deals (i.e., 100 records for deal ABC, 125 records for deal XYZ). from that master table, i would like to...
September 17th, 2005 01:30 AM
by John Vinson Go to last post
1 186
Help with append query for one-to-many relationship tables by Vika
Hello, Can anyone help me with this problem? I need to append a flat table to two tables. I have two tables Observations and ObservationsB that are set up to...
September 17th, 2005 08:29 AM
by SteveS Go to last post
1 223
How do I join data from 2 fields in same query? by thjofe
I have a FirstName and a LastName field that I am trying to join in a query under a column named Owner. The method that I am trying is as follows: Owner: & "...
September 17th, 2005 09:03 AM
by Allen Browne Go to last post
1 79
Post New Thread


Display Options
Showing threads 10101 to 10120 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:11 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.