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
split up one field into multiple fields by Dennis
i am looking to split up a field into multiple fields. we produce steel tubing and the way our product show in the system is a little tricky to work with in...
April 28th, 2010 11:10 PM
by Dorian Go to last post
2 226
Query keeps looking for Query1 field by Cathy
Okay... so I have this bad habit of saving queries as Query1, Query2, etc if I have not completed them and I get interrupted. It helps me get back to the...
April 28th, 2010 11:08 PM
by Cathy Go to last post
3 252
Group By Desing View by cluckers
I am running a query that I created in design view. I am linking a number of tables together to get the result that I need. There are about ten fields in...
April 28th, 2010 07:14 PM
by vanderghast Go to last post
4 213
Exclude data from field, when another field equals a certain numbe by MacNut2004
Hello, I have 2 fields. I have Job # and GL #. I need to exclude from the GL field, values that are 1234, but ONLY if the Job # = 999999. I have tried...
April 28th, 2010 06:57 PM
by John W. Vinson Go to last post
2 254
open a message box if a query is null during an autoexec macro by vander
Hope someone can help with this. I have a query that runs using an AutoExec macro when the database opens. What I want is for a message box to open instead...
April 28th, 2010 06:56 PM
by Dorian Go to last post
1 208
Date/Time criteria problem by Keith
I am trying to create a query that allows a user to select a specific date for which to show results. Following is sample SQL with a fixed criteria: SELECT...
April 28th, 2010 06:26 PM
by Jerry Whittle Go to last post
3 169
AVG crosstab query with one field containing text by Gntlhnds
I have a crosstab query that I use to display grades in a report. All but one of my classes uses numeric grades, which it uses a letter grade (just to show...
April 28th, 2010 03:45 PM
by Daryl S[_2_] Go to last post
7 214
ComboBox related query by Mike
On a form I have a ComboBox (Combo8). Is there a way to base a query on the value of what is selected in the ComboBox? Here is the SQL statement I've...
April 28th, 2010 03:40 PM
by Tom van Stiphout[_2_] Go to last post
1 171
vlookup in ms access by SJ
Hi I'm not a programer, not aware of programming, I just started using ms access recently Can anyone help me in a simple language of creating vlookp in ms...
April 28th, 2010 03:40 PM
by Jeff Boyce Go to last post
1 165
Report + chart by Ticotion
Hi I have a report thats is open with a form selecting dates from "date1" to "date2". The form is based on a table that contains all dates. The report-chart...
April 28th, 2010 12:08 PM
by Ticotion Go to last post
0 183
Count records in 10 minute time period by StuJol
using access 2003 is have the following query SELECT ., .State, . FROM GROUP BY ., .State, . HAVING (((.)="ALARM") AND ((.State)="ACT/UNACK")); this gives...
April 28th, 2010 11:59 AM
by Krzysztof Naworyta Go to last post
4 237
Select Max, return unwanted rows. by Aldred@office
Hi all, I have searched this forum with keyword max, but those solutions doesn't seem to work on my problem. Can some one please help in take a look? I have...
April 28th, 2010 06:37 AM
by Aldred@office Go to last post
4 213
Calculated field for option group by AccessKay
Would anyone mind taking a guess at what might be missing from this expression for a calculated field in my query (for the first part of my option group in...
April 28th, 2010 12:24 AM
by KARL DEWEY Go to last post
5 173
Query 90 expiration by dar
I would like to run a qry that will show me when my insurance policyies expire. Some expire in 30 days others in 90. Table:...
(Multi-page thread 1 2)
April 28th, 2010 12:09 AM
by dar Go to last post
10 293
Union query not displaying select statement by e133
I have a union query which provides column totals for a detail query. Everything works as expected but for some reason when I run the query the results will...
April 27th, 2010 11:31 PM
by Tore Go to last post
1 175
First 10 numbers by Deenos
I have a query that pulls together states from a program. I group the states and added the Count aggregate to the state field. I want access to display the...
April 27th, 2010 07:20 PM
by Deenos Go to last post
3 151
Multiple Choice by Jacinda
I am working on a school project with my daughter... we are creating a Database that will give you a test based on the questions and answers that we will...
April 27th, 2010 07:12 PM
by Jacinda Go to last post
3 269
Query to conditionally handle duplicates by bicyclops
I'm creating a Bill of Materials using a one-to-many relationship table between InternalPN and ExternalPN. So the query sometimes returns more than one...
April 27th, 2010 05:45 PM
by Daryl S[_2_] Go to last post
2 180
Long list of fields, how to check if either is null by atledreier[_2_]
I have a query with 10 fields. I need the query to return only the records where one of the 10 fields is NULL. The design window only allow 8 'levels' of...
April 27th, 2010 05:42 PM
by John W. Vinson Go to last post
3 327
Closing Queries automatically saves them by Andy
I've noticed recently that when testing queries with filters, when i go to close the query I am no longer prompted with the 'do you want to save'...
April 27th, 2010 05:39 PM
by John W. Vinson Go to last post
6 227
Post New Thread


Display Options
Showing threads 361 to 380 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:52 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.