Queries

Produce a list of names based on data from two fields
I have a query based on a table with 2 columns. PatientID LinkID PatientName 16 20 Joe(16) 25 16 Mary(25) 31 12 Tom(31) 27 20 James(27) In a form I, I will have an... 10 Jul 2008 11:20

Conditional Criteria within a query
Hi! I've got the following fields and I want the second to contain criteria contingent on the value of the first: Dept_NBR is a number coming from a form selection of multiple #s and if it is 28, I want Class_NBR to be 7 or 20 or 22. If Dept_NBR is not 28, I want the Class_NBR criteria to be null. Not sur... 10 Jul 2008 03:08

Conditional IIF question/null value
Hi! I've got a combo list in a form which I have the choices of multiple numbers and an ALL choice (21, 22, 23, 24, ALL). I'm trying to use an IIF statement in a query to either pull in the selected number to a criteria or leave the criteria blank in the case of ALL so all data ends up in the report. IIF([For... 10 Jul 2008 01:01

Microsoft Access 2003 Update Query to a null value
I have a database that tracks items and who they belong to for work. The person and everything they have been given are entered into a form which updates the appropriate tables. Every item has it's own table with the serial numbers already listed and blank fields for a person's name and locker number.The update... 10 Jul 2008 08:15

SQL and Query results don't Match
In a very simple query I entered that I only want to retrieve data for product 200. After the query runs results show results for product 200 but also for other products, and I don't understand why. When I export the data to excel I only see the product 200 results as if the query worked fine. Why is this happe... 10 Jul 2008 09:16

Offer a Default in a Criteria
Hello all, I want to create a query that offers a Default in the criteria under a Date field, for example: [Enter Date From] "default as Date today -7" This will allow the user to either press Enter for all records a week ago or type in the Date Required. Ross ... 9 Jul 2008 22:58

Need help with query linked to form.
Hi, I am trying to run a query based off of an unbound field in a form. Essentially I would like the end user to input a date in the form and hit the command button to run the query where the date would cross over to the query criteria. I have done this in access 2000 but since upgrading to 2007 it doesn't seem... 10 Jul 2008 13:25

Delete all modules but 1
Here is code I have that deletes all queries, forms, and reports. The last part I want to delete all modules but one. Any ideas? Case 4 is modules, and the last line of the code is where I think the code I'm asking for should go. Just don't know how to word it. Thank YOu in advance Dim db As Database 'Data... 10 Jul 2008 10:18

Help with complicated query?
I am still new to Access and queries, but I understand the basics of SQL. I have my table set up in the following format: StationID Date_Time LocationID 42361 20070805 2 42361 20070807 2 42361 20070808 2 42361 20070809 3 42361 20070810 3 42362 2007010... 10 Jul 2008 13:25

Missing Records in a 2 Table Query
I have a query where I am combining two tables- "Leads" (contacts) and "Listings" (addresses). Not every Lead has a corresponding record in the "Listings" table. When I make the query, it only shows me the records that have entries in both tables, but I want to see all of the "Leads" even if they don't have a "Li... 9 Jul 2008 17:50