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
June 28th, 2008 10:47 PM
by Bob Barrows [MVP] Go to last post
1 255
Sugestions for improving query design for Access 2007 by slb52
Please consider improving the deign interface for queries by allowing you to right click on an object in the design view to open that object in design view,...
June 28th, 2008 10:11 PM
by slb52 Go to last post
0 208
inventory query by C Parkins
I have a macro with 3 queries I use to adjust my inventory. I have a problem I just discovered with the first query. The first query looks at an excel file...
June 28th, 2008 05:08 PM
by Bob Barrows [MVP] Go to last post
9 287
Cross Tab Query with DateSerial by Public[_2_]
Hi, I am creating a cross tab query to capture data for each month of the year. My query is similar to the following (This should give me all the completed...
June 28th, 2008 03:47 PM
by Duane Hookom Go to last post
1 252
Change Sequence of Characters by Leona Leal Educator
This is my first time, so hope you guys give me a break. Most of my programming is done with IBM AS 400's. I need to change the sequence of Characters in my...
June 28th, 2008 02:17 PM
by Allen Browne Go to last post
2 177
Delete Query Cannot delete from specified tables by ken957
I have a very long table using a limited number of company names, I have another long table with many of the same or similar company names. I wanted to make...
June 28th, 2008 01:54 AM
by Duane Hookom Go to last post
4 187
find all 5 fields with Max date by Mitchell_Collen via AccessMonster.com
Hi I want to create a query that will return 5 fields that have the max date or latest date. I can't get the following to work though. Select Drug, Location,...
June 28th, 2008 12:20 AM
by KARL DEWEY Go to last post
1 183
Need to find latest date in a query by DPCpresto via AccessMonster.com
My query has two fields and where the comsdate field is a date that periodic, recurring maintenance was done on a certain property. In some instances, the...
June 28th, 2008 12:09 AM
by KARL DEWEY Go to last post
2 230
make query to return a subset only if not in another subset by Peridot
I have a table in Access 2003 that list all my accounts, what day I call them, and what week I call them. Some accounts are called every week (weeks 1, 2,...
June 28th, 2008 12:06 AM
by KARL DEWEY Go to last post
1 205
Time/Date problem by Georgie[_3_]
(sorry, I posted this previously in the wrong spot) Good Morning, I searched around and couldn't find another thread with this particular issue so here...
(Multi-page thread 1 2)
June 27th, 2008 09:57 PM
by Georgie via AccessMonster.com Go to last post
11 288
Eliminate 0 value in crosstab by Rbirdie
I have a data dump (over 110k info) that is now set up as 3 crosstab queries. I then have a query to join them all together to see all informaition needed....
June 27th, 2008 08:34 PM
by KARL DEWEY Go to last post
5 177
Removing text from a field, leaving a number by PK
Help! I have been running around in circles with this one... I have a field which contans text and numbers. I need to extract the number, removing the text...
June 27th, 2008 08:26 PM
by Klatuu Go to last post
3 198
Syntax for If then Conditional Statement by Melissa
I'm trying to write a conditional statement in a query that gives me the following: If product ID = 64, 128, or 75, then the renewal rate is 1%. All other...
June 27th, 2008 08:24 PM
by Melissa Go to last post
5 170
Please need help with query by TotallyConfused
How do I write a query that say the following: If there is a middle name, then Middle Name and space. If there is not a middle name, then no space. I am...
June 27th, 2008 08:16 PM
by TotallyConfused Go to last post
5 129
Totals Query by Erika
I have a table where I enter the following info Permit# Issue Date Cost State 1234 05/08/08 40.00 WI 1235 05/09/08 40.00 WI How...
June 27th, 2008 06:25 PM
by John Spencer Go to last post
2 213
top N per employee by geebee
hi, i have a table with lots of rows. I'm trying to pull out the top 10 records by dollar amount by employee. i tried the following: SELECT , FROM...
June 27th, 2008 04:01 PM
by Klatuu Go to last post
2 149
Joined table: Returns duplicated record by ali
I have 2 tables (hard to list down all attributes , so i give an example) Table 1: Name Nationality Birthday nickname school allen...
June 27th, 2008 04:01 PM
by Duane Hookom Go to last post
6 196
updating a field with a count by Greg
I have a auction database where I have x number of steers, y number of lambs, z number of rabbits, etc. After I get the database in order I would like to...
June 27th, 2008 12:30 PM
by John Spencer Go to last post
2 154
analyze a queries with excel by Octet32
Does anyone know why when I analyze a queries with excel the format changes this also happens if I copy and paste.
June 27th, 2008 12:06 PM
by Octet32 Go to last post
2 194
Update query problem by Phil
Access 2003 I have two tables which are related by a simple join. The second table contains default values for one of the fields in the first table. I am...
June 27th, 2008 12:00 PM
by Phil Go to last post
5 227
Post New Thread


Display Options
Showing threads 10181 to 10200 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 10:20 AM.


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