Search results for query: *

Thanks for your responseS. Here is the full code that still returns duplicate DocumentHeaders.SoldToFax or Document.ShipToFax values: (SELECT DISTINCT DocumentHeaders.SoldToFax, Min(DocumentHeaders.SoldToCompany) AS MSoldToCompany, Min(DocumentHeaders.DataSource) AS MinOfDataSource...

How do I set this query to return only distinct values for DocumentHeaders.SoldToFax? (I thought this is accomplished by the GROUP BY function). SELECT DocumentHeaders.SoldToFax, Min(DocumentHeaders.SoldToCompany) AS MSoldToCompany, Min(DocumentHeaders.DataSource) AS MinOfDataSource...

In regard to the initial query code provided: I am creating a web application inwhich someone can remove his fax number from our database by setting the fax number's corresponding faxremove field to equal "yes". Being that part of the fax list is being fed by a quoting app and duplicate fax...

How would I alter the following code so that the Group By function eliminates duplicates from the DocumentHeaders.SoldToFax and DocumentHeaders.ShipToFax fields combined (as a result of the UNION query)(In other words, when the UNION query combines all fax numbers from both the SoldTo and ShipTo...

How do I remove extra space in the middle of a text field. There is not supposed to be any spaces in this field. Please provide specifics. Thanks!

One more question: What if I need to change from this formating: 123-456-789 to (123)456-789 or from 123456789 to (123)456-789 How would the function code change?

Thanks again for your assistance. I'm still having trouble though. What do I save the module as (so that the SQL code refers to it)? Do I have to customize the function code at all? I assume that I should not be puting the words "AliasFieldName: " into the SQL?

From what I understand, some of the code is inserted into the query's SQL view and the other gets saved in a module? How do I refer to the module code while inserting the code in SQL view?

Thanks for your reply. In which portion of Access' interface do I insert the above code sniplets as I do not have hand-coding programming knowledge.

I have created a union query of two tables that list fax numbers in a text field (notice that I don't have authority to change this field format to numeric) The resulting query has some fax numbers formatted in 2 different ways: (123)456-7890 and 123-456-7890 How to I change the resulting...

I would like to exclude any customer that has an invoice in our system from a fax campaign. If the docstatus="invoice" then I would like faxremove to equal"yes

I would like to set the value of an Access database table field to "Yes" if another field in the same record (of the same table) contains the value "invoice". Can I insert If statements into the SQL table view? If yes, what is the proper syntax to achieve this result? If not, what is the...

I have a web search application. I would like to be able to send the search results as the body of a text email. When sending e-mail with CDOSYS, how do I specify the region of the webpage that I would like to be sent in the TextBody?

The reason for duplicate contact data in the database is because it is the backend database for our quoting software. Along with each quote is saved the current contact info for the customer. The query of discussion was created by joining the 2 tables that store the quoting documents...

the record id does not matter. As long as there is only one result per SoldToCMAccountNo. Please go to: http://www.canchair.com/customer_locator/customer_locator_postcode.asp Type in the Postal Code "76555" and click Submit You will see 3 identical results. This is the problem I face. I...

I only want one record for every SoldToCMAcountNo, even when there are duplicates caused due to the inclusion of the other fields.

While DISTINCT will bring results of only one record per SoldToCMAcountNo from the first query listed below, it has no effect from the second query as there are more than one field specified in the SELECT statement. >How Do I alter the second query so that there is only one record per...

would a possible solution be setting the initial value of Request.Querystring("PostalCode") to a default value, such as "-1" and having this value remain unchanged unless there is a fresh value provided by the querystring value passed on from page two? If yes, how would I code this?

I did this test: If Request.QueryString("PostalCode") ="" Then Response.Write "The string is empty" Else Response.Write "The string was not empty" End If Surprisingly enough when I thought the string was empty it was not! Thanks for this valuable tip. Now what do I do? More app details-This...

Each of the following recordsets work as intended when used individually, however, I would like to switch between the two based on if Request.QueryString("PostalCode")has or does not have a value. I'm not sure if the proper code would include the IsNull or IsEmpy but when tried either one (see...