According to the help file, these are the available wizards (listed below).
There is a Lookup wizard, but no DLookup wizard. DLookup is a VBA function.
You will find the syntax for that in the VBA help file (the file accessed
when asking for help from the code editor.
The syntax is
DLookup(expr, domain, [criteria])
Where expr is frequently just a field name, domain is the table or query
name, and criteria is used to filter what you are choosing from. If you need
help with the syntax for a specific use tell us what you're trying to do and
we'll try to help. DLookup can be used in VBA code or in an expression for a
calculated textbox on a form or report or calculated field in a query.
-----------------------------------------------------------------------------
Wizards installed when you select the "Typical Wizards" component in Setup
Note You can install any of the wizards in this topic by double-clicking
Add/Remove Programs in Windows Control Panel and running Microsoft Office
2003 Setup.
AutoDialer Link HTML
AutoForm Link Spreadsheet
AutoFormat Link Text
AutoPage List Box
AutoReport Lookup
Combo Box Microsoft Word Mail Merge
Command Button Page
Crosstab Query Page Combo Box
Database Page Command Button
Export Page List Box
Field Builder Picture Builder
Form PivotTable
Import Exchange/Outlook Print Relationships
Import HTML Report
Import Spreadsheet Simple Query
Import Text Switchboard Manager
Label Table
Link Exchange/Outlook
Wizards installed when you select the "Additional Wizards" component in
Setup
Add-in Manager Microsoft SQL Server Database
Database Splitter ODBC Connect String Builder
Documenter Option Group
Find Duplicates Query Partial Replica
Find Unmatched Query Performance Analyzer
Graph (Chart) Security
Input Mask Subform/Subreport
Link Table Wizard Table Analyzer
Linked Table Manager Subform/Subreport Field Linker
Macro To Module Converter Upsizing
Note The following Access wizards are always installed: Color Builder,
Expression Builder, and Query Builder.
Wayne Morgan said:According to the help file, these are the available wizards (listed below).
There is a Lookup wizard, but no DLookup wizard. DLookup is a VBA function.
You will find the syntax for that in the VBA help file (the file accessed
when asking for help from the code editor.
The syntax is
DLookup(expr, domain, [criteria])
Where expr is frequently just a field name, domain is the table or query
name, and criteria is used to filter what you are choosing from. If you need
help with the syntax for a specific use tell us what you're trying to do and
we'll try to help. DLookup can be used in VBA code or in an expression for a
calculated textbox on a form or report or calculated field in a query.
-----------------------------------------------------------------------------
Wizards installed when you select the "Typical Wizards" component in Setup
Note You can install any of the wizards in this topic by double-clicking
Add/Remove Programs in Windows Control Panel and running Microsoft Office
2003 Setup.
AutoDialer Link HTML
AutoForm Link Spreadsheet
AutoFormat Link Text
AutoPage List Box
AutoReport Lookup
Combo Box Microsoft Word Mail Merge
Command Button Page
Crosstab Query Page Combo Box
Database Page Command Button
Export Page List Box
Field Builder Picture Builder
Form PivotTable
Import Exchange/Outlook Print Relationships
Import HTML Report
Import Spreadsheet Simple Query
Import Text Switchboard Manager
Label Table
Link Exchange/Outlook
Wizards installed when you select the "Additional Wizards" component in
Setup
Add-in Manager Microsoft SQL Server Database
Database Splitter ODBC Connect String Builder
Documenter Option Group
Find Duplicates Query Partial Replica
Find Unmatched Query Performance Analyzer
Graph (Chart) Security
Input Mask Subform/Subreport
Link Table Wizard Table Analyzer
Linked Table Manager Subform/Subreport Field Linker
Macro To Module Converter Upsizing
Note The following Access wizards are always installed: Color Builder,
Expression Builder, and Query Builder.
--
Wayne Morgan
MS Access MVP
Sue Compelling said:Hi, Access Help has said that a DLOOKUP wizard is available - though I
can't
find it anywhere - and unfortunately I don't know enough about the
subtleties
of the " " and & and _ to write the syntax myself.
Wayne Morgan said:According to the help file, these are the available wizards (listed
below). There is a Lookup wizard, but no DLookup wizard. DLookup is a VBA
function. You will find the syntax for that in the VBA help file (the file
accessed when asking for help from the code editor.
The syntax is
DLookup(expr, domain, [criteria])
Where expr is frequently just a field name, domain is the table or query
name, and criteria is used to filter what you are choosing from. If you
need help with the syntax for a specific use tell us what you're trying to
do and we'll try to help. DLookup can be used in VBA code or in an
expression for a calculated textbox on a form or report or calculated
field in a query.
-----------------------------------------------------------------------------
Wizards installed when you select the "Typical Wizards" component in Setup
Note You can install any of the wizards in this topic by double-clicking
Add/Remove Programs in Windows Control Panel and running Microsoft Office
2003 Setup.
AutoDialer Link HTML
AutoForm Link Spreadsheet
AutoFormat Link Text
AutoPage List Box
AutoReport Lookup
Combo Box Microsoft Word Mail Merge
Command Button Page
Crosstab Query Page Combo Box
Database Page Command Button
Export Page List Box
Field Builder Picture Builder
Form PivotTable
Import Exchange/Outlook Print Relationships
Import HTML Report
Import Spreadsheet Simple Query
Import Text Switchboard Manager
Label Table
Link Exchange/Outlook
Wizards installed when you select the "Additional Wizards" component in
Setup
Add-in Manager Microsoft SQL Server Database
Database Splitter ODBC Connect String Builder
Documenter Option Group
Find Duplicates Query Partial Replica
Find Unmatched Query Performance Analyzer
Graph (Chart) Security
Input Mask Subform/Subreport
Link Table Wizard Table Analyzer
Linked Table Manager Subform/Subreport Field Linker
Macro To Module Converter Upsizing
Note The following Access wizards are always installed: Color Builder,
Expression Builder, and Query Builder.
--
Wayne Morgan
MS Access MVP
Sue Compelling said:Hi, Access Help has said that a DLOOKUP wizard is available - though I
can't
find it anywhere - and unfortunately I don't know enough about the
subtleties
of the " " and & and _ to write the syntax myself.
Wayne Morgan said:Is this the same query that is the Record Source for the report? If so,
could you just group the report on the Coordinator's Name field? When you
create the group, you could also create a group header in which to place a
textbox for this field.
The above will depend on the design of the query. To use DLookup to find
this value and place it in a calculated textbox, it would look something
like this:
=DLookup("CombinedName", "[Regional Volunteer Lists]", "[Contact Type] =
'Coordinator'")
You may need more criteria than this if you need to limit it to a specific
coordinator.
Example:
=DLookup("CombinedName", "[Regional Volunteer Lists]", "[Contact Type] =
'Coordinator' And GroupID = 3")
Note the different use of quotes for the text value and the numeric value.
Adjust as needed. All of the fields in the DLookup statement have to exist
in the query [Regional Volunteer Lists]. The square brackets are for names
that have spaces in them.
--
Wayne Morgan
MS Access MVP
Sue Compelling said:Hi Wayne -
Thanks for this ..... My need is for a report [whereby I want the
Coordinator's name to appear in the Report Header only] - all the
Volunteer
Names and Contact details appear in the details of the report.
The Query name is: 'Regional Volunteer Lists'
The Coordinators name is an expression in the query 'CombinedName:
[Firstname] & " " & [Lastname]'
The Report Name is: 'Regional Volunteer Lists'
The 'Contact Type' field in the 'Contacts' form determines whether the
individual is a Coordinator or a Volunteer