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 Replies Reverse Sort Order Views
Change a field name by Ray
I tried to change the field name in a query using "New Name: ". It did not work at all and just display the caption of the Field Name. Is it possible to...
(Multi-page thread 1 2 3)
August 10th, 2004 12:35 AM
by M.L. Sco Scofield Go to last post
24 892
Non-updateable query issue by sjwopg
I am creating an application which will have 20+ users. In order to minimize errors or record locking issues, I have created three tables for each record....
(Multi-page thread 1 2 3)
August 26th, 2008 12:18 AM
by David W. Fenton Go to last post
24 439
Reference to next record within a group by Simon L
I am trying to set up a summary query to identify how many total days a patient has gone without any medication. The following are the data that I start...
(Multi-page thread 1 2 3)
April 9th, 2008 07:22 PM
by Michel Walsh Go to last post
24 346
Complex (for me) IIf query by [email protected]
I have tblEmployeeProduction which is populated via a form using an Update query with the following sql: PARAMETERS forms!! DateTime; INSERT INTO...
(Multi-page thread 1 2 3)
January 11th, 2008 07:49 PM
by Michel Walsh Go to last post
24 398
show Count of "empty" records by GillWeb
Hi I'm compiling a simple database to analyse responses to a questionnaire, most of which are multiple choice responses. I need to be able to have queries...
(Multi-page thread 1 2 3)
June 20th, 2007 12:37 AM
by KevinT Go to last post
24 320
criteria issue by will via AccessMonster.com
Hello, i like to add more fields as a criteria to the strWhere...........i like to , , and other fields...can anyone help with this. i am stuck with this....
(Multi-page thread 1 2 3)
May 4th, 2007 04:42 PM
by bigwillno2 via AccessMonster.com Go to last post
24 259
Update Query only works first time by Jacine
Hello, I am fairly new to Access and I am stuck on two issues. I have an inventory form that has several bin locations with their own numerical field and...
(Multi-page thread 1 2 3)
August 2nd, 2006 07:34 AM
by strive4peace Go to last post
24 702
Help with calculations in a query by RWhittet
I have run into a problem in my query. I am trying to run calculations on water meters. I have been able to calculate the information I need on my forms, by...
(Multi-page thread 1 2 3)
November 28th, 2005 09:12 PM
by Tom Ellison Go to last post
24 575
Need Help with Totals Query by SSi308
I have a table with daily call records. The table includes fields for: Department; Name; Date of Call; Time of Day; Call Direction; Number Dialed; Locale;...
(Multi-page thread 1 2 3)
May 20th, 2010 09:47 PM
by John Spencer Go to last post
24 1,955
Need to export a pivot chart view of a query by AmandaM
Hi - I need to export the pivot chart view of a query to a word or excel document so that it can be emailed or saved. Any ideas?
(Multi-page thread 1 2 3)
August 17th, 2009 04:05 AM
by Blades Go to last post
24 671
Parameter query by Darhl Thomason
I'm creating a parameter query in my database, but I'd like the users to be able to choose the parameter (like from a dropdown list) instead of having to know...
(Multi-page thread 1 2 3)
June 10th, 2005 06:44 PM
by Darhl Thomason Go to last post
24 329
Removing Formatting Symbols from Phone numbers by faxylady
A project that I am doing requires collecting large amounts of contact data and working with the phone numbers. My job would be a lot easier if the...
(Multi-page thread 1 2 3)
March 24th, 2007 07:25 PM
by faxylady Go to last post
23 255
expression i need to write rate -admin costs*driver percentage in. by dasad
I have three fields in a table rate, admin costs and driver percentage 1. Rate - currency 2. Admin Costs - number intger currency default 5 3. driver...
(Multi-page thread 1 2 3)
March 24th, 2005 07:27 AM
by Andreas Go to last post
23 779
Address List by FJ Questioner[_2_]
My mailing list often has two last names for a given address. Each is a separate row in my database. I want to be able to make an address label that says...
(Multi-page thread 1 2 3)
February 28th, 2008 08:53 PM
by John Spencer Go to last post
23 263
Form that also updates the intermediary table? by Stranger
Hello., How do I create a form that will update the middle table? Two tables, Employees and hardware, intermediary table is tblemployeeshardware. Would I...
(Multi-page thread 1 2 3)
September 11th, 2004 10:50 PM
by Stranger Go to last post
23 738
Append to two different tables by alhotch
I think I know the answer: I want to Append "working" table fields to two separate tables from a single Append Query. I believe the answer is NO. Can only...
(Multi-page thread 1 2 3)
April 29th, 2010 07:50 PM
by alhotch Go to last post
23 652
Concatenation of Text as Expression In A Query by la knight
Hello: I have found a previous question on this site called "Sum of Text fields?" from 8/19/04 and it describes what I am trying to accomplish. I have...
(Multi-page thread 1 2 3)
March 7th, 2006 10:31 PM
by Duane Hookom Go to last post
23 252
Help again from Ken Snell (Query) by Randy
Ken you helped me last week with a query to find missing dates from my employee db. It works great except I have found that it returns all dates from my...
(Multi-page thread 1 2 3)
August 29th, 2005 08:15 PM
by Randy Go to last post
22 1,749
Struggling with query by LHEMA
I am new to access...I am need of help!! I have been working on this project for about a month trying to get it to work. This is the problem I am trying to get...
(Multi-page thread 1 2 3)
March 30th, 2006 08:02 PM
by Tom Ellison Go to last post
22 410
RANKING by gambler
I have a list of numbers( that come from a formula--Eg. FR1 + FR2) in one of my query fields. I would like to take these numbers and give them a ranking. The...
(Multi-page thread 1 2 3)
November 5th, 2004 12:53 AM
by gambler Go to last post
22 1,102
Post New Thread


Display Options
Showing threads 61 to 80 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 06:41 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.