Search results for query: *

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

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...

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

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

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

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...

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.

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...

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...

Thank you! I will post in there.

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...

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...