I have two tables with one to many relation between them. Say, table Book has a bookID and are related to a table Author with many authors in one book like...

Hello, I have a table: empID interestID empInterests where this table contains a list of interests for each employee. So, for example, empID ...

Hello ol wise ones, I'm using Access 2002. Two questions to help improve this crosstab query. Question1: I have combined the fields due_date and task so the...

Hi. I have a query that produces a Count of Items, by Customer, by Week. I need a report to show the cumulative total of customers over a specific time...

Hi - I've created a parameter qry based on the input of 2 comb boxes on a form. You click ok on the form, the form closes and the qry displays. However as...

I have recently upgraded to Access 2003 from Access 2000. Prior to the upgrade, I used Access with SQL Server 2000 linked tables to do a great deal of simple...

I had a crosstab query running that has the following sql: TRANSFORM Sum(unionQueryUpload.Amount) AS SumOfAmount SELECT unionQueryUpload.intStoreNumber,...

Hello, I posted a few days ago and received help but I’m still having a problem with the query I’m trying to run. I’m new to Access and if anyone could...

I am going insane with this - i have built a database for a garage which tracks customer mots - (date passed) - (date remind due) etc. i need to do a query...

I have a tour bus reservation system and have an interesting challenge. I need to build a crosstab query to show how many buses of each type have been...

When I run a query I want to create a blank record with a message "no previous record" without upsetting the primary key field and the underlying database- ie...

I have a field in a table named Author where som authors ends with a period '.' and som do not. Ex. L. Stone. or F. Olsen I want to put a period at the end of...

Hello anyone I have this query that returns the values i want. When i use another query to sum the query it returns the total times 3. i just want to return...

Hi Is there a way or retrieving the record ID of a record just added within the same SQL statement or similar method I am new to Access and in SQL Server...

Here is the trick. I am using 3 queries for my report. Two of the queires (sub) are based off the main query that holds the main parameter. As you have...

I have a between date type parameter query. How would I add error handling to a parameter. Example: If the user puts in the wrong date. I want it to return a...

Hello All Wondering if anyone has some insight into my latest dilemma. I'm building a database to handle stock quantities and location. So I have a table,...

Hi, I want to create a query that employs a dropdown to allow the user to select information from a specific field in a specific table. The purpose is to...

why do I get just the sum with Avg(+...) and how do I avoid trunacation of my formulas?

I have a query which compares two text fields for an exact match (I thought). I find that it finds differences in the text strings if there is a leading...