|
|
complex duplicate queries by
Gary Walter
Hi Tony,
I woke up this morning thinking about
how you probably (might) want your queries
to be updatable.
One method is putting the group by in
the Where...
|
|
0 |
1,676 |
|
|
"NOT EQUAL" query by
Van T. Dinh
You got the Left Join wrong way around. The way you have at the moment, the
Query will show Records in tblPersonnel that don't have related Records...
|
May 23rd, 2004 12:27 PM
by Chuck
|
1 |
1,444 |
|
|
outlook express access to attachment by
cathy
I received an email with attachment. Outlook Express
blocked access to attachment to "suspicious email". What do
I do to view attachment? Thank you for any...
|
|
1 |
1,606 |
|
|
|
May 23rd, 2004 05:16 PM
by Samora
|
0 |
1,787 |
|
|
Between dates? by
C & J Jones
"fredg" wrote in message
...
On Sat, 22 May 2004 10:59:00 -0400, C & J Jones...
|
|
0 |
1,427 |
|
|
Dates In Queries by
Roland Hanson
I have set up a query to add up some data. I used the wizard to set it up, I set the fields I wanted added, then it asked how I wanted my dates handled and I...
|
|
1 |
1,450 |
|
|
I Can't Post by
Al Voss
Although I can view, I can not post in most newsgroups. Please help.
tia,
al
|
|
0 |
1,327 |
|
|
Can't Post Clarification by
Al Voss
Now that my former post has gone through, when I am in other newsgroups
using Outlook Express, I can view all ngs I visit. But I can't post in ANY
of...
|
|
0 |
1,450 |
|
|
Adding records to a query? by
Mike J
I have a query attached to a form. On that form I have a
combo box w/ a 'notinlist' event that is supposed to add a
record if the 'id' is not in the list. I...
|
May 23rd, 2004 09:36 PM
by Mike J
|
0 |
1,684 |
|
|
|
|
1 |
926 |
|
|
Union Query Not Working Properly by
JohnAFT
I am trying to use a Union Query to pull the top 2 records for each group from
the same table. It works for the very first part (it pulls the 2...
|
|
1 |
1,271 |
|
|
Date syntax in query by
Ginger
I get an error message with the following sql statement. It
does not seem to like the format "short date". Could
someone check the syntax for me and see where...
|
|
1 |
859 |
|
|
Random Query? by
Jenn
Access 97
I have three single digit feilds and would like to query
on only two of them however, the data is accross all three
fields.
Exsample:
Query for 34...
|
|
1 |
882 |
|
|
Date criteria syntax by
Ginger
My last post did not appear, so here it is again.
I get an error on the "short date" format. Any suggestions?
sSQL = "TRANSFORM Sum(qryBillingSummary.Hrs) AS...
|
|
8 |
889 |
|
|
Using criteria by
Dave
I have a query with the following rows:
Pro1
Pro2
Pro3
Pro4
abc1
abc2
abc3
|
|
2 |
770 |
|
|
|
|
1 |
1,072 |
|
|
Display record based on current date by
John H
I would like to select records that are valid based on todays date. In this case the records startdate and enddate need to be between todays date.
My table...
|
|
2 |
968 |
|
|
show all invoice totals by
Cheri
An invoice may have more than one item to it. Each item
is entered individually under one invoice number. I just
want a query to show the invoice total for...
|
May 24th, 2004 04:06 PM
by Rowan
|
1 |
857 |
|
|
'Not in' Query by
John
Hi, I have a few tables and want to run a query, but am
not sure how the sql will work out. I have a table that
has a list of students, and a results table...
|
May 24th, 2004 05:16 PM
by Newbie
|
2 |
855 |
|
|
Query Quandries by
Frank
i have a table, tblgeneral, that contains order
information on customers, referenced by tblcustomer, what
i am attempting to do is show how many unique...
|
May 24th, 2004 06:19 PM
by Frank
|
2 |
858 |