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'
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?
JAV = (e * f) * -1
JAV = 0
The result is exporting as a text field and not numeric and I can't specify as currency in query. Here is how I am calling the function.
On categories page, have to display only those categories which have models listed under them or at least 1 model has its display property set to true.
The problem I am having is when either the criteria is not met it crashes. I need to have a way to incorporate an if statement or something that can take the string from the string field then check to see if there is a value in the numeric field then show that value or if there is none then set the value to zero and finish the query. What do I need to do to make this work?
There is a simple query which shows the sum of the values entered into each field per month. I compare the sum monthly with another table through a union query. this is where the problem occurs.
For example: June 2011 in the union query - shows a sum of 16 - however the simple query shows a sum of 17 for the same month.
The issue seems to be with double entries on the same day. What I mean by that is - On June 16 (ID 2468) there are entries in two fields - Field A has a numeric value of 1 and Field B has a numeric value of 1.
Seems like the union query is only picking up one of the values. How can I get the query to pick up both values?
When you have set the data type to Text you will have the following settings: Text or combinations of text and numbers, as well as numbers that don't require calculations, such as phone numbers.