|
|
IIF Statement by
Sean
Can some one look at this and let me know why it isnot working??
The filed, (., is a field in the query
that is prompted. Based on this value, I wanted the...
|
|
8 |
185 |
|
|
Simple Calculation Question by
johnny
I've done this before, but can't recall how, it's been awhile.
I have multiple duplicate lines containing same customer name in one column
and in the other...
|
|
2 |
153 |
|
|
Duplicates in Union Query by
Anon
I have a quick question. . . If I have duplicates in Table A and I run a
union query between tables A and B, will it eliminate the duplicates in Table
A, or...
|
|
2 |
133 |
|
|
crosstab query by
prairie smoke
I have a crosstab query that is returning correct data. One field is a date
that returns months, i.e. Jan, Feb, through Dec.. Is there any way to have
the...
|
|
1 |
134 |
|
|
How do I query for past date and totals? by
DJTI via AccessMonster.com
Thanks in advance for any help or guidance.
I am trying to query for a report and am not sure how to go about getting the
last quarters totals. Some accounts...
|
|
9 |
336 |
|
|
Creating a query that tracks changes by
owliyz28
i need help creating a query that will track where and when something has
changed from year to year. i have 2 databases with lists of names and
categories. i...
|
|
3 |
155 |
|
|
Case statement issue by
ZIMMJE
The value from the first statement is the value that is always returned even
if
= 31 to 60 or 61 to 90 I still get the value from the
first statement...
|
|
2 |
222 |
|
|
comparing two tables by
imranmp
Hi,
I want to compare records from two tables:
TempTable - has all the records that i have imported, i want to check if
there are any new records that do not...
( 1 2)
|
|
10 |
482 |
|
|
select distinct by
sierralightfoot
I want to add:
SELECT DISTINCT .email1
FROM ;
to the following query in an accrees database but I just can't seem to get
the syntax right
SELECT...
|
|
5 |
154 |
|
|
|
|
2 |
214 |
|
|
|
|
3 |
194 |
|
|
Import data by
Renetta
I have a weekly excel spreadsheet that I need to import. One of the columns
reflect SSN's, however those SSN's reflecting a leading zero(s) drop off
during...
|
|
1 |
134 |
|
|
Date expressions that can exclude weekends by
michelle
When using the expressions
Date()-1
and
-
is there anyway I could get them to not count weekends?
Date()-1 works well until I need it to show Fridays totals on...
|
|
1 |
182 |
|
|
Query to extract data help please by
Terry DeJournett
I have one field in a table that contains 5 different values, each seperated
by a ",". (Example: Value1,Val2,V3,Value4,Valu5). Each value may be of
different...
|
|
1 |
148 |
|
|
|
|
0 |
138 |
|
|
|
|
1 |
141 |
|
|
|
|
2 |
238 |
|
|
Error Message 3075 by
Len
I have been running this standard query for two years. All of a sudden I get
this error message.
Run Time Error 3075
I am searching for the first character...
|
|
3 |
176 |
|
|
Consolidate rows by
BruceM
This is the SQL for a select (Totals) query that shows me the number of
parts per category that have been processed according to a particular
Technical...
|
February 14th, 2007 12:22 PM
by BruceM
|
3 |
149 |
|
|
Update query using a sub select by
Admingod
Hi Guys, I have having trouble updating a table with the result of a query to
sum a value.
The sql is:
UPDATE Invoices SET Invoices.SubTotalFees = (SELECT...
|
|
4 |
272 |