Display Low Avg And High

Aug 24, 2007

hello all,
i have a table that has 4 fields, i need to somehow store/display the highest value the lowest value and the avg of the 4 values. please help!!
i can either display them in a form or store them in my table?
what ever is easier

View Replies


ADVERTISEMENT

High/Mid/Low Query

Sep 3, 2006

It must be me but:

I have a table with the column Grade and a column Grade_Group
In the column Grade I can give a value from 0 - 10 (pull-down).
When I grade between 0 and 3 I want the column Grade_Group to be updated to Low (easy, even I can do that with an update query).
But if the grading is between 4 and 7 the Grade_Group needs to be Mid and if the grading is between 8 and 10 High.
In this case I am able to create reports on High/Mid/Low criteria.
If I put this all in (one) query the query changes all data in the Grade_Group to Low, or I get a duplicate error because there is just one update field.
Someone, I searched the forums but nothing came up.
Thanks in advance!

View 2 Replies View Related

Can Someone Give Me Some High Level 'pointers' ?

Oct 25, 2006

Can someone give me some high level 'pointers' ?

Simply (although not for me) I am trying to build a form that involves a unique identifying number being entered, a button being pressed and relevant field belonging to that unique identifying number being displayed in a subform.

For example, I might want to enter a customer number, press a button and all the orders made by that customer appear in a subform.

Any help gratefully received !

Thanks.

View 3 Replies View Related

Send Email With High Importance Using Access

Jan 12, 2007

Is there any code that will allow me to send an e-mail as "High Priority / High Importance" through Access?

Here is the code I am using currently:

Private Sub Save_Click()
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

Dim mail
Set mail = Nothing
' Send by connecting to port 25 of the SMTP server.
Dim iMsg
Dim iConf
Dim Flds
Dim strHTML

Const cdoSendUsingPort = 2

'==== A/R 60 Code Start ====
ElseIf Me![A/R Code] = "60" Then

Set iMsg = CreateObject("CDO.Message")
Set iConf = CreateObject("CDO.Configuration")

Set Flds = iConf.Fields
' Set the CDOSYS configuration fields to use port 25 on the SMTP server.
With Flds
.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = cdoSendUsingPort
'ToDo: Enter name or IP address of remote SMTP server.
.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "usahm204.amer.corp.eds.com"
.Item("http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout") = 10
.Update
End With
' Build HTML for message body.
strHTML = "<HTML>"
strHTML = strHTML & "<HEAD>"
strHTML = strHTML & "<BODY>"
strHTML = strHTML & "This is an automated e-mail to let you know that <b><font color=#FF0000>" & [Name of Requestor] & "</b></font> from <b><font color=#FF0000>" & [Department of Requestor] & "</b></font> has submitted a new <b><font color=#FF0000>A/R " & [A/R Code] & "</b></font> request in PERD."
strHTML = strHTML & "</BODY>"
strHTML = strHTML & "</HTML>"
' Apply the settings to the message.
With iMsg
Set .Configuration = iConf
.To = "<Carol.Patukonis@examhub.exch.eds.com>" 'ToDo: Enter a valid email address.
.Cc = "<Elisa.Chandler@examhub.exch.eds.com>;<Deborah.Davis@examhub.exch.eds.com>"
.Bcc = "<Carlene.Vitello@examhub.exch.eds.com>;<Jason.Boney@examhub.exch.eds.com>"
.From = "PERD Request<Jason.Boney@eds.com>" 'ToDo: Enter a valid email address.
.Subject = "New A/R " & [A/R Code] & " Request"
.HTMLBody = strHTML
.Send
End With
' Clean up variables.
Set iMsg = Nothing
Set iConf = Nothing
Set Flds = Nothing
'==== A/R 60 Code End ====


I have tried using .Priority = "High" and .Importance = "High", but I keep getting an error stating this object property is invalid. What can I use to set a priority (Low, Normal, High) on the e-mail using the above code?

View 11 Replies View Related

Converting To 2007 From 2003 - High Cpu Usage

Dec 11, 2007

