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
Approximation of Calculated Field by Richard
I need to know how to approximate a calculated field in an access 2007 query...
July 22nd, 2008 10:25 PM
by John W. Vinson/MVP Go to last post
1 130
Getting a null value to display zero in count query by kahaymon
How can I get this query to yield a zero when the count of the field "ID" is zero? SELECT ., .Shift, Count(.ID) AS FROM WHERE (((.) Between #1/1/2005# And...
July 22nd, 2008 10:08 PM
by Michel Walsh Go to last post
1 127
Sum by week by Jasper Recto
I have a query that gives me the hours worked by each employee everyday. I have it sorted by day and I want it to sum the total hours worked each week...
July 22nd, 2008 10:02 PM
by Michel Walsh Go to last post
4 127
Duplicate report pages with select query by Rich[_17_]
Hi All, Here's the situation... I have two tables, one with detail information (with Unique MemberID as key), another with the MemberID and unlimited...
July 22nd, 2008 10:00 PM
by Klatuu Go to last post
1 125
Overflow from Calculation - How do I do Calculation? by Vylent Fyre[_2_]
Okay guys - I'm back =) (Oh no! I know... hehe) Here's my dilemma today... I have one calculation I am trying to do. It works great in Excel, but I just...
(Multi-page thread 1 2)
July 22nd, 2008 09:56 PM
by Klatuu Go to last post
10 178
Removing "As" Clauses by dandydan9
When I try to delete the following "As" cluases from the query below and save, Access reintroduces the "As" clauses. INSERT INTO TGR_recharge_MIDTID SELECT...
July 22nd, 2008 09:38 PM
by Bob Barrows [MVP] Go to last post
1 112
Parameter Not Working by JS
I have a field in my query that pulls from a table. The table is linked to an ODBC database. I am running a parameter for the first three letters of a...
July 22nd, 2008 09:36 PM
by Bob Barrows [MVP] Go to last post
1 121
group by weekly date by JRS
I have data by log date and I want my query to group calls by week Mon thru Sun. I also want to do by month. Is there a way to set that up? thanks Log...
July 22nd, 2008 08:52 PM
by dustinbrearton Go to last post
1 143
Due Date question by Todd
I am using Access 2003 and the standard design query view. I am working with a query that will drive a report of audits that are due next month. I have the...
July 22nd, 2008 07:32 PM
by Todd Go to last post
0 111
Approximation of Calculated Field by Richard
I need to know how to approximate values in a calculated field in an access 2007 query...
July 22nd, 2008 07:26 PM
by Jerry Whittle Go to last post
1 114
Why do I have to enter my password everytime I open Access? by KK
I set up some security file for a particular database. But now, whenever I open ANY access application, it prompts me for password. Other ppl don't have this...
July 22nd, 2008 07:22 PM
by KK Go to last post
2 127
Calculation Query by bengomets
I have a table with three columns They a Day, MTD performance and Daily change I am looking to either write a query to calculate difference between two...
July 22nd, 2008 06:29 PM
by bengomets Go to last post
2 91
Query based on two unrelated tables by ryguy7272
I am trying to build a query, based on two unrelated tables, and I am encountering some difficulties. i think Access is building something called a...
July 22nd, 2008 06:18 PM
by ryguy7272 Go to last post
2 130
Compare previous records in a query by Jasper Recto
Is it possible to compare a previous record in a query? I have a query that has 4 columns that give me the date, part, operation and Opvalue In a 5th...
July 22nd, 2008 05:46 PM
by Jasper Recto Go to last post
7 110
Concatenate number w/decimal with ascii character by [email protected]
I need to concatenate a standard format number (ie 1,2345.00) with an ascii character (ie foreign currency); however, when I do, I lose the comma(s) as well as...
July 22nd, 2008 05:32 PM
by [email protected] Go to last post
2 122
Pull Data from Multiple CSV's by Eskimo
I am able to import or link into Multiple CSV's in my database from a folder. In total there are 24 csv's so there are 24 tables. Each imported or linked...
July 22nd, 2008 05:29 PM
by Eskimo Go to last post
6 142
Property Definitions by Jasper Recto
When your in access and you right click on an object, form, query or just about anything, you can get to a properties option that has all these settings. Is...
July 22nd, 2008 05:08 PM
by Marshall Barton Go to last post
2 95
Improving queries resource usage by John
Hi I have a 10 user access backend/front end app which runs sufficiently ok. Recently I deployed a winform/ado.net app that runs a sequence of queries on...
July 22nd, 2008 04:38 PM
by William Vaughn \(MVP\) Go to last post
5 113
export query data to excel to create a mailer by Amy Schmid[_2_]
Good morning, We are attempting to create a mailer for an open house invitation. We have in existance mutiple mailers that we consistantly use. However,...
July 22nd, 2008 03:22 PM
by Amy Schmid[_2_] Go to last post
0 124
Query Criteria With Prompt by Michael
Hi Folks - I have a query criteria row that looks like this: Not In (Status1, Status2). Basically, I do no want to see those status' in the query result....
July 22nd, 2008 01:26 PM
by Michael Go to last post
0 95
Post New Thread


Display Options
Showing threads 9801 to 9820 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 12:42 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.