Search results

with Angelina and

located in the

You did not provide a full spec, so I provided a link to get started. I am sure there must be other approaches, but I am not an Excel Specialist, so I cannot recommend any. Perhaps someone else here in the Forum has additional ideas.

I used MS Excel 2003 and accomplished what I think you want (for the four example items at least). See if you can use the following link to do it with your spreadsheet, and get back to us with further questions. -- Rookie http://www.techonthenet.com/excel/questions/create_combo.php

The ORDER BY Statement looks correct, but it is difficult to determine the issue out of context, since there could be a problem with the way you are trying to use it in your SQL Statement. Two quick things to look for include: If you add an ORDER BY Statement to a Query that already has a ";"...

While that will be interesting to see, and potentially useful. it might also not be necessary. From what you have revealed so far, it looks like you can handle your request with some behind the scenes VB Code. If I understand correctly, the Company Dropdown is based on a Query that obtains...

surprise of their

but plenty of

I understand the premise of the OPs situation, if not the details. In the database that I used as an example, there were temporary Tables that were used to hold session based information, which could differ from user to user that were built and refreshed in the Front End as they were needed...

How many Tables are you talking about? If the number is small enough, then converting all of them and copying back the ones that should not be linked might be an option. in a recent project, a similar situation existed, and after all Tables were copied it was determined that 6 or 7 did not...

Hexidecimal is not the proper type for the parameter neeeded to define BackColor. It needs to be a Long Integer. The Link below describes how to convert the Hex to Long http://support.microsoft.com/kb/161304 -- Rookie

I am not sure that your Quarterly calculations are not more complicated then they need to be. If you use BETWEEN, then they are all exactly the same format with different values, and are easily converted to T-SQL as in the above example. SUM(IIf([SYR_CTR_START_MONTH] BETWEEN 1 AND 3...

If I understand what you want, then your IIf() appears to be reversed. The proper format is: IIf({Condition}, {Value if Condition is True}, {Value if Condition is False})

The previous advice was based on having a single Date per String. If there are multiple Dates, then another approach will be required. Perhaps if we can see the structure of the Text Field in question, we can have a better idea as to what approach might be better. -- Rookie

The cDate() Function can be used to convert the String to a Date, as long as the String contains a date in a standard Date Format. Give it a try.

It does not matter if CWeight is Null or not. If CWeight can have a value of 0 (Which could happen in the second example if CWeight was NULL), the equation will produce a divide by zero error. To avoid this, consider using the IIf() Function to handle the error before it occurs. Something...

got another case

a chartreuse hat

Thank you for providing much better information. The Nz() solution will be a good place to start for you, but your implementation does not appear to be consistant with your proposed usage. The previous exhibit { Weight: ([CWeight]-[NWeight])/[CWeight]*100 }, shows NWeight being used as a part...

I can see two possibilities for your error: CWeight = 0 In this case, an IIf() Statement can be used to replace the error condition. CWeight or NWeight are Null In this case, Nz() can be used to replace the Nulls with an appropriate default value. Additional details about your situation...