Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. btetsola

    Expression for defined report Sorting

    Hi That sounds like a plan!! Thanks again Benson
  2. btetsola

    Expression for defined report Sorting

    Hi Sorry for the confusion. I would like to custom define the sort order of my report. Non-Alphabetical and Non-Numerical. eg sort order: 'wde' 'mre' 'ade' and so on. Thanks again
  3. btetsola

    Expression for defined report Sorting

    Hi I have created a report which I want to custom sort based on specific values of a field. Eg. Table records 4000. Field to sort by [Progarea]. I want to sort by 13 unique records in field [Progarea]. I have tried to create expressions but there does not appear to be enough rows. Thanks...
  4. btetsola

    Is it possible with one sql query?

    Thanks for that Andy, I'll give it a whirl.
  5. btetsola

    Is it possible with one sql query?

    Hello Duane Thanks for that. Sorry about the formatting issue. I'm afraid I'm not familiar with TGML formatting. Yes I am trying to filter out certain records based on the multiple 'iif' criteria I mentioned. Once again thank you for all your help Benson
  6. btetsola

    Is it possible with one sql query?

    Hello I've been trying to put together several tables/queries in order to pull out data from the truncated table below. I was wondering if a Sql 'IIF' with 'switch' type query could do it in one go. Parameters: If the [Actual Date] is Null and the [Month Slippage] is >0 then retrieve the...

Part and Inventory Search

Back
Top