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
Date and Parameter question. by Dan
Hi I am having a problem in a query I am trying to pull. I have a date feild that I am querying and in the criteria I have this. =Date()- when I run this it...
December 21st, 2009 08:30 PM
by John Spencer Go to last post
4 203
Delete records by pdehner
I have a table called residency I create a query (named notdate) that uses the residency table and compares to another table. I want to take the results of...
December 21st, 2009 06:05 PM
by edward[_4_] Go to last post
5 250
Parameter Query by AccessUser777 via AccessMonster.com
Hi All, Here's what I have: TABLE1(tbl_MAIN_DISC) with the following fields: DISC_ID=PK DATE USER_ID USER DISC_TYPE_ID DISC_TYPE
December 21st, 2009 06:02 PM
by edward[_4_] Go to last post
3 283
multipling by Norm
I have a field.. SumOfPHCTC..and I want to multiply this by a value that I can enter..the value will be different each time ...SumOfPHCTC...changes each query
December 21st, 2009 05:15 PM
by Jerry Whittle Go to last post
3 155
Query Too Complex with Total line by kratz
I've had this query working in the past, but I made some adjustments, and now the query is too complex. I am trying to group/sum per agent number per...
December 21st, 2009 05:14 PM
by kratz Go to last post
8 226
This query not giving correct results by Bob H[_4_]
I am trying to find the date when we had the most rainfall out of 3234 records, so with the first query to get the maximum rainfall in a month I get 110...
December 21st, 2009 12:38 PM
by John Spencer Go to last post
4 162
Help Needed on Complicated Query by boooney
Hi- I have a database that has a number of projects and suppliers for these projects. Each project has several contracts being supplied by several...
December 21st, 2009 05:36 AM
by boooney Go to last post
1 439
using a rolling date range to sum by reluctantcoder
I want to use an update query to sum values of the previous twelve months. I tried using BETWEEN "#" & & "# AND #" & & "#" in the criteria to limit...
December 21st, 2009 12:11 AM
by KenSheridan via AccessMonster.com Go to last post
2 184
1 Field and 2 Criteria by jace
I'm new to Access but very fluent in Excel so bare with me on this. What I have is a query I'm trying to create where I have a Problem Code(numeric) and a...
December 21st, 2009 12:01 AM
by jace Go to last post
2 138
Microsoft Query by brucemel
I've been told to download Microsoft Query add in so I get minipulate some of my data in Simply acctg. I can't find it as a download on Microsoft's site. Is...
December 20th, 2009 03:21 PM
by John Spencer Go to last post
1 150
Parametery Query by T. T. T
I have built a report based on a parameter query. I have a field in my report that is a calculation( Availiable Spend: Format(*2) ). Instead of...
December 20th, 2009 01:12 PM
by Bob Barrows Go to last post
3 277
max for each person by geebee
hi, need to select the MAX centername for each person (determined by combining date. and centername AS ID) , and join that to another table by the created...
December 20th, 2009 07:34 AM
by Allen Browne Go to last post
1 162
Indentifying a payperiod by KWhamill
I want to Sum the number of hrs A has worked in a pay period. I have a chart that gives me the start and end date of the pay periods, and i have A's work...
December 19th, 2009 08:11 PM
by KenSheridan via AccessMonster.com Go to last post
2 169
select every 100th records by pdehner
I have numerous tables in one database that I must select records to send a survey to. I would like to select every 100th record an export results to an...
December 19th, 2009 07:20 PM
by KenSheridan via AccessMonster.com Go to last post
5 148
SQL Code Help by [email protected]
Hi,all Could someone help me out with some SQL code to resolve the following issue? I need to generate one piece of SQL code to be used by a report via a...
December 19th, 2009 03:51 PM
by [email protected] Go to last post
2 115
HOWTO query by passing a parameter from Infopath 20007 to a MicrosoftAccess 2007 database? by UNL | TRIO | IT Support
Hello, I have a Microsoft Access 2007 database foobar.accdb with two tables Student(ID|FirstName|LastName) and Scores(ID|ScoreA|ScoreB) with a primary-foreign...
December 19th, 2009 03:23 AM
by UNL | TRIO | IT Support Go to last post
0 179
Update type conversion error with nulls by DonnaJN
I need to simply divide one currency value by another currency value. Sounds simple????? Here are two sql statements I've tried. Most records are null, it...
December 18th, 2009 11:38 PM
by KARL DEWEY Go to last post
3 186
Record AFTER latest by date an time, grouped by serial number by ironwood9 via AccessMonster.com
I have 2 tables: tblEqLoc has the following fields: Start Date | StartTime | EndDate | EndTime | CustNum | SerialNum | EqStatus tblEndDate has : ...
December 18th, 2009 10:09 PM
by KARL DEWEY Go to last post
6 226
If then statement?? by Schon
I am new to Access and am trying to take a field and change the value depending on what the current value is. example If is 01 then "supplies", if is 02...
December 18th, 2009 09:17 PM
by John Spencer Go to last post
2 127
Sumif function in Access by Hurrikane4
Please help! I need to sum amounts if a condition applies. The source table has 3 columns: AcctNum, Amount, Category. 123 10 Tax 123 5...
December 18th, 2009 08:05 PM
by Hurrikane4 Go to last post
2 155
Post New Thread


Display Options
Showing threads 1881 to 1900 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 09:57 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.