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
DAO parameter length by Joseph Walkenhorst
When I run the code below an error is thrown at line 4 when the string sc.notes is greater than 255 characters. Is there any way to allow parameters to...
June 27th, 2008 11:50 AM
by Bob Barrows [MVP] Go to last post
2 262
Access Query: get first date field by [email protected]
I am using Access XP. I am working with a database with many file numbers. Each file number has multiple paid dates. How do I get the query to pull each...
June 27th, 2008 02:10 AM
by Rob Parker Go to last post
1 395
Training schedule -need qry to return all employees for that month by fossy
Situation: I have 2 tables: "employee info" & "employee training" linked by "ID" filed. "employee info" has the employee personal information -all I needed...
June 26th, 2008 11:56 PM
by KARL DEWEY Go to last post
1 173
Seniority Ranking by HireDate then LastFour by drober
How do I get a Seniority Ranking # in by query that is already sorted by HireDate then LastFour?
June 26th, 2008 11:39 PM
by KARL DEWEY Go to last post
1 197
Crosstab query? by Question Boy[_2_]
Hello I have 2 tables 1 Members ID FirstName LastName 2. Stats EntryDate EntryType
June 26th, 2008 10:06 PM
by KARL DEWEY Go to last post
1 185
Date Groups by Justin
I'm creating a report for total sales. The user will enter the date range and time period (days, weeks, months, years) for the grouping. This all works...
June 26th, 2008 09:40 PM
by Michel Walsh Go to last post
1 160
calculating currency formatted fields by apex77
I have a query in which I am trying to total up 3 currency formatted fields. The 3 fields are Lead, Advance and Close. The fourth column with the calculation...
June 26th, 2008 08:55 PM
by Jerry Whittle Go to last post
7 210
Counting in a Query by Susan L
I've searched, but did not find an answer. I am attempting to have a query count the number of "X"s in 6 fields (, , etc.) in another query. These values...
June 26th, 2008 08:24 PM
by Marshall Barton Go to last post
4 160
Average multiple colums by esoller
Hello, This DB is my first project and my question might be basic but never the less it drives me bananas. I need some help to put me strait again! I have a...
June 26th, 2008 04:57 PM
by John Spencer Go to last post
5 262
Eliminate duplicate addresses for mailings by Will[_8_]
Access 2007 Vista Business I have a table with names and home addresses. There are valid duplicate addresses because of multiple people in the same home. ...
June 26th, 2008 04:48 PM
by Jeff Boyce Go to last post
6 182
SELECT DISTINCT query is not deduplicating by shannonsider
Hi, I am running a 'SELECT DISTINCT' query that is not deduplicating. I am using Microsoft Access 2000. I have two tables; one is called 'places' and the...
June 26th, 2008 02:54 PM
by Michel Walsh Go to last post
2 170
tough one regarding adding two columns :) by Accessghostrider via AccessMonster.com
Hi I have a table with one row of data and 10 columns that are all total figures of a previous table. example is below: Sum1 sum 2 sum3 2 49 ...
June 26th, 2008 02:34 PM
by Accessghostrider via AccessMonster.com Go to last post
8 230
Update Query for Current Record Only by Adrian
I have an update query which I want to run when a record is given focus in a form. But I do not know how to reference this either in the event property or...
June 26th, 2008 12:54 PM
by Ron2006 Go to last post
8 301
tough one regarding adding two columns :) by Accessghostrider via AccessMonster.com
Hi I have a table with one row of data and 10 columns that are all total figures of a previous table. example is below: Sum1 sum 2 sum3 2 49 ...
June 26th, 2008 11:13 AM
by Accessghostrider via AccessMonster.com Go to last post
0 168
tough one regarding adding two columns :) by Accessghostrider via AccessMonster.com
Hi I have a table with one row of data and 10 columns that are all total figures of a previous table. example is below: Sum1 sum 2 sum3 2 49 ...
June 26th, 2008 11:12 AM
by Accessghostrider via AccessMonster.com Go to last post
0 202
IS this DLOOKUP possible within a query? by Stu
I want to create the lookup criteria from a date field withn the query itself but can't get it to work. The lookup I'm using always returns 1 (when it should...
June 26th, 2008 10:34 AM
by Stu Go to last post
4 182
Set default value to 0 with ALTER TABLE by Nacho
I have a large database that I need to load massive amounts of data. After appending the data, numerical fields apear as Null, as no default value was...
June 26th, 2008 08:55 AM
by Allen Browne Go to last post
1 154
modify crosstab query to fiscal qtrs rather than calandar qtrs by Lisacu
I need to provide quarterly data based on our fiscal year, not the calendar year. I am able to create a crosstab query, but don't know how to modify it for...
June 26th, 2008 08:29 AM
by scubadiver Go to last post
5 346
Ranking customer service metrics - Query issue by Nicholas Scarpinato
I'm building a report to rank a series of customer service metrics, such as call time and calls per hour. I have all the data compiled, but the person I'm...
June 25th, 2008 11:30 PM
by Nicholas Scarpinato Go to last post
3 251
Parameter Query Wild Card by Iram
I have a report that is running a parameter query against a form that that has a list box. The list box gets its data from a table that has three records....
June 25th, 2008 11:01 PM
by KARL DEWEY Go to last post
1 156
Post New Thread


Display Options
Showing threads 10201 to 10220 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 11:03 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.