Trying To Get A Query To Change Text

Mar 26, 2007

I have a report based on a query

and it hase a [Product] and a [Quantity] field

Quantity Product
80 F2 1.25" Fiberglass Sucker Rod
60 F2 1" Fiberglass Sucker Rod
80 1" coupling
60 7/8" coupling

what i am trying to do is multiply the quantity by 37.5 if [Product] equals one of the items that are sold by the foot and leave the other items the same

this is the way it needs to display on the report

Quantity Product_Name
80 (3000') F2 1.25 Fiberglass Sucker Rod
60 (2250') F2 1 Fiberglass Sucker Rod
80 1" coupling
60 7/8" coupling

thanks for any help

View Replies


ADVERTISEMENT

Crosstab Query Change Value To Text

Jan 31, 2008

I would like to know how to display or change the value in crosstab query to text instead of numbers. I understand that the value must be numeric. Is there another method?

I would like to create in the folliwng format....

View 2 Replies View Related

Change Text To Date/Time Field In A Query

Feb 7, 2008

I have created a table called - "Test"
The properties of the table is listed below

Table Name: Test
Field Name: ADMDAT2 (Text)
DISDAT2 (Text)
Operation Date (Date/Time)

I have written a query to populate a field where the Operation Date is between the ADMDAT2 and DISDAT2

Expr1: IIf([ADMDAT2] Is Null,"",IIf([Operation Date]>=[ADMDAT2] And [Operation Date]<=[DISDAT2],"Match"))

Unfornately it returns and ERROR message... I believe this may be because, the data type of the field, matching a Text with a Date/Time, I have rerun the query using a sample table where all the fields are Date/Time, and it work perfectly.

What i need help with how do i convert a text field into a Date/Time in a query?

So i can place that in the query before i populate the Test table. therefore it all should be date/time

thanks in advance

View 1 Replies View Related

Queries :: Change Query Column Name Based On Text Box Value

Nov 8, 2013

Is there a way of using a text field value as the heading for query column?

ie change...

Column header: FieldInATable

to

[form1].[field2]: FieldInATable?

View 1 Replies View Related

Forms :: Change Text Color On A Form If Text In Field Contain Certain Word

Jul 12, 2013

I have a Form Display Data in my Access Database, which is working really well. However, users was asking if there is a way we can make Font Color Could/would change if The text in A field or Any field in my display form contained the word "SAD or MAD". Is there code for such thing in display form?..

View 3 Replies View Related

Change Value To Text

Feb 7, 2008

Hi,

I have an option group on my form. In my query it uses numbers like 1, 2, 3 and so on.

Is there a way in the query to show say Done where 1 and Not Done where 2 and so on.

On my reports I use the following

=IIf([Status]=1,"Not Satisfied",IIf([Status]=2,"Partially Satisfied",IIf([Status]=3,"Satisfied",IIf([Status]=4,"Waived",IIf([Status]=5,"Client",IIf([Status]=6,"Attorney Consult",IIf([Status]=7,"Attorney Approval")))))))

I am exporting the data to EXCEL and the numbers mean nothing to the end user they want to see what it represents.

Thanks.

Fen How

View 1 Replies View Related

Change A Number To Text?

Apr 12, 2007

Is it possible to actually change a number to text? I cant seem to figure out how. I have 2 proprietary systems one uses a number and one uses text for the same item. I know how to change the text to a number however the more efficient way for me to do this is the other way around. Its the differnce from 300 to 400 record change vs 4M. Any help would be great thx.

View 2 Replies View Related

Font Change Within Text

Sep 7, 2005

How do I change font withing a text string?

for example, to issue a message in which one word is bolded such as...

MsgBox "This macro will not work on Wednesdays"

where I would like to display the word "not" in bold, or even a different colour.

View 1 Replies View Related

Change Color In A Text Box

Nov 21, 2005

On a form how can i get the text to change to red if the number is Greater than 500 and blue if the number is less than 500, the text box is populated via a query

Jabez

View 3 Replies View Related

Change Text Colour

Feb 8, 2006

Friends,

I would like some help with my form.

I would like the following:

If txtname is null (without data), then txtdob font is changed to colour white.

Any help?

Thanks.

View 1 Replies View Related

Change Text Yy.mm.dd To Date Dd/mm/yyyy

Sep 12, 2006

After having to take on the work of someone else and finding that the dates were stored as text in the format yy.mm.dd I would like to change it so it is dd/mm/yyyy and stored as a Date.
I was thinking about using an update query rather than go through 10000 odd records!

Any ideas?

View 2 Replies View Related

Change Text Color In A Combo Box

Feb 5, 2006

I have a report card program that I use in my classroom. The program calculates letter grades for various sub categories.

For example, under the Primary Category Math, the computer will calculate a letter grade based on assignment scores and place the grade into a combo box for the sub category "Able to use a graphing calculator."

If I override the grade the program calculated for a student, I would like the text in the combo box to change to red for that student only. Then I can go back and quickly see which grades I have manually changed.

I just cannot seem to figure out the logic to use VBA that would check to see if a user has changed individual combo boxes.

Thanks ahead of time for any ideas.

View 2 Replies View Related

Change Button Color Text

Sep 8, 2004

I have an option group of buttons. Is there a way to change the text color of the chosen button?

Thank in advance - John

View 1 Replies View Related

Change Background Color Of Text Box?

Aug 26, 2003

I need to change the background colour of a text box after a change to the field has been made?

ie.

Make: IBM (Background Color Grey - Default)

User makes a change to Make ..

Make: Toshiba - (Background Color changes to Yellow )

I'm trying to code this with the OnChange option on the TextBox but can't see to find the right code.

I was using Application.SetOption"Background", colour value with no success

View 2 Replies View Related

Tables :: Change Text Format To Yes / No?

Aug 30, 2013

I came into a database where the forms have checkboxes connected to table fields that are in text data type. I see that when the checkbox is checked, the value in the field is still -1 in the table. Is there a reason to change these fields to Yes/No data type or just keep them as they are? Are there limitations or problems to having Yes/No values (-1) in a text field?

View 2 Replies View Related

Forms :: How To Change A Default Value In A Text Box

Aug 28, 2014

In a text box, [OrderDate], the default value is set to Date(). Now I wanna change the date without changing the default value and the new input value would be carried over to the next record until I say otherwise. Is there any way to do that?

View 3 Replies View Related

Automatically Change Combo Box Value Trigger By Text Box

May 9, 2006

Hello,
This is the first time I am join this web & forum. My name is Angie.
I have face some problem for Ms Access. I would like combo box to be auto change when date due. Eg: combo box name: Status. Inside have info such as Expired, Active, Ignore. This info will base on the text box name txtenddate. When the date is due, (eg:today:09 May 06), combo box will auto change the status from Active to Expired.

Any VB code can be used. Thanks.

Hope to heard from you soon.

Regards,
Angie

View 1 Replies View Related

Change The Navigation Button Record Text

Dec 16, 2005

I have a subform in datasheet view.

Would it be possible to change the text 'record' to 'Line'? If so how?

View 2 Replies View Related

Code To Change Color Of Text On Combo Box

Dec 30, 2004

I have two forms sourced from one table. if the address of a client has changed then there is a Command button that opens a form to enter the previous address.

What I want is for the text on the command button to change to red if there is a previous address filled in. I have seen it done but cannot copy the code. What I have is on the OnCurrent event of the (main form)

Dim InColor As Integer
InColor=255

Me.[Command126].Forecolor=(And what I want to say here is "If the field previousaddress is not null then ...)*255

Any ideas??? (I wanted to have the database completed before the New Year (less than 12 hours to go!!!)

View 2 Replies View Related

Using Update Querry To Change A Text Character

Mar 25, 2007

I have a database that I imported as a comma deliminated csv file. To keep my original text comas intact I changed all the commas to semicolons before I created the csv file and imported the data. I now have a data base with semicolons in place of the original commas.

I am trying to use the update query function to change all the semicolons back to commas in one of the database fields called File_name


I have a data entry where a record in the File_name field looks like this for example

Chevrolet cavalier; red

and I want to change it so that it looks like

Chevrolet cavalier, red


I run an update query with the criteria set as Like "*;*"


and this finds all the records which have a semicolon in them

I have set the update field to "*,*"


but all this does is to change the record from


Chevrolet cavalier; red

to

*,*


Is the query update the way to go and what is the syntax that I should be using in the Update field just to change the semicolon to a comma and leave the other text intact?


thanks Mark

View 1 Replies View Related

Forms :: Label Or Text Box To Change To Name Of Filter?

Jun 9, 2015

I have a Menu form that has 5 cmdbuttons that opens the same main forms but with 5 different filters. I want a label or text box to change to the name of the filter. I am using VBA to open the form. I can't code a form that's not open yet. Is there any way to accomplished the above?

View 14 Replies View Related

Change Memo Unbound Text Box When Combo Box Changes

Dec 8, 2013

I have

an unbound combo box
an unbound text box (made to resemble a memo field)

a continuous form with many schooltype

The form is filtered by schooltype when the unbound combo box is changed i.e. high school, primary etc

I have made a field in the tblSchoolType called emMessage1 (there is 2, 3 etc)

The idea is that you choose to filter the form and then the relevant type emMessage1 appears in the text box

So if you choose high school then the high school emmessage1 appears (filled with the text) because all the high schools are tied to tblschooltype - when you select high you are getting the high emmessage1

When I select all records I am guessing that the text box will be invisible until you select a school type in the combo box (to avoid problems)...

When you have selected a type, the text gets swapped accordingly to the corresponding id of school type id thus changing emMessage1 to suit and make the textbox visible...

Now I can type in the field and it saves it in the table however:

I do not know how to do this. I thought about dlookup but not sure if that will allow me to change or whether it will do this...

View 7 Replies View Related

Auto Colour Change Depending On Text Selected

May 5, 2005

:) Hello

Is it possible to change the colour of the text in a table. For example the word "URGENT" is selected from a combo box, and when viewed in the table it appears red.

Thanks inancipiation

Woozie

View 1 Replies View Related

Command Button To Change Font In Text Field

Dec 2, 2004

I would like to make a command button to change the font in a text field on a form.

Can any one give me an example of the code that I would use to do this? I would greatly appriciat it.

View 5 Replies View Related

Forms :: Expression To Change Color Of Text According To Date?

Jun 26, 2013

I am attempting to create an expression that will change the font to red if it is an overdue date. It will be on a form with the records showing.

My datebase is for entering, changing, and searching for information dealing with orientation dates, contacts, and associations. My data sheet holds the company name, employee name, date of orientation, due date (orientations are completed annually), contact employee, and status. I would like the date, when opening the form, to show red if it is past due. how to create an expresion to return the status as "Current" or "Overdue", as I am still unsure which method I want to use.

View 1 Replies View Related

Reports :: Dynamically Change Text To Time Period

Jul 13, 2015

Could I change my unbound textbox (txtperiod) on the Report to display the time period.i.e.

Weekly, Monthly, Quarterly

Criteria is BeginDate and EndDate on main form.

View 1 Replies View Related







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