A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Running & Setting Up Queries Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
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...
May 8th, 2010 12:22 AM
by Russell Hill Go to last post
0 217
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
May 7th, 2010 10:02 PM
by KARL DEWEY Go to last post
4 243
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...
May 7th, 2010 08:12 PM
by Jerry Whittle Go to last post
4 287
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...
May 7th, 2010 07:27 PM
by KARL DEWEY Go to last post
1 239
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 -...
May 7th, 2010 07:04 PM
by KenSheridan via AccessMonster.com Go to last post
1 312
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...
May 7th, 2010 03:25 PM
by Microsoft Access Go to last post
4 646
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...
May 7th, 2010 10:05 AM
by Allen Browne Go to last post
3 422
Microsoft Responds to the Evolution of Online Communities by No Name
Date 5/4/2010 Starting in early summer 2010, Microsoft will begin progressively closing down the Microsoft public newsgroups to enrich conversations in the...
May 7th, 2010 07:21 AM
by No Name Go to last post
0 264
Microsoft Responds to the Evolution of Online Communities by No Name
Date 5/4/2010 Starting in early summer 2010, Microsoft will begin progressively closing down the Microsoft public newsgroups to enrich conversations in the...
May 7th, 2010 06:22 AM
by No Name Go to last post
0 242
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 Go to last post
2 198
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)...
May 7th, 2010 12:20 AM
by Jack Leach Go to last post
4 236
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 ...
May 6th, 2010 10:18 PM
by Steve_A Go to last post
2 182
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...
May 6th, 2010 09:29 PM
by Petr Danes[_3_] Go to last post
4 246
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...
May 6th, 2010 08:44 PM
by John Spencer Go to last post
2 239
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...
(Multi-page thread 1 2)
May 6th, 2010 08:00 PM
by gambler Go to last post
15 310
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...
May 6th, 2010 06:00 PM
by Marshall Barton Go to last post
1 203
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...
May 6th, 2010 04:44 PM
by John Spencer Go to last post
3 246
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...
May 6th, 2010 04:01 PM
by John Spencer Go to last post
2 243
DateDiff function throwing error in Where clause by Petr Danes[_5_]
I have a set of queries that generate dates and want to use DateDiff to select those records with certain dates are greater than others. The following clause...
May 6th, 2010 03:45 PM
by Petr Danes[_5_] Go to last post
6 243
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...
May 6th, 2010 02:06 PM
by John Spencer Go to last post
5 254
Post New Thread


Display Options
Showing threads 261 to 280 of 43289
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:34 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.