Adding Across A Row
Jul 14, 2005
Hey guys I'm developing a DB to input satisfaction surveys and compute satisfaction levels expressed as a percentage. I am setting up the DB with 1 record=1 satisfaction survey. The record would contain the fields:Survey Quarter and questions 1,2,3, etc. The responses to the questions are in pulldown menu form with Yes, No and N/A. I've already set Yes to be read as 1 and No as 0. Now I want to add across the row (Questions 1-11) so I can complete the math and get a percentage for each survey. So far I have had zero luck accomplishing this. Any suggestions?
View Replies
ADVERTISEMENT
Feb 20, 2007
This seems really silly but I cannot get this query to work.
In one table I have the agents name, id,Category, No of held emails and the time it took to put these emails on hold. In the other query I have the same agent details,category, No of reassigned emails and the total time it took to reassign these.
What I want the query to do is add the total time spent holding and email to the total time spent reasssigning by category.
What my query keeps doing, as I thought it would be as simple as adding them together is instead of ie:
130+1 = 131 it gives me 1301?????
The query is joined using Agent id and Category.
Help Please:
View 6 Replies
View Related
Apr 7, 2006
I've made a button on my form which adds a booking ID into the listbox, but it doesn't seem to work. This is my code:
Private Sub Command18_Click()
Dim BoI As String
MsgBox "Booking successfully added!", vbInformation, "Booking"
If Month(Me.Date_1) = 1 Then
ListJ.AddItem Me.BoI
ElseIf Month(Me.Date_1) = 2 Then
ListF.AddItem Me.BoI
End If
End Sub
If someone could tell me the problem, I'd appreciate it. Thank you. :)
View 5 Replies
View Related
Apr 12, 2006
Another simple question
I have 2 fields income and expenditure
i have a 3rd field disposable income
how do I get disposable income to automatically change when I input income and expenditure in a form
many thanks
View 6 Replies
View Related
Apr 28, 2005
ive got a database for tickets for a school play. how can i create a query that adds up prices from multiple records? would the total be displayed in a form?
View 1 Replies
View Related
Jun 2, 2005
I Have a field that I need to manipulate the data in.
sample data follows [Field9]:
1 to 1 (cover page)
1 to 3 (no cover page)
etc..
this field identifies number of fax pages sent, eg
“1 to 1 (cover page)” is actually 2 pages, an attachment plus cover page
“1 to 3 (no cover page)” is actually 3 pages, 3 page attachment without cover page
What I want is just the total number of pages in this field.
I have written two expression that dissects the field in two, left hand side gives me a numeric number of attachments and right hand side a numeric value for the existence of a cover page or not.
Expr1: Mid([Field9],6,1)
Expr2: IIf(Right([Field9],15)="(no cover page)","0","1")
Each individual expression seems to do the right thing, but I have been unable to figure out how to add Expr1 and Expr2 to give me total pages.
Any help would be appreciated
J/
View 2 Replies
View Related
Jun 6, 2005
Is there a simple way to add 6 month to an unbount field based on a date that is already entered on a form? I have a field called Last PM and a field called Next PM - The [Next PM] value will be [Last PM] + 6 Months ????
Jon
View 2 Replies
View Related
Jun 22, 2005
It is my first try at a access blank database. I have been ok so far but ran into this problem. All I want to do is add a sortcut on my desktop to open it to the database to the form I made BUT it opens up but i have to push on the name of the form to open up that form. I know there is a way to do it BUT can not figure it out . I do not need a switch board as the is only one form and that is not in my knowedge base It is like a custom
made directory
Thxs Steve
View 1 Replies
View Related
Aug 30, 2005
I have a field where a user has to input numbers. This number at most will have 8 digits. Something like 00000001 or 00001234. I want access to show those zero's before the number but I can't do it. Any suggestions.
Thanks,
Yusuf
View 7 Replies
View Related
Oct 10, 2005
This is probably an age old question but after a search I could not find the answer.
I have a table with 3 fields..... last, first, ssn
I have a form with 3 text boxes. I want users to input data into those text boxes and that data inserted into the table. The code I have figured out, the problem is access tells me I cannot add to the table because the controls do not have focus. Well, I can set focus to one control at a time but then that adds three separate entrees. Am I doing this the real hard way? Im sure there is an easier way to add records to a table with multiple fields.
Thanks
View 2 Replies
View Related
Oct 28, 2005
I have am building a program that requires a staff person to enter a daily activity report on employee activity. It's initiated by adding a new record
that will allow the selection of an employees name and ID number from a drop box into respective first name, last name and ID fields. The staff person would then go on to complete the daily report by adding information in several other fields.
My form is based on a relational query built from two tables; tblClient and tbldailyreport.
Any help would be appreciated.
Regards
Timber
View 1 Replies
View Related
Jan 5, 2006
Hi,
I've a quick question. In Access, I have a form that allows user to add new record into a table. Is there anyway of finding whether the new record has successfully been inserted or added?
So i think it may be wise to have a message to notify us of whether it's inserted successfully or not.
Hope this explain clear
Thank you very much in advance for your help
View 1 Replies
View Related
Feb 8, 2006
Hi, is it possible on the database window to add subdirectories? Such as in 'User Queries' under the 'Queries' tab, etc. If not, is it possible to add anything else to that ojbect window? I know you can add groups, but I need a way to split up queries and tables for individual users. Any help would be appreciated. Thanks!
Paul
View 1 Replies
View Related
Feb 10, 2006
Can someone give me an easy way to put a hyphen between two numbers, such as with wins and losses of teams? I want it to come out 5-3, not 5 3.
I tried entering a text box with no success.
View 3 Replies
View Related
May 9, 2007
Hi guys, ive been developing a database for someone. As some coding has been involved, I have added some references etc as I went along.
I'll be soon handing it over to them to use - will they have to add the references for the database to run on their comp? If so, is there more user friendly way of doing it than going into the VB bit etc?
Cheers...
View 3 Replies
View Related
May 17, 2007
Hi there,
I am trying to add a new column to my table say name2 with data type Text.
as soon as i hit save it gives me error
"Unknown function Date in validation expression or default value on Contcts.LastUpdated. (Error 3388)"
Any clue?
One more thing what is the maximum number of columns permitted in a table?
Thanks
View 1 Replies
View Related
May 31, 2007
hello,
I have 10 combo boxes on a form looking up at the same table (fileld A). I want the user to be able to enter a new value (that's not in the table and therefore neither it is in the combo box) to the 1st combo Box (let's say) and that same value to be automatically added to the table, so when I use the next (2nd one) combo Box, that same value is already in the table.
How can I do this??
Thank you very much
View 1 Replies
View Related
Feb 6, 2008
Hi,
I have an SDK that I normally use with VS.NET. I cannot seem to add the .dll as a Reference in my MS Access 2003 database. Is there something I am doing wrong, or a workaround to get it to work? I have .NET 3.0 installed on the PC.
Thanks,
View 1 Replies
View Related
Dec 20, 2005
I have a database that tracks staff training in a health trust. It's pretty simple, tb_staff, tb_courses_done which is 1:n and a tb_courses 1:n on the staff_id of tb_courses_done.
I want to know how to go about adding a table(s) that will allow me to book staff onto courses and track if they attended or not. At present it's 1 staff member has many courses so any courses entered are "done." I have a main form with staff details and it has a subform where I add completed courses.
Hope that's clear?
Thanks.
View 1 Replies
View Related
Mar 2, 2006
Im doing a project at school and it involves adding 2 entities and then the answer being displayed in another entitiy i have searched the forums but with no luck is it possible at all.
View 1 Replies
View Related
Mar 30, 2006
Hello Guys
This might sound like an easy qestion but i just cant do it, and need someones help!
I got two Access tables that are set out exactly the same, and im trying too add the figures in both tables together, too produce the results in another table.
Can anyone help me on how too do this
Thanks
Mark
View 2 Replies
View Related
Nov 3, 2007
So I need to know this. How do I:
*Add 2 text fields together with a space between?
*Truncating field 1 to the first character and field 2 to the two first characters?
Sorry for my noob questions :D
View 6 Replies
View Related
Mar 16, 2006
I have developed a query which adds accumulated costs for each client in my DB, I am having trouble adding the VAT tax which is 17.5% to the query though, I seem to get a lesser total once tax is added which can't be correct.
Here is my query:
SELECT DISTINCT Holiday_Bookings.ClientID, Holiday_Bookings.Booking_Cost, Room_Facilities.FacilityCost, Rooms.[CostPerNight], Rooms![CostPerNight]*Nights_Stayed+Holiday_Bookings!Booking_Cost+Room_ Facilities!FacilityCost AS TotalCost
FROM Room_Facilities INNER JOIN (Hotels INNER JOIN (Holiday_Bookings RIGHT JOIN Rooms ON Holiday_Bookings.ClientID=Rooms.ClientID) ON Hotels.HotelID=Rooms.HotelID) ON Room_Facilities.FacilityID=Rooms.FacilityID;
View 3 Replies
View Related
Mar 23, 2006
I have a table called DSERDBA_CASE_STATUS_CHANGE and it contains the following fields:
DSERDBA_CASE_STATUS_CHANGE.STAT_CASE_ID,
DSERDBA_CASE_STATUS_CHANGE.STAT_BEGIN_DATE,
DSERDBA_CASE_STATUS_CHANGE.STAT_END_DATE,
DSERDBA_CASE_STATUS_CHANGE.STAT_FROM_CASE_STATUS,
DSERDBA_CASE_STATUS_CHANGE.STAT_TO_CASE_STATUS,
DSERDBA_CASE_STATUS_CHANGE.STAT_USERID,
DSERDBA_CASE_STATUS_CHANGE.STAT_ACTIVITY_CODE,
DSERDBA_CASE_STATUS_CHANGE.STAT_COMMAND,
DSERDBA_CASE_STATUS_CHANGE.STAT_REASON_CODE
I’m looking to find CASE_ID's where the BEGIN_DATE is greater than 09/30/2005 and less than 10/01/2006 where the CASE_STATUS went from O to C and where the STAT_REASON_CODE does not equal INT27 and I have come up with this query which works fine.
SELECT
DISTINCT
DSERDBA_CASE_STATUS_CHANGE.STAT_CASE_ID,
DSERDBA_CASE_STATUS_CHANGE.STAT_BEGIN_DATE,
DSERDBA_CASE_STATUS_CHANGE.STAT_END_DATE,
DSERDBA_CASE_STATUS_CHANGE.STAT_FROM_CASE_STATUS,
DSERDBA_CASE_STATUS_CHANGE.STAT_TO_CASE_STATUS,
DSERDBA_CASE_STATUS_CHANGE.STAT_ACTIVITY_CODE,
DSERDBA_CASE_STATUS_CHANGE.STAT_COMMAND,
DSERDBA_CASE_STATUS_CHANGE.STAT_REASON_CODE
FROM DSERDBA_CASE_STATUS_CHANGE
WHERE
(((DSERDBA_CASE_STATUS_CHANGE.STAT_BEGIN_DATE)>#9/30/2005# And
(DSERDBA_CASE_STATUS_CHANGE.STAT_BEGIN_DATE)<#10/1/2006#) AND
((DSERDBA_CASE_STATUS_CHANGE.STAT_FROM_CASE_STATUS )="O") AND
((DSERDBA_CASE_STATUS_CHANGE.STAT_TO_CASE_STATUS)="C") AND
((DSERDBA_CASE_STATUS_CHANGE.STAT_REASON_CODE)<>"INT27"));
My problem is that I also want to exclude cases where the case went from CASE_STATUS C to O on the same date that it went from O to C (it closed and reopened on the same day) And I don’t know how to adjust this query to accomplishment this.
Can someone show me how? Thanks
View 1 Replies
View Related
May 22, 2006
The other day I check with various people on how I might get column information added together as it relates to checkboxes. Yet, I am still having trouble making this work, please read the following. Any help is appreciated.
Example: Item A (if checked)= 33%, Item B (if checked)= 33%, Item C (if checked)= 33%. Once adding (if A & B are checked) shows that I have 66% completion on that particular project.
I was instructed to...........create a text box on a form, set the format property to 'Percent' and the 'Control source' can look like this:
=iif([ItemA]=True,0.33,0)+iif([ItemB]=True,0.33,0)+iif([ItemC]=True,0.33,0)
This will add these three items up and give you the percentage. You can also do the same in a query to based your reports on these percentages.
Yet, It isn't working properly. Any ideas?
View 3 Replies
View Related
Aug 3, 2006
hallo everyone,
i have the following query and i am getting the following output
SELECT Sum(tbl_RFQ_Details_AVOB.[AVOB RFQ]) AS [SumOfAVOB RFQ], tbl_Status.Status
FROM tbl_Status LEFT JOIN tbl_RFQ_Details_AVOB ON tbl_Status.ID = tbl_RFQ_Details_AVOB.Status
GROUP BY tbl_Status.Status, tbl_RFQ_Details_AVOB.Status;
SumOfAVOB RFQStatus
16900110RFQ in Process
12610000Under Review
1200000 Decided
3500000 Terminated
1000000 Terminated Supplier
6000000 Leverage Back
40000000Uncompetitive
500000 RFQ in Preparation
Now i require a new line in addition to this that says that the total value is and the sum of those values must be given.
required output:
SumOfAVOB RFQStatus
16900110RFQ in Process
12610000Under Review
1200000 Decided
3500000 Terminated
1000000 Terminated Supplier
6000000 Leverage Back
40000000Uncompetitive
500000 RFQ in Preparation
totalvalue Total RFQ
How can this be done?
regards,
aravind.s
View 1 Replies
View Related
