|
|
Cumulative Unique Record Count by
Russell Hill
I am trying to write a query to count the number of unique SKUs that have
shipped, cumulatively for each week in a quarter. My data looks...
|
|
0 |
237 |
|
|
Parse Suffix from Last Name Field by
Bill B.
I have a last name field where the suffix like JR, SR, III, II, etc is part
of the data. How can I parse the suffix and leave the last name? TIA
|
|
4 |
264 |
|
|
How to Analyze Attributes in a Query by
SHKNBKE
Is there a function/formula that you can use in a query against a field to
return what type of attribute the field value is?
If so, can you then change that...
|
|
4 |
307 |
|
|
Linking Excel Into Access Issue by
Gary
I am using Acc 2003, but Acc 2007 should work the same (I think).
I have linked an excel spreadsheet into my Access database. Almost all of
the fields are...
|
|
1 |
260 |
|
|
Date query allowing user to enter dates by
No1momof3
HI
I have a DB where I am trying to set up a search criteria using 2 tables and
one field out of each.
Table - Services Field - Service
Table -...
|
|
1 |
332 |
|
|
select @@identity returns 0 by
icccapital
I have been doing some reading, but without success in figuring this out.
How do I group two queries an insert and then an @@Identity so that
@@identity...
|
|
4 |
667 |
|
|
Edit primary key values by
GPE
Hi all,
We have a multi-user database where the primary key is set to a meaningful
text field. For many years, we have been happy with this and we never...
|
|
3 |
442 |
|
|
|
|
0 |
284 |
|
|
|
|
0 |
261 |
|
|
Finding a function call in queries by
cherman
Does anyone know of a way to find if a function is being called from a query?
Another words, I have a function that might be called from 1 or more queries
in...
|
May 7th, 2010 01:09 AM
by fredg
|
2 |
221 |
|
|
splitting of Access database by
Nandini
Hi everybody,
I have created one mdb file using MS Access 2003. After splitting this, the
back end of this file is migrated into sql server (Express 2005)...
|
|
4 |
258 |
|
|
Sort Order of Update Query by
Steve_A
I have two tables and I am updating columns in one from data in another one.
PnList table has a columns named as follows
Pn ...
|
|
2 |
203 |
|
|
Full Outer Join Question by
Barb Reinhardt
I'm trying to do a full outer join between the tables PS and Verification. I
want to join the fields titled "Non-Empl ID" in both tables. What syntax do
I...
|
|
4 |
265 |
|
|
Criteria for an email address fied by
Chi
Sorry, I posted my email at the Report session..
Hi,
I would like to make a query that give me a list of the emails address with
number in it?
I tried to...
|
|
2 |
260 |
|
|
QUERY FIELD SUM by
gambler
In have the following in my first field.
K:IIF(=1,"2",IIF(=2,"1",""))
I have the following in my second field.
H:IIF(=1,"2",IIF(=2,"1",""))
What would i...
( 1 2)
|
|
15 |
320 |
|
|
Replace wildcards with a space by
Barbara
I have a text field with all values containing an asterisk. The asterisk can
be located anywhere within the contents. I am trying to replace the asterisk...
|
|
1 |
224 |
|
|
UPDATE All Columns except one by
JensB[_4_]
Hi
I got at table with 40 Columns (Pricelist).
I am not able to use the wildcard Pricelist.*
Is there a work arround to avoid mentioning all 40 column names in...
|
|
3 |
267 |
|
|
Query Help: Average of Columns Per Row by
Idgarad
I have a table:
DATE, Region, HOUR0, HOUR1, ... HOUR23
1/1/10,ABC, 123, 231,...,141
I want to write a query that returns not only the records filtered...
|
|
2 |
267 |
|
|
|
|
6 |
248 |
|
|
Need some query help..... by
James
I'm very new to Access. I was wondering how I could display a field in a
query that is conditional. I will do my best to explain...
I want to add a field...
|
|
5 |
279 |