This is very strange. I have converted two computers from 2003 to 2007. I have also installed 5 2007's on to new computers. All of these are Professional XP sp2 setups. I copied over a database to woek on those computers. Originally the performance was very good, on all of the computers (but not the lowest specified converted laptop ) exitting from a form containing a subform takes 37 seconds. The word Calculating... is on the status bar. The laptop takes 3 seconds par with what it used to do.

I have transferred the 'Data' database, the 'Apps' database, Utility.mda and another .MDA. I have also transferred all the Reference executables to one of the other computers. This has not made a jot of improvement.

Has anyone any pointers. I have exhausted all the resources trying to find a solution to this one.

View 2 Replies View Related

Tables :: Autonumber Field - Cannot Add Record That Is Not High Number

Feb 18, 2013

I have a table with an autonumber field, which of course is indexed with no duplicates. Twice in recent days it has attempted to add a record with an autonumber that is not the high number - it is about 20 numbers below the high number. So we get a 'can't add this record' error.

I can fix this by copying the table to a temporary table and then copying it it back. Then the autonumber works correctly.

What can I do to prevent this? By the way we updated to Access 2010 a couple of weeks ago, but the data is still Access 2003. We are reluctant to update the data yet in case it causes more problems.

View 10 Replies View Related

Display The Max Value

Jun 13, 2006

How do I display only the largest or smallest value in the query result?


Thanks

View 3 Replies View Related

Display 2 As 02 - Where Does My Zero Go??

Mar 1, 2005

I have a form that displays minutes. When the minutes are 9 or less it displays as, e.g. 9 instead of 09.

How do I get that leading zero to display?

I read in previous posts that one way was to format as text or date, but I don't want to do that bc the minutes are added up on form save/close. :confused:

View 2 Replies View Related

Display If

Oct 5, 2005

HELP

I have a point system. What I want it to do is, when the points field reaches 55 I need for the Congrats field to display “Congratulations you are now eligible to advance to the next peer group”

View 3 Replies View Related

Display Yes/No

Aug 11, 2006

I have a Yes/No field in my table - I would like to display the words in a report instead of the checkmark. How would I display this in a query or report?

View 1 Replies View Related

Combobox Display

Jun 15, 2005

Hi I really have a problem in MS access.

I created a combo box which as 2 columns, eg Plant ID and Plant name
I need to have the Plant ID on the left and Plant Name on the right which it is at them moment, however....

When I choose an option inthe combo box, it will display the Plant ID number in the textbox because it is on left (its the 1st column in the drop down box)

.... I want it to show the plant name instead, but still have the plant id colun on the left and plant name onthe right when i click the arrow of the drop down box,

sry if its confusing, i need an anwser ASAP, thanks!

View 1 Replies View Related

Display Size

Jan 24, 2006

Is it possible when loading a control form to set the users default display size to say 1024x768. I'm creating quite a complex form and it will be too large on an 800x600 display.

Ta

View 1 Replies View Related

Display Data

Nov 13, 2006

Hi,

I am using a query to print information about customers and products on a report; the query is returning something like this:

Customer---------------------Products
cust1-------------------------------apple
cust1-------------------------------cereal
cust1-------------------------------salad
cust2-------------------------------photos
cust2-------------------------------bananas
However, my client is wanting all the info about each customer displayed in list like this:

Customer----------------------Products
cust1--------------------------------apple------------------cereal-------------------salad
cust2--------------------------------photos-----------------bananas

I can change my tables to reflect product1...productn, but that will break database rules.

Any suggestions please?

Regards,
B

View 7 Replies View Related

User Display

May 22, 2007

Hello All,

I have set up security my users. What I am wanting to do is when the record has been modified or changed it displays the user that is signed in as making the change. I have Time and Date set up this way. How can I have the user displayed as well.

Thanks,:D

View 5 Replies View Related

Display Dates

Jun 1, 2005

I would like to eventually creat a chart report with information I have in a query. My problem is that I cannt get the correct information in my query. I want a user to input three begin and end dates and I want the appropriate information displayed in my query.

View 5 Replies View Related

Display Field Name

Feb 21, 2006

Hi,

