Help: Maximum Of Four Fileds - How?

Apr 21, 2008

How do you find the maximum of four fields in each record of a query. Say (for example) you have daily records of the rainfall across four cities, where the cities are the fields in the query. how do you write an extra calculated field to the query that shows the max. rainfall across the fields on a paticular day.

Many thanks if you can help
Nifty

View Replies


ADVERTISEMENT

How Combine Two Fileds?

Dec 14, 2007

Hi,

I am using SQL Server 2005

I try this

select firstname & lastname, id from list

I get error,it seems '&' is wrong.

Please let me know how to combine the two fields

Thanks

Mark

View 2 Replies View Related

Name Change Of Tables, Forms, Fileds Etc.

Apr 21, 2006

A few years back I saw a program which helped with database changes. I want to change names of fields and tables, queries etc. in a rather complex database. Does anybody know where I can get this tool or program to run through the database and change it in all corners and crevices on a search and replace basis?

Thanks

View 2 Replies View Related

Validation Rules For Multiple Fileds

Nov 15, 2004

hello, i am super duper new... and am working on a school assignment for weeks! its due tomorrow but i cant get this one rule to work... please help if you can!!
Basically I am trying to add a validation rule to a field refering to a different field in a different table.
Both fields are Date/Time type
I am new.. and not as advanced as some of you.... so maybe walk me through it?? i have spend many hours trying to figure it out~ thanks

View 1 Replies View Related

Entering Formula Into Access Fileds

Apr 24, 2007

Hello,
I am completely new to Access, so thanks to anyone who does not think my questions are dumb :)
Ok, say for example I have a table that has my income information and my tax rate and I want to compute the income tax I need to pay by simply modifying total income with tax rate, how should I do it? there does not seem to be a function like formular bar in Excel in Access.

Thanks a lot!

Regards,
Anyi

View 5 Replies View Related

Access Table, Fileds And Attributes's Names

Jun 30, 2005

hello,

Recently I have started working for one of the company where I have to deal with one of the access file. this file has lots of tables containing many fields.

My question is

How can I get all the tables name, their fields and attributes in Microsoft Word file. I have tried opening table > design view and copy text but it doesn't work. also tries coping table and paste in in word file but it takes ages

any suggestion will be helpful

Thank you
Viral

View 1 Replies View Related

Updating A Current Form ( Visable Fileds )

Apr 30, 2006

Hi I have a forrm (Orders) , with a subform (Order Details)

Depending on a selection of a list field it makes certain field visible in the subform.

