Strange query results/Wild characters???

Strange query results/Wild characters???

Post by TWFyY2 » Wed, 30 Jan 2008 09:00:01


Hello.

My query is showing me strange values from whem loading a value from a form.

It's very strange because if you have a form named FormA and inside a field
named Field1 and if the field has a default value of 2 and if you run it.

Then if you'll make a query with any table or query and put this in the
column: Test:([forms]![FormA]![Field1]) your result will be 2, tha same as
the the Form Field.

My problem is that my query instead of showing me the value of 2 is showing
another thing very strange, such as wild characters or value that has nothing
to do with it.

If I use that also as a criteria the problem is the same.

How can someone help?

Regards,
Marco
 
 
 

1. Strange result from query, '>' gives same result as '>='

2. Strange Query Results When Search Results Return 0 Hits

Hi group,
I recently added a large number of filters to our query results.
Unfortunately, if a user gets zero hits off of a search, the Results
page looks something like this:

No documents matched the query " (sldkfjlskdjf) AND NOT #filename
*.jar AND NOT #filename *.btr AND NOT #filename *.cnf AND NOT
#filename *.ds AND NOT #filename *.log AND NOT #filename *.ftp AND NOT
#filename *.class AND NOT #vpath *\cfide* AND NOT #vpath */_vti* AND
NOT #filename *.hhs AND NOT #filename *.css AND NOT #filename *.dll
AND NOT #filename *.mdb AND NOT #filename *.def AND NOT #vpath
*\classes* AND NOT #filename *.old AND NOT #filename footer.cfm AND
NOT #filename *.js AND NOT #filename application.cfm ".

That's BAD. Any way I can get rid of it?

Thanks!
DTS

3. What is the wild character for queries in Infopath forms?

4. girls gone wild annual report analysis girls gone wild flyer girls gone wild albania

5. Strange Ordering results when using "@" character

6. strange characters in ping results

7. ruby-odbc -- Strange Chaning of Special Character in Result Set

8. Return query results based on results of another field query

9. Query Results in Access GUI <> Query Results in ADO

10. Displaying Results Sub-Query Result in Another Query

11. Strange Characters returning from long oracle queries.

12. What is the wild card for an Access query (MS query) parameter

13. What is the wild card for an Access query (MS query) parameter?

14. Weird characters in query results

15. Combined Query - Strange Results