I have a field in my query that displays the occupation of an employee. I have another field with an "if" expression, which displays the occupation if certain criteria is met. However, it displays the occupation ID and not the name.

The occupation ID is an autonumber, but I just want to see the name.

Is there an easy way to do this

View 1 Replies View Related

Query Display

Apr 6, 2006

Hi I was just wondering whether there was a way to display results of a query in a listbox form or similar.
Thanks

View 1 Replies View Related

Display All When NULL

Aug 3, 2006

I have a query which based on some fields on a form should display a set of records. In case when the user doesn't specify anything in the combobox on the form (value=NULL) I want the query to display all the records (like "*"). For some reason when i put the following in the criteria of the query it returns 0 records instead of displaying all:

IIf(IsNull([Forms]![frmClassReport].[ClassName]),(([tblClassesOffered].[Course]) Like "*"),[Forms]![frmClassReport].[ClassName])

I tried: IIf(IsNull([Forms]![frmClassReport].[ClassName]),"class_name",[Forms]![frmClassReport].[ClassName])
... and that works properly. I tried several scenarios and pretty much narrowed the problem down to the use of "LIKE" which when used as specified in the first SQL statement doesn't return any records. What am I doing wrong?

View 1 Replies View Related

Display All With DOB Within A Week

Oct 2, 2006

Hi, I am doing a project at school and need to run a query that displays everyone that has a date of birth within 7 days using a date in the format 01/01/2001. I really have no idea how to do this and would really appreciate any help.
Thank you very much
Kris

View 2 Replies View Related

Display Top 50 Records

Dec 10, 2006

Dear friends

How could I get top 50 records from a table?

have a nice day
JB

View 2 Replies View Related

Display Parameter Value

Dec 11, 2006

Afternoon All,

Right then.....i have a query which I use to search the database, users click a command button to open up the query and then are prompted to enter the parameter value. The results are then displayed in a form - what I want to do is to display the search term used at the top of the form.

I'm not sure that this is possible and if not, would my best bet be to use a text box on the form and refer to that in the search query?

rgds,

View 6 Replies View Related

Display As Date

Sep 13, 2007

I have just taken over an access database written by someone else. I am being asked to write some customized reports that will be extracted to excel and passed around to the team.

The database is used to track employee assignments and show us who is available and what percentage they are assigned to a task. The current report shows their percentage of assignments by month. The current column headers in the table are Month1, Month2, Month3, etc.

In the report I am creating, I would like to write it so that it pulls data based on criteria I give, but I want the columns to show Month1 as the current month, and Month2 as next month, etc. So instead of Month1, Month2, Month3... I will have September, October, November.

I cant seem to figure out how to calculate the "display as" part. When I put the formula Format(Now(),"mmmm"), the formula appears as the column name, not the expected value.

Your help is most certainly appreciated.

View 3 Replies View Related

Display Data

Dec 28, 2007

I have a table with 2 columns :
ID Code
70010000220002A
70010000220002B
70010000220002C
70010000220019A
70010000220019B
70010000220045AAA
70010000220045BBB
70010000220045CC
70010000220045D
70010000220045E
I need to present this info in this format. Can you help?

ID Code1 Code2 Code3 Code4 Code5
70010000220002ABC
70010000220019AB
70010000220045AAABBBCCDE

Thank you!

View 6 Replies View Related

Non-display In Sub Form

Jan 24, 2005

Hi All

My sub form appears to work fine most of the time.

But the records in the sub form (which is a datasheet) don't display when I apply a "filter by form" on the main form ?

Any clues as to what is wrong ?

I am a beginner - it could be something quite fundamental !

NoVoiceLeft

View 10 Replies View Related

About Image Display

Feb 3, 2005

I am going to show some images
I have stored the links of photo in a table

how can I show the different pictures in a form at the same time?

View 1 Replies View Related

Search And Display

Feb 11, 2005

I am using Microsoft Access 2000, I dont have very much knowledge with the program. I need to Seach By a Combo box, Contact name... Through the database and then Display only the information for that customer in the list box. I have been researching this for weeks now and I need Help. :confused: :confused: :confused: If anyone could help it would be great. Thanks. :)

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved