Dropping a query into a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have written a query that delivers me a one cell response

Field [File Reference]
Table [Name]
Total: Count
Show: Yes

Field [File Type]
Table [Name]
Show: No
Criteria ="open"

When I want to refer to that number in a form, how do I get access to refer
to just the data ?

At the moment I'm able to pull in a table view of the query, but I'd prefer
something a little more gui friendly.
 
Hi

Usually a form has a query as its source and values from this query can be
used by the form.

Often, as in your case (I assume), there is a need to get other info that
can not be part of the source query.

Where this other info has many rows you would normally need a subform but
where it is a summary returning a single value you an use domain aggregate
functions.

Look up these in Access help - especially DCOUNT.

If you add a text box with the following it should work...

=dcount("[File Reference]", "Name", "[File Type] = 'open'")

(note single quotes around open)

hth

Andy Hull
 
Back
Top