That's just great, Sergey!
>
If you assign an alias to a table in a query you've to use it throughout whole query. The "OpClass.Multiplier" in your query references the "Multiplier" field in the current record in the OpClass table (which query doesn't use) not from the one used in the query and aliased as "oc".
Ahh! I never do use aliases so, following your example, I included them, but forgot about it when adding the other clauses - DOH!
> Avoid using ALLTRIM() in queries.
OK. But I assumed that they might be different sizes and would need to trim them both to ensure equality.
>FoxPro has date literals
Yes. Just never have used them since the old dBASE II days (I know they existed even back then) - just a habit :-)
Anyway. Just something as simple as the alias stopping it from working
This has helped me no end, and, indeed, educated me in SQL lore. Now all I need is to get the approp. multiplier under the period 1 or period 2 headings, as in the sample report layout, and I have my report cursor sorted. I've nearly done this now but it's Friday, it's well past hometime, and I outa here!
Thank you **3
Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.