I'm a relative newbie to Access, working in 2003 and trying to build a very simple client database for my company. Here's the basic set-up I have so far:
-Clients Table contains all the relevant contact info for all clients. Name, address, email, contact person, etc.
-Orders Table contains each order the various clients have made, including dates, quantities, etc.
The Orders table contains a Client ID field...
3 results in 0.0024 seconds.
-
Issues with Parameter Query Subform in Access 2003
-
katlee started a topic Multiple parameter query; ignore blanks & have results match all parameters enteredin AccessMultiple parameter query; ignore blanks & have results match all parameters entered
I am using Access 2007 to design a database that will allow users to search an inventory of historical photographs. Currently I have a table with fields such as Date, ID, Description, Project, Division, Unit, Facility, Feature, Subfeature, Region, Area Office, and State. I am using a query by form method that have either text boxes or combo boxes for each of the fields. I want users to be able to enter in the fields that they want to search by...Last edited by NeoPa; Jul 15 '10, 04:26 PM. Reason: I tidied up your SQL so it could be read. Please use the [CODE] tags provided. -
How do I merge a Access 2007 Parameter Query into Word 2007 Labels?
I am trying to modify some code to create a mail merged label document within Word 2007, using a Access 2007 Parameter Field. My issue comes about when I cannot see the Parameter Query within the selecting list in Word. I would rather not have 40 queries for each year we are pulling, so I want to use the parameter query to simplify things.
I have thought using a Temp. Table and pulling from there - but have no clue as to how to go about...
