I am pulling some information, and I am needing a report to show the value "score" if the field is numeric, but if it is not numeric, retain it's original value. for instance if the field is 1234 it needs to show on the report as "score" but if it is MSP it needs to say MSP.
I have a Dlookup which returns the correct value but returns the text of the instead of a numeric value. I have triple checked that the fields are all numeric. I suspect there is something wrong with my Dlookup syntax as it is my biggest weakness. In the following syntax what could be wrong?
DLookUp("SSER","TABSSS",[grosspay] & " Between [TABSSS].[Minrange] And [TABSSS].[Maxrange]")
I have an access DB with games scores recorded in it. I want to get these values out into an ASP page. The basics are easy, but if a user has submitted more than 1 score, I want to extract just their highest result. This is my code:
Code: SELECT email, MAX(totalScore) AS highScores, playername, level01, level02, level03, level04, level05, lives, buildBonus FROM tbl_xmas2004 GROUP BY email
But Dreamweaver doesn't like this! Any thoughts? I have also tried creating Queries in Access and using these in Dreamweaver - however, Dreamweaver also refuses to use Joins? Or perhaps that's my code?
Code: "SELECT tbl_xmas2004.playername, tbl_xmas2004.email, tbl_xmas2004.level01, tbl_xmas2004.level02, tbl_xmas2004.level03, tbl_xmas2004.level04, tbl_xmas2004.level05, tbl_xmas2004.lives, tbl_xmas2004.buildBonus, 2004MaxJoin.MaxOftotalScore FROM tbl_xmas2004 INNER JOIN 2004MaxJoin ON tbl_xmas2004.email=2004MaxJoin.email"
I have a numeric field (long integer) in a table. I've set the format to fixed. No matter what I set the decimal places to, auto, 0 or 2, when I enter a value of 0.71, it displays as 1.00
In my form, I've also set the field property to fixed, but it displays the value as 1.
I have a text field having data i-e HO-1, HO,2, ACW-25 and so on. The field name is nBadge_num and is Unique. The data in this field is sorted automatically like 1, 10, 11, 12, 13, 2, 3, 4, 5...because this is the text field.
The number on the form is automatically generated, when the user type HO- for example on field exit event. The last number will generate like HO-5.
Code for automatic number generation is:
Dim dbs As Database, rst As Recordset, Response Set dbs = CurrentDb Set rst = dbs.OpenRecordset("SELECT Max(Right([nBadge_Num],Len([nBadge_Num])-" & Len(Me.NBadge_Num) & ")) AS MaxNo " _
[Code]....
My problem is when the number is generated it give HO-5 instead of HO-14, How can I sort the numeric part of the field ?
I am trying to figure out how to count the number of Yes's and No's on one record to produce a score. There are 39 total questions and each question gives the user a choice of Yes, No, or N/A. Each record will need to have a score attached to it. I appreciate all the help I can get.
I have a bunch of student test scores. The test is scored out of 100. I want to COUNT the scores (ie I want to know how many kids scored 50 etc...). This is easy enough except the crosstab query will be very wide ie 100 columns.
I cant seem to reduce the size by grouping them into ranges (ie count the number of kids that scored between 50 and 60 in a cross tab. I've tried variations with select queries but without luck.
Maybe there is a way to code it.. and then show it on a report??
and my question is,how to calculate the student table's grade value? i want the result like below.. #studentID score Grade Sminth 88 A samantha 76 B Williamv 45 F martell 78 B
Trying to do the following: Having built a table of customers, I need to have an automatically generated ID number for each that IS IN ORDER - which rules out Autonumber and it's gapping tendencies. So, I've developed a new CustID field and set it to "Number", and now just need to figure out how to get it to pull the previous entry and add "1" to it. So it would look like this:
CUSTID NAME 1 Bob 2 Fran 3 Phil 4 Tom 5 (ready for next entry)
Any way to use a function I don't know about, or program some type of solution? Thank you
Guys, When I generate an excel sheet through vb.net code, I get a Numeric Field OVerflow when the values generated contain a date!
my database is ms access...
The problem is that each excel sheet generated has different columns, depending on what columns the user selects to view. for example: if the user chooses name, age and date, the date would appear on the 3rd column, if the user chooses name, nationality, age, family name, date, then the date would appear on the 5th column, etc.....
I have a query that prompts with a parameter box for the field Contributor_ID. Contributor_ID is a numeric field & Key and I use it to allow the user to print a report based on which Contributor_ID value the user enters. This works fine. However, I would like the user to have the option to enter * and then have the report include ALL the contributor IDs. I have done this before on a text field without a problem, however is this not possible on a numeric field as it is not working? I'm trying not to have another version for the ALL option.
If this is not possible, are there any alternatives?
Hi, I'm running an Append Query from an Excel <linked> file to a table in access. From what I can tell, the first filed is overflowing with a linked filed numeric of 'Double'. You can't change linked table fields. However when I first link the Excel file, the Append works... :D only when I reboot the PC and start the next day's work, do I get this message... :eek:
1. Should I include in my MACRO an import to a table and then append...? :mad: 2. Is there a trick in the append query I can use to prevent the error...? :rolleyes:
I have this bit of code in a routine. CustNum is a Numeric field with a number I need to increase by one With the code below It comes always as 1
Set Db = CurrentDb Set rs = Db.OpenRecordset("Miracle_Cloth_Main", dbOpenDynaset) On Error Resume Next rs.AddNew rs!Name = NewData rs!Cust_ID = NewData rs!CustNum = [CustNum] + 1 rs.Update rs.Move 0, rs.LastModified ' Go to new record 'Me.Bookmark = rs.Bookmark ' Go to new record 'rs.Close
im able to ru n a delete query then im able to run an append query, when i run it a second time it gives me the error numeric field overflow, any ideas guys Mark
I have an issue sorting the results on my Access 2010 Report. Here are the details:
- Report Record Source = "Portfolio Ranking" - Portfolio Ranking is the name of a query - The query includes a calculated field called "Impact Score" - FYI: this is a web database (not sure if that limits what I can do)
I want to sort the report on the Impact Score column. However, when I view the query calculation for Impact Score, the "Sort" field says "(not sorted)" and it's greyed out, so I can't select Descending as desired.
I have a .txt file wicht I link to the database. If I run a query based on that .txt file I get the Error. ...BUT sometimes if i close the database and compact it it works..
I have been using a transferspreadsheet cmd for a while now in Access 2003, but when I recently split the database so that the table the import is going to is now linked rather than residing in the same mdb file, I get a numeric field overflow error. I manually made all the values in the import 0, converted it to text, but got the same error.
When I imported the table back into the file, rather than having it linked, the transfer worked fine.
Can you not run the transferspreadsheet command on a linked table or am I missing something?
how to control the numeric field range..e.g. number 00.01< and > 99.99...I am looking for some simply code under On Change() event...how I can restrict the field should only take input number no character or special characters.
I have a database I have worked on for the sister company of the place I am employed.I have a field I am trying to make alphanumeric that has been numeric. (PO Number on the main form). I had make it alphanumeric a couple of months ago, but it disabled the Edit Customer Information button on the bottom right of the form to where I cant enter shipping addresses and things like that. It should be able to enter multiple shipping addresses.
I need making the PO Number field button alphanumeric and making sure it doesnt mess-up the Edit Customer Information button. I have attached both versions of my database. The GM at the sister company would also like me to create a Spin button where you can take an old record and keep all of the previous information on it, except it gives it a new Work Order# and you can change the date to something newer.
I have a field called PRICE and obviously it is a NUMERIC field as it need to perform calculations such as calculating Total Quantity * Price etc. At the moment the PRICE is inputted manually by the User on a Form and when it has no Price it is simple left blank.
What I wish to include is that on the REPORT when the field is empty it writes the text FOC instead of leaving it empty.
Can you please anyone suggest a way of doing this.