Is it possible to use a subquery to pass multiple values to a criteria statement in another query?

Is there a way in an Access query to select the values from one column and return a line of comma delimited values? Example: ID ExText 1 ...

I currently have a query that lists all contracts set up in a certain month. However, what I need to do is not have just the month that the start date lies...

Currently I have a query that states Nights:-. The problem is that I am putting a parameter of Between two dates in the checkin field. Nights:...

I have a query that groups/totals that is linked to another table at the "group" level. When bringing in fields from the linked table, I can either specify...

-- Hansford D. Cornett

I want to run a weekly report based on a table whose name changes each week. Is there a way to have the report, or its query, or a macro, pop up a dialog...

Hi everybody, i have a table which contains the brand a customer bought and all other brands available at the...

I want to use an append query as a "hot button" as follows: Users need to add a variety of information for each contract. I have created a select query that...

It's been too long since I've used Access and I can't remember how to set this up. I'm trying to piece together a budget v actual table. Here's the raw...

Hi, All! Here's my conundrum. I need a head count by hour. I have two columns: Time in, Time out. Now what I need is a query which yields a count of people...

Hi, I am using SQL Server 2000 and Access 2002. I am trying to use one of my stored procedure in vba code. Following is the code and sql script. VBA...

I have a large list of patients with admit date, discharge date, length of stay (#day). I need to return the list sorted on calendar day of who was...

Newbie question: I have a database where we track dispatched with two tables, one called Slots, the other called Dispatches. In the slots table there are 2...

Hi Hope this is the right place for this question. The SQL Insert statement has the fillowing syntax- INSERT INTO table_name (column1, column2,...) VALUES...

I have created multiple queries and was wondering if there is any way to view all of their data at once. Can a temporary table be created through vb to dump...

Newbie question: I have a database where we track dispatched with two tables, one called Slots, the other called Dispatches. In the slots table there are 2...

Running Access 2003. I have two subqueries. One, with time entries, has 1282 records. The other lists valid "timesheet templates." I am trying to identify...

Dear friends, Please help me with the following problem: I need to update a field of a table based on a calculated field in a query. Both (query & table)...

I've been trying to add some code but I'm getting nowhere, could someone please help? The Control Source in a text box...