If I go the next record and select the list field it updates fields in the subform ( Visible ( True or False )

But if I go back to the previousl record it doesnt update the fields that are relavent to the option picked in the List Filed ( Which I have set to after update ). It works fine if I re-select the option in the list field

How do I set it to update the subform field automatically as I scroll through records?

I tried OnCurrent property but I dont think this is the correct one.

please help

View 10 Replies View Related

Getting A Maximum Value

Jun 5, 2005

I have a Table where the are several entries all with Fields A, B and C
the same, and varying values for Field D.

There are several different values of A, B and C.

I want have a query, pick out each combination of A, B and C and just the
Max value of D for that combination.

It looks as if it should be simple but I can't figure out how to do it?

Anybody able to help?

View 1 Replies View Related

Maximum

Jul 10, 2005

Hi to all;
I am not familiar with access function, in Excel its very easy to find the max value at row level, what's the formula in access query to get the max of this example
Co1co2 co3….co60max(co1:co60)
200150300 500 ?
212542321 222 ?
thanks in advance for respond
Majed

View 3 Replies View Related

Combine Fileds And Add "and"

Feb 17, 2008

Public Function getTradeMarks(varProdName As Variant) As String
Dim rs As DAO.Recordset
Dim intRecords As Integer
Dim strTradeMarks As String
Dim strSql As String

'strSql = "Select distinct [trademark] from tblTrademarks where [productName] = " & varProdName
strSql = "Select distinct [trademark] from tblTrademarks where [productName] = '" & varProdName & "'"
Set rs = CurrentDb.OpenRecordset(strSql, dbOpenDynaset)

Do While Not rs.EOF
intRecords = intRecords + 1
If rs.AbsolutePosition = 0 Then
strTradeMarks = rs.Fields("trademark")
Else
strTradeMarks = strTradeMarks & ", " & rs.Fields("trademark")
End If
rs.MoveNext
Loop
If intRecords = 1 Then
strTradeMarks = strTradeMarks & " is a registered trademark of company " & varProdName
Else
strTradeMarks = Left(strTradeMarks, InStrRev(strTradeMarks, ",") - 1) & " and" & Mid(strTradeMarks, InStrRev(strTradeMarks, ",") + 1) & " are registered trademarks of " & varProdName
End If
getTradeMarks = strTradeMarks
End Function




my input:

ID productName trademark
1 123 T1
2 123 T2
3 123 T3
4 234 T4
5 234 T1
6 123 T6
7 456 T7
8 789 T8

my output:

productName TradeMarks
123 T1, T2, T3 and T6 are registered trademarks of 123
234 T1 and T4 are registered trademarks of 234
456 T7 is a registered trademark of company 456
789 T8 is a registered trademark of company 789





The above code works Excellent.

I am looking for some code like this , my situation is similar but it has another column

For example In reference to the same example above I have one more column


Dose anyone know how to adjust the above code to get the following output


i.e.

my Input

ProductNumber TradeMark CompanyName

123 T1 C1
123 T2 C5
234 T4 C2
234 T1 C1
123 T6 C1
456 T3 C9
123 T12 C5
123 T9 C1
123 T4 C6


Want out put


productName TradeMarks
123 T1, T6 and T9 are registered trademarks of C1. T2 and T12 are registered trademarks of C5. T4 is registered trademark of C6.

234 T1 is registered trademark of C1. T4 is registered trademark of C2.

456 T3 is registered trademark of C9.

View 1 Replies View Related

How To Select The Maximum Value

Jul 17, 2007

Hi all

I have an expression in a query which is checking a list box on a form. If the list box is empty (is null), then I would like the query to search on the highest (maximum) value in the specified field (CourseFK), otherwise it will look for the value in the list box.

Expr1: IIf([Forms]![frmEditDeleteStudentDetails]![lstEditCourseFK] Is Null,[CourseFK]=Max([CourseFK]),[CourseFK]=[Forms]![frmEditDeleteStudentDetails]![lstEditCourseFK])


However it seems Access will not allow me to do this - I get an error about an aggregate function in a where clause.

Can someone please suggest to me how to get around this? Eg, is there an alternative way to search for the maximum (still needs to be determined dependant on the list box).

Thanks

View 2 Replies View Related

Maximum Question

Dec 10, 2007

Hi,
Can some1 tell me how to create a query that shows me the ProcessID for max time and date (date and time are in separate fields) for every PersonID. I need to run a query once in 5 minutes to check the job that every person is doing. They are entering the processID every time they get a new work to do.

View 2 Replies View Related

Maximum Value Across Fields

Jul 12, 2007

I am a beginner and have a very basic query. I would like to create a field which returns the maximum value across a number of fields for each record. Is there a function that would do this?

To explain in more detail, each record is a customer and the fields are their purchases by month. I would like to get the maximum monthly purchase amount for each customer over the past year.

View 2 Replies View Related

Maximum Number Of Connections

May 4, 2005

Hi,
we use access for localisation in our application. The business object which accessess the access uses DAO connectivity and we often land to
"Too many client tasks" problem.

is it wise to change the DAO to ADO? if so the above problem will go off?
what are the chances that the problem still persists?

is that access has any limits on the number of connections? like 64, 255? or is that ADO/DAO has any limitaions on the number of concurrent connections to access DB?

Pls help, your help will be highly appreciated.

Thanks,
Venkat.

View 3 Replies View Related

Maximum Amount Of Users

Sep 26, 2005

How many users can an access database support? I'm setting up an app accross 3 workstations but each has multiple users. There may be as many as 1000 records a day entered. Can an access database handle this or do I need to switch to sql server?

View 6 Replies View Related

Maximum Number Of Records

May 3, 2006

hi all,

This is general question only. How many number of records that Access can handle as a maximum records?
Or it only depend on size limit (4GB)???
thanks

View 2 Replies View Related

Maximum Access Size

Oct 3, 2006

We have a database in Access 97 which is 0.8GB.

Can anyone tell me:
a) The maximum storage capacity.
b) What will happen when it reaches that size!

