Convert Text and Numeric in query
none seem to work
Thank you for taking the time to report an issue.
What's wrong... Please write below.
How do I correctly convert & format the text values and then export the values as Date (Numeric) in to Excel?
And the date is in the UK format 'dd/mm/y'
I may have a data field incompatibility problem, but I can't be sure. I know how to check the data type in the table, but I can't find a way to check the data type for the calculated data field in the the query. (I'm trying to connect a numeric calculated field in the query to a counterpart numeric field in the table.)
I tried looking thru the online Help but haven't found a solution yet.
I cannot concatenate the field with a set number of leading spaces because the input field is not always th same size.
I have tried using different attributes of the Format function but no luck
The text values a
The desired result need to be:
Then in a separate field I need to store the (Greater than) and (less than) signs from the same text filed so:
35 (please note the space between the and the number 35)
15 (please note that there is no space between and the number 15) 1.5 0.015
Will give me:
I have one table has a column called evaluation ( text data type ), and I want to take the data and convert it into a number data type in another table or a query , something like the following
excellent=90 to 100
accepted = 60 to 79
under 60 is failed
This value is then stored in a table under therelevant field, intQuestionValue, for Q1, Q2, Q3 etc.
This works well for calculating scores, percentages etc. However the manager of the team has said that there will be times when he wants to report by the number of"No" answers for example, so that he look at trends and build these into training plans etc.
I do have a table, tblScores, which has two columns in it. One for the text element, "Yes", "No", "N/A" and the other has the corresponding numeric value in it.
Because there are numerous questions I cannot seem to create a join in a query for the numeric value to bring back the text value.
The only other method that came to mind was to write the text outcome to a table as well at the same time, but I'm not sure how I would do this at the same time as clicking the optionbutton, or would it all save when I (the user) closes the form?
Example fields are road, parking, fence, shade, etc.
Each field I entered a value 1-10 (meaning, 1 = unusable. 5 = just OK. 10 = excellent condition)
I run a query to show just these the condition values for each field at each venue, to summarise the venue's condition.
How do I now display the value 1 as text "unusable", 5 as text "Just OK" etc.
Can I use a calculated field next to each field in my query to display the text meaning for each value, so I can also keep the numeric value?