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 derfloh 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: *

  • Users: yleeSF
  • Content: Threads
  • Order by date
  1. yleeSF

    Count Records that are not " "

    Hello! Query: Fields ID # 12345 03/06/04: IIF ([3/6/04]>39.5," ",[3/6/04]) 03/08/04: Same as above Report: Tied to Query Above. Trying to count all 3/6/04, 3/8/04 records that do not contain " ". Is this possible? I've tried the following formula in my report: Count([3/6/04]). The...
  2. yleeSF

    SORTING...Does access sort to the tenth decimal place?

    Hello! Query: Only Store # & % Plan Hours fields. Sorted % Plan Hours in Descending Order, but it did not sort the records to tenth decimal place correctly. For example, Access returned the records in descending order as such. Store# %Plan Hours 2...
  3. yleeSF

    Report....Question

    Hello! Created a Report that is summing by Quarter. Question is how do you reflect Quarter 1 or Quarter 2 as a label. I can create a text box with Quarter, but would like it to state it's related Quarter... (i.e. 1, 2, 3, 4). How do you do this? Any help would be appreciated. Thanks!
  4. yleeSF

    Rank - How can you Rank data in Access?

    I need to Rank Sales Figures for a specified Period? Is their a function in ACCESS or an SQL statment that does this? Thanks!
  5. yleeSF

    Subtotal Query / Parameter Query

    Create a Query where the parameter applies to two differnt tables with the same Field Name. For example, Table 1 Store Sales Date Table 2 Store Sales Plan Date I would like to create a subtotal query based on the two tables above. I would like the Parameter Between [Start date] And [End...

Part and Inventory Search

Back
Top