If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
What Formula Can I use
I was wondering if anyone knew of an Access formula that I can use in a field
that would return the following statement if true. *if the records in field XX contain any numerical values give me this……..if not then return all the records in field XX Basically I want the formula to recognize any numerical values and give it a name that’s dependent on the value of another table if not then return just |
#2
|
|||
|
|||
What Formula Can I use
Santi
In Access, tables store data. To do the kind of analysis/conversion you describe, consider using a query. Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Santi" wrote in message news I was wondering if anyone knew of an Access formula that I can use in a field that would return the following statement if true. *if the records in field XX contain any numerical values give me this....if not then return all the records in field XX Basically I want the formula to recognize any numerical values and give it a name that's dependent on the value of another table if not then return just |
#3
|
|||
|
|||
What Formula Can I use
Create a tblDigits with field Digit containing 0 (zero) through 9 (nine).
Add it to your query like this -- SELECT TableA.Title, InStr([TableA].[Title],[tblDigits].[Digit]) AS Expr1 FROM TableA, TableA AS tblDigits GROUP BY TableA.Title, InStr([TableA].[Title],[tblDigits].[Digit]); -- Build a little, test a little. "Santi" wrote: I was wondering if anyone knew of an Access formula that I can use in a field that would return the following statement if true. *if the records in field XX contain any numerical values give me this……..if not then return all the records in field XX Basically I want the formula to recognize any numerical values and give it a name that’s dependent on the value of another table if not then return just |
Thread Tools | |
Display Modes | |
|
|