View 3 Replies View Related

Maximum # Of Fields For A Table?

Aug 17, 2007

I understand that the maximum file size for an Access db is 2GB but can you essentially have as many fields as you like as long as you do not exceed the 2GB threshold?

I am doing some planning for creating a database with ~90 fields and want to know before I start it whether it will be able to handle that many.

View 3 Replies View Related

Maximum Number Of Relationships?

Jun 3, 2005

My issue:
Does anyone know the maximum number of (one to one) relationships with cascading deletes a table can have?

Background:
I have a split database peer-to-peer application with ten simultaneous users, 250+ linked tables running on A2K, AXP and A03. MSDE and SQL Server are presently not viable options.

I'm unable to manually or programmatically relate one table to 73 others with referential cascade deletes; some of the 73 are related to still other tables. The one table is used as a recordsource on a subform on each of 73 different main forms, each of the latter having a different recordsource.

In other words, I want to delete a record in any of 73 different main forms, each with a unique table recordsource, and then cascade delete a subform record (which has the same table recordsource, regardless of the main form).

If I combined the 73 into a single table, I'd have a monster record with 500+ fields, assuming the latter is even possible, and in which event perfomance would suffer from excessive network traffic.

What I've tried:
I haven't worked this issue for some time and have forgotten the number of relationships for a single table I've been able to create. As I recall, it's on the order of 20 relationships maximum for one table.

Of course, I can do it programmatically delete the subform record on the OnDelete event of the main form, but, for elegance, I'd like to use a cascade delete.

Peer-to-peer network performance is not presently a problem.

View 4 Replies View Related

Maximum Nb Of Columns In A Table

Feb 11, 2008

I would like to know if there is a maximum nb of columns to use in a table or at least a prefered max nb. For example i have a table "customers" and inside i have "name" "last name" "age" "gender"..and so on is there a limit?
By the way i'm using access 2007

Thx for the explanation in advance.

View 3 Replies View Related

Need To Return Only The Maximum Record

Sep 20, 2005

My quiery is supposed to search through a table of names, and find the latest timesheet entry date for each name, as follows:

ID: 1
Name: John
Timesheetdate: 1/1/2005

ID is specific to each name.

I want the result to be a single row for each ID/name, and to return ONLY the latest timesheetdate (this could either be the maximum value or the latest entry).

I have a feeling that this is a simple problem, but i just dont have the knowledge to do it, any help would be greatly appreciated!

View 4 Replies View Related

Maximum Fields In A Query

Sep 29, 2005

Can someone tell me what the maximum amount of fields that you can have in a query is please?

View 1 Replies View Related

Maximum No. Of Chars In Combobox

Nov 3, 2004

What is the maximum no. of characters allowed in a combobox?

View 5 Replies View Related

Query Up To A Maximum Total Value

Mar 17, 2008

I have a database of song track data with track length as a field.
I want to produce play lists up to specific lengths e.g 15 minutes and just want the query to show me enough songs to fill up this time period.
Any help appreciated - especially simple solutions!
Jim

View 1 Replies View Related

Returning Maximum Value For Max Date

Dec 14, 2005

I need to create a query that will return for the latest document, the greatest document number. If I do select max(doc_date), max(doc_nbr), I end up getting the max doc_nbr, but it has an earlier doc date. How would I structure the query to do this?

An example is for these values:

1/30 1
1/30 3
1/30 5
2/28 2
2/28 4

The result should be:
2/28 4


I will then need to see if this returned value is different than the value that was returned the day before, but I am pretty sure I know how to do that.


Thanks,
David

View 6 Replies View Related

Maximum User Limit?

Jan 10, 2006

Hi
What is the maximum number of users who can be connected to one single database at one time? Is there a web site that has info on this?
Thanx for the info

View 1 Replies View Related







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