Search results

Always glad to be od service. good luck as the project moves forward

The problem exists because I referred to the Address Field as Address1,a nd you refer to it as Address 1. Since you have a Special (non-alphanumeric Character) in your name (the space) the name must be closed in with Brackets like [Address 1] any time it is used. it is not enclosed in the last...

Forgive the confusion, but I was thinking you were using VBA Format. The SQL Pane Format would be something more like the following: Select a.[Member ID], a.[Address 1] From [Mail List] as a Where (cStr(a.[Member ID]) + a.[Address 1]) = (Select cStr(Min(b.[Member ID])) + b.[Address 1] From...

Show us the code the way you have it now and highlight in RED the part where the error shows up. I will look at it tomorrow morning, but if I am unable to get here soon enough, I am sure someone else will be able to help you to figure it out. -- Rookie

An alternative to doing that would be to have your Function have a parameter that is a Form, and call it using Me for the value. The reason for doing this would be to allow the Common Function to be reusable between two or more forms. If you do not have this situation, then it would not be...

The String worked for me as I posted it, but I had the logic incorrect, and it did not limit to one per address. A revised string that works in a test DB is displayed below The beginning and ending of the string are also missing (See the RED above), and I am not sure if that is the way that...

If the HIGHLIGHTED code is as you have it, it needs a space between the "&" and the "_"

Are you doing this in SQL or VBA? Your comment about the error being highlighted leads me to think that it is VBA. SQL should allow the proposed syntax, but VBA will not. The proper syntax for SQL would be either to have one long String (which would be very hard to read), or to make a series...

Did you plan to store the value in your Table? If so, then Paul is correct when he says that you should not be doing that, and you might want to take time to rethink your processs. If, however, you plan to display the value in a Form or Report, then you may already have the method (almost)...

You did not specify the name of the Primary Key for the Table [Mail List], so I have chosen to use the Field Name [AddressID]. You will need to change [AddressID] to the correct name for your Primary Key. Select [AddressID], [Address1] From [Mail List] AS a On cStr(a.[AddressID]) +...

From what I see, you want Post Codes with the first three Characters the same grouped together, but you do not want all of them, only a selected list? If this is so, then replacing the Like() with In() could work for you. The difficult part will be determining what to include in the In()...

While you are at it, post the entire Query, not just the Where Clause, since there may be issues in the rest of the Query as well

Joining a Table to itself can provide a way to accomplish this. Please note that since you did not provide specific details, the example will need to be modified to your specifications. I hope this provides a good start. Select AddressID, theAddress From tblAddress a On cStr(a.AddressID)...

I reformatted the QUery and used CODE Tags to display it, and I think that I have located an extra ")". You will need to determine what it is for. IIf(IsNull([(E) Call Taking]), [Call Handling], [(E) Call Taking]) And IIf([Mobilised])= "NO", [Call Handling], [(E) Call Taking])

of indigenous flora

crabgrass and other

Depending on the nature of your Database, Compact on Close is not always a good idea, and could actually be at least a part of your issue. When an Access Query is run, an optimized execution plan is created and saved in the Database to allow the Query to run more efficiently. When a Compact...

The structure that you have appears to be proper, and flattening the data would go against the standards and practices of Relational Databases. Besides, maintaining the Database records once ten gifts have been given becomes cumbersome to say the least. Does the vendor really need to have a...

It may not be a Corrupt Database. Try making a new Combo Box in the Main Form and see if the Query can reference that. If it can, then there must be something wrong with the identification of the Combo Box in the SubForm. A common error to look out for in these cases would be the use of the...

Also, considering that the name of the String [Price File] implies a decimal, you might also want to try CDbl(). -- Rookie