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
SQL query/join syntax by Spektre
This is actually a MS Access/SQL, but used in conjunction with VB.net This is a "simple" multitable join question. Some skeleton data to work with is...
(Multi-page thread 1 2 3)
October 28th, 2008 02:05 AM
by Ken Snell \(MVP\) Go to last post
20 361
Does Not IN automatically reduce Count by Amin
So here is my code: SELECT "15 Minutes" AS Category, COUNT(*) AS FROM WHERE (ENDQUEUE NOT IN("t11arz") AND (STARTQUEUE IN("Pad", "Paper")) AND...
October 28th, 2008 01:31 AM
by Ken Sheridan Go to last post
2 106
Duplicate Invoice Query by Newby to Access[_2_]
I am attempting to query a table to filter the invoice field for duplicate numbers. I am also attempting to filter the payment amount for duplicate...
October 28th, 2008 12:43 AM
by Jeff Boyce Go to last post
1 98
Queries by Newby to Access
Could someone tell me how to write the query that will filter "duplicate invoice numbers" in a table of 80k+ records and a filter for "same dollar amounts"...
October 28th, 2008 12:42 AM
by John W. Vinson Go to last post
2 112
Query corresponding to date range. by maella
Hi and sorry by my grammar mistakes (I'm Spanish) I've got a table with the following fields: and I've got another table with the...
(Multi-page thread 1 2)
October 27th, 2008 10:20 PM
by Lord Kelvan Go to last post
10 228
detecting unwanted characters by AccessMan
I need a query criterion that returns records in which a text field (255 max characters) contains any character(s) other than alpha (upper and lower case),...
October 27th, 2008 10:18 PM
by AccessMan Go to last post
8 144
Output Query by auujxa2 via AccessMonster.com
I have this code in one of my forms, which outputs a crosstab query, and formats it in Excel. The issue I'm running into, is that It doesn't complete the...
October 27th, 2008 10:01 PM
by auujxa2 via AccessMonster.com Go to last post
0 173
skip null value in field when calculating by Annemarie
I'm trying to calculate the score from survey questions, but don't get an accurate total if there are null scores. I'm working with over 40,000 surveys so...
October 27th, 2008 09:57 PM
by Annemarie Go to last post
4 104
Calculated field by Cesar
I'm new using Access, so this may be pretty easy but I can figure outhow to do it. I need to calculate a new field (sales commisions) just multiplying the...
(Multi-page thread 1 2)
October 27th, 2008 09:40 PM
by KARL DEWEY Go to last post
11 154
filter by current month name by ChuckW
Hi, I have a table with transactions that has a field called FiscalMonth that has the name of a month in it (i.e. October). I want to run a query that will...
October 27th, 2008 09:36 PM
by John W. Vinson Go to last post
4 107
Criteria from form on calculated field by menube
I have a delivery date field in my query that is calculated. When I type the criteria directly into the query exp. #10/20/08# everything works fine. If I...
October 27th, 2008 09:13 PM
by menube Go to last post
5 90
eliminate data subset from query by Daniel Collison[_2_]
A table includes records related to patient admission episodes. I have created a query that shows all admission episodes with a discharge date...
October 27th, 2008 08:48 PM
by KARL DEWEY Go to last post
2 84
Rolling Window by Doc
I need a 7 day rolling window average for each date shown on a query, for example: Date range 10/1/2008 - 10/31/2008 Fields: Daily Average MTD...
October 27th, 2008 07:47 PM
by Doc Go to last post
3 85
Parameter query where blank is like "*" by Dirtbike
I have a form and a paramter query. I want to be able to know that if the form field is blank just give me all your records. I tried IIF(Forms!Form1.Vend...
October 27th, 2008 06:51 PM
by Dirtbike Go to last post
2 80
Update query formula by bizee
I have data that includes hours per month by job category. In my months table I also have a column that is the realized hours for each month. (hours...
October 27th, 2008 06:49 PM
by John W. Vinson Go to last post
4 123
Nested Query Problem by JimT
I'm trying to create a query with a nested query and I get the dreaded "You tried to execute a query that does not include the specific expression FISYEBUD...
October 27th, 2008 06:25 PM
by JimT Go to last post
0 83
find a date within a range of dates by Gab
hi i'm trying to find a date within a range and i'm using this expression IIF( in -60,ā€Yā€,ā€Nā€) the creation date should be within invoice date - 60...
October 27th, 2008 05:11 PM
by Marshall Barton Go to last post
2 99
Query Count Question by DB via AccessMonster.com
I am having a problem with a query and getting the result that I am looking for. I have 2 fields (a part number and pass/fail combobox).What I want is to have...
October 27th, 2008 05:11 PM
by KARL DEWEY Go to last post
1 74
How to insert a column with certain values by Amin
So this is my query: SELECT COUNT(REGBASE) AS Occurences FROM WFLOW WHERE REGBASE 100000 AND STARTQUEUE IN("4ADIV","4BDIV","4CDIV","4DDIV",) UNION...
October 27th, 2008 05:04 PM
by KARL DEWEY Go to last post
3 98
Subtotals by No Name
Hi I have a query which brings in the following information: Shop Month SKU Qty Sample data might be: AL 12 123 8 BU ...
October 27th, 2008 03:00 PM
by No Name Go to last post
4 90
Post New Thread


Display Options
Showing threads 8001 to 8020 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:56 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.