|
|
Concatenating values from a many relation by
Arts
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...
|
|
2 |
165 |
|
|
Finding a Match by
TheRunner
Hello,
I have a table:
empID
interestID
empInterests
where this table contains a list of interests for each employee.
So, for example,
empID ...
|
|
1 |
61 |
|
|
Those tricky Crosstab Queries by
David
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...
|
November 17th, 2006 03:16 PM
by David
|
5 |
97 |
|
|
Cumulative Query by
FBxiii
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...
|
|
3 |
86 |
|
|
Parameter qry and forms by
hogan
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...
|
|
4 |
95 |
|
|
SQL Server 2000 link tables in Access 2003? by
JMcquillan
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...
|
|
0 |
66 |
|
|
Error 3070 Invalid field name w/ crosstab by
Steven Cheng
I had a crosstab query running that has the following sql:
TRANSFORM Sum(unionQueryUpload.Amount) AS SumOfAmount
SELECT unionQueryUpload.intStoreNumber,...
|
|
1 |
88 |
|
|
|
November 17th, 2006 01:12 PM
by Ian W.
|
2 |
82 |
|
|
Critical Help needed please on query date by
Pammi J
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...
|
November 17th, 2006 11:35 AM
by Pammi J
|
8 |
106 |
|
|
Interesting Crosstab by
Bob 4
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...
|
|
1 |
71 |
|
|
place holder, blank record, message by
BrightIdeas
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...
|
|
1 |
85 |
|
|
|
|
6 |
98 |
|
|
Query Sum Returning total times 3 by
Regan via AccessMonster.com
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...
|
|
0 |
94 |
|
|
Retrieve the Record ID Just Inserted by
Samuel Shulman
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...
|
November 16th, 2006 10:23 PM
by RoyVidar
|
1 |
118 |
|
|
Another Pass Parameter question by
TKM
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...
|
|
3 |
62 |
|
|
Add error handling to parameter query? by
TKM
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...
|
|
6 |
145 |
|
|
Append, Update, Both?!?!? by
bastraker via AccessMonster.com
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,...
|
November 16th, 2006 09:23 PM
by Tom Lake
|
5 |
168 |
|
|
|
November 16th, 2006 07:40 PM
by FIECA
|
9 |
151 |
|
|
|
|
3 |
70 |
|
|
losing trailing spaces by
CADRAQA
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...
|
November 16th, 2006 06:52 PM
by CADRAQA
|
8 |
81 |