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
querying first record for each day by kcg5
Hello all...I have data of sightings of killer whale types and would like to query only the first record of each day of each unique ecotype of killer whale....
July 12th, 2008 11:41 PM
by John Spencer Go to last post
2 145
Undefine function? by CAM[_2_]
Hello, In Access 2007 I get this error message - Undefine function "Right" in expression. There are 12 digits in the AccountNumber I just want to get the 8...
July 12th, 2008 11:39 PM
by Chris O'C via AccessMonster.com Go to last post
1 153
More than one parameter by ampickel
I set up a database to keep track of athletes enrolled in a soccer camp. The table is structured with first and last names, address, basically all...
July 12th, 2008 08:55 PM
by Pete D.[_3_] Go to last post
6 109
Counting in a query by RoBo
Who can give me a hand? I posted the question to the Dutch groups as well but got no answer that helps me further. In a table I have some fields with the...
July 12th, 2008 06:47 PM
by RoBo Go to last post
4 116
Match multiple field records to any sub records. (complex....) by efandango
Apologies for the possibility of a misleading title, but I am struggling to explain this in one short sentence, but I think this long standing problem is...
July 12th, 2008 01:28 PM
by Michael Gramelspacher Go to last post
1 135
Reports and queries displayed on website by Access queries and reports
I am creating a website and would like my Access queries and/or reports to run and display current data instead of static data. What do I need to do..or where...
July 12th, 2008 06:31 AM
by [email protected] Go to last post
1 159
Problem of dateAdd() function by Luting
Hi all, I have an error when using the function dateAdd(). Here is my sql statement: SELECT FLINK_N_OPERLOG.* FROM YQPW, FLINK_N_OPERLOG WHERE...
July 11th, 2008 10:10 PM
by KARL DEWEY Go to last post
2 132
Join Properties by Rebecca_SUNY
Does any one know of a shortcut for dragging and dropping to join two tables where you can automatically set the join to include all the records of the first...
July 11th, 2008 09:15 PM
by Jerry Whittle Go to last post
1 123
Alias by Dominick D.
Hi, Guru's...I've been asked to create a table, in which several fields contain aliases. Now, how do you code a fieldname to be an alias? Is it like this: :...
July 11th, 2008 08:48 PM
by Ryan Go to last post
1 112
Multiple parameter prompt in a query (InParam) by Marchelle
In earlier versions (2000) of Access I was able to create an InParam module and have the query prompt me for multiple values separated by a ",". 2003 or...
July 11th, 2008 08:46 PM
by Marchelle Go to last post
2 126
Pivot Table View - Multiple Charts by Grd
Hi, I have a Pivot Table View based on a query and I have the option set to show multiple charts. So I get a chart for each SalesPerson. By placing the...
July 11th, 2008 07:41 PM
by Grd Go to last post
0 111
Dinamically Build a CrossTab by John
I have a form with the following selections a user may select: 1. Date format: "Ordinal" or "Calendar" 2. Group By: "JV ID","CMIS ID", or "Craft" 3. Value to...
July 11th, 2008 07:18 PM
by John Go to last post
2 118
append table query by chilli_Novice
I need to append the results of a query into a table and one of the fields needs to have a value that is not a part of the query results. Is there a way to...
July 11th, 2008 06:35 PM
by chilli_Novice[_2_] Go to last post
2 133
if statements in queries by [email protected]
I am using fields on an initial form to query a second form. However, the query is not working. The two fields are first name and last name. If both first...
(Multi-page thread 1 2)
July 11th, 2008 05:22 PM
by bhicks11 via AccessMonster.com Go to last post
14 281
Crosstab Query Multiple by Ben Pelech
I am trying to find the easiest way to make a report or something that resembles an excel spreadsheet. The closest thing I have found is a crosstab query....
(Multi-page thread 1 2)
July 11th, 2008 05:15 PM
by Ben Pelech Go to last post
12 325
Update from other fields by Student Databaser
I want to populate the Trainer_ID field with 00+First three letters of field first name +first three letters of field last name where Trainer_ID is Null I...
July 11th, 2008 05:07 PM
by KARL DEWEY Go to last post
2 120
Deleting all values in a field by ChuckW
I have a field called HPProductLine in a table called SBMSALE2008. I want to delete all values in this field and replace them with null values. There are...
July 11th, 2008 03:47 PM
by Marshall Barton Go to last post
3 123
Crosstab by Ticotion
Hi I need your help once again I have a query that is a crosstab showing using the following SQL TRANSFORM Sum(qry_generelOEE.OEE) AS SumOfOEE SELECT...
July 11th, 2008 01:45 PM
by Michel Walsh Go to last post
4 161
Get Distict records from a recordset multiple time using subquery by vqthomf
I have to load distinct records into more that one comboBox and was wondering if it was possible to open the database once by selecting all records and using...
July 11th, 2008 01:29 PM
by bhicks11 via AccessMonster.com Go to last post
3 145
Sum Query Incorrect by NeonSky via AccessMonster.com
Hello Everyone, I am running a simple query that sums the values of multiple fields and it is leading to some very wacky results. Please see below my sample...
July 11th, 2008 02:49 AM
by Allen Browne Go to last post
7 181
Post New Thread


Display Options
Showing threads 9961 to 9980 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:53 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.