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

  1. daviegravy

    Suppress Form Elements If Empty/Null

    More specifically checkboxes... I found you can suppress textfields by the 'can shrink' option, but that option is not available with checkboxes.
  2. daviegravy

    Suppress Form Elements If Empty/Null

    Is there a way to not output, say a textfield and associated label, if the data source used to populate that form element is empty/null/false? I need to make some elements on my report more dynamic and having a list of empty checkboxes not only makes it cluttered, but technically serves no...
  3. daviegravy

    Accessing Fields From Other Queries In A Report

    How do I add a field from another query to a reports record source if it's already using another query as its source?
  4. daviegravy

    Accessing Fields From Other Queries In A Report

    Amazing! That DLookUp was exactly what I needed. Thanks so much guys for the replies!!
  5. daviegravy

    Accessing Fields From Other Queries In A Report

    Only one record is being returned from that query. I'll look into those functions. Thanks for the replies!
  6. daviegravy

    Accessing Fields From Other Queries In A Report

    I would like to know if I can access fields from other queries in a report? I'm trying to use the expression builder to do this, but it keeps prompting me for the value as a parameter. My data looks like... =(Sum([CountOfnotification_only])/[get_counts_clients_total!CountOfclient_name]) Is...
  7. daviegravy

    SubQuery...

    Okay, I was wondering about that. I'm pulling from multiple tables though, ... Do I just list them normally like a FROM clause? His query shows that all those intial fields I select are from tb1 when they actually come from multiple tables.
  8. daviegravy

    SubQuery...

    Okay... I've tried modifying my query to meet your structure and I'm getting a syntax error around keyword "HAVING" Here's my query... SELECT dbo.DataEnrichmentRequirements.IEPOrderNumber, dcuser.RunBooks.ID, dcuser.RunBooks.RunBookName...
  9. daviegravy

    SubQuery...

    I need some help refining my query... My query is.. SELECT dbo.DataEnrichmentRequirements.IEPOrderNumber, MAX(dcuser.RunBooks.ID) AS SpecialID, dcuser.RunBooks.RunBookName, dbo.Client_overview.wfg_flowsheet, dbo.Client_overview.wfg_flow...
  10. daviegravy

    Subquery or not?

    Thank you! I will post in there.
  11. daviegravy

    Subquery or not?

    Well the Runbook ID is the field that has differnet values for different records, the higher the value, the more recent it was modified. That's why I want to max on it so I can get the most recent. Example: OrderNum RunBkID Other Data... 10001 75 10001 2275 10001...
  12. daviegravy

    Subquery or not?

    I need help with my query. SELECT dbo.DataEnrichmentRequirements.IEPOrderNumber, MAX(dcuser.RunBooks.ID) AS IDField, dcuser.RunBooks.RunBookName, dbo.Client_overview.wfg_flowsheet, dbo.Client_overview.wfg_flow, dbo.DataEnrichmentRequirements.IBEEnvironmentProd FROM dcuser.RunBooks INNER...

Part and Inventory Search

Back
Top