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
Nested or Sub query? by Joseph Atie[_2_]
Im a bit lost as to how to go about this, I have 3 queries that i built in access query builder which join 4 tables together in order to generate a...
November 25th, 2009 08:47 PM
by Joseph Atie[_2_] Go to last post
2 108
FORMATTING RESULTS IN CALCULATED FIELD by donna
In design view of a query, I am trying to make a new field by subtracting one field from another. Since the field to be subtracted is sometimes null, I used...
November 25th, 2009 08:39 PM
by donna Go to last post
4 135
How to calculate work hours between two time/dates by AleJeSe
Given the following table tblEvents, event user startdate enddate elapsed work 0156 Pam ...
(Multi-page thread 1 2)
November 25th, 2009 08:37 PM
by dlmaz Go to last post
12 303
Remove Certain String from Query Field by Hadi
Hello Experts, I have a query with mulitple fields. one of them contains the names of the projects our depatrment is working on. the name starts with a 4...
November 25th, 2009 07:19 PM
by Hadi Go to last post
6 132
ciao by miranda
November 25th, 2009 06:46 PM
by miranda Go to last post
0 73
3-Tier Crosstab Report by DT
I need to create a query which when completed will popluate a report that has a 3-tiered column layout. I have multiple Stations (numbered text field like:...
November 25th, 2009 06:07 PM
by Bruce Meneghin Go to last post
1 128
24 rolling periods by mccloud
We have an ERP system that stores monthly qty's sold information by item. So Nov 2009 is period 23. Jan 2010 will be period 01. Query will work from a...
November 25th, 2009 05:59 PM
by Duane Hookom Go to last post
3 112
using field name as value in query by Titlepusher
I have a "contractor" table with names and phone numbers and .. many yes/no fields which bear the names of Counties. I want to be able to search for...
November 25th, 2009 05:56 PM
by John W. Vinson Go to last post
2 102
Ask for date by PhilT via AccessMonster.com
I have a situation of asking user to input begin date and end date, but query keeps give me all previous year. For instance, if I asked for 11/11/2009...
November 25th, 2009 05:13 PM
by KARL DEWEY Go to last post
2 89
Pass Through Query Translation by Kou Vang
How do I translate this into a pass through query? I've been puzzled over this for a day now? SELECT STORET1_TSRFDACT.START_DATE FROM STORET1_TSRFDACT WHERE...
November 25th, 2009 04:53 PM
by Jerry Whittle Go to last post
4 117
Rolling Periods by mccloud
I have a form that a user can enter the number of periods to review up to 24. Current period (Nov 2009) is 23. How can I calculate the correct periods to...
November 25th, 2009 04:34 PM
by KARL DEWEY Go to last post
1 85
Identify closed/finalized records the month they were opened Acces by mp80237[_2_]
Hello I have a query, qryClosedRecords, where I need to report if the records finalized/closed the same month they opened. So if it opened #10/05/2009...
November 25th, 2009 04:30 PM
by mp80237 Go to last post
2 116
help with finding lowercase characters in table by joe_G
Hi, I have table with 5 columns - one of which is Last Name - and I need to pull all last names that are in lowercase. The table has 10,000 records and the...
November 25th, 2009 04:12 PM
by joe_G Go to last post
3 106
Survey Qustion by dsmith via AccessMonster.com
I'm working on a survey database but I 've run into a problem. The series of questions I'm asking will all have 1 of 3 possible answers; yes, no, or NA. I'm...
November 25th, 2009 03:53 PM
by dsmith via AccessMonster.com Go to last post
4 173
Query Help by DCL
I have a table that has zip codes listed multiple times for different plan areas, so one zip code might be listed 4 times once for northeast, once for east,...
November 25th, 2009 03:33 PM
by Daryl S[_2_] Go to last post
3 91
Query to find a range of data by kimb via AccessMonster.com
I am trying to figure out a way to have a query search between 2 separate fields that are both alpha/numeric. I am trying to match our Canadian offices with...
November 25th, 2009 02:41 PM
by kimb via AccessMonster.com Go to last post
8 181
Date Expression by Loggical via AccessMonster.com
I use this expression in the criteria in a Query. How can I modify it to obtain records for a 24 hour time period? At present it produces records for the...
November 25th, 2009 06:13 AM
by Loggical via AccessMonster.com Go to last post
9 148
Sum means empty query? by Phil Smith
I have a query, five table join, but nothing really complex. I run it, I get 339 records. I hit the Totals button, add a couple Group By, a Max and SUM, and...
November 25th, 2009 01:45 AM
by Ken Snell Go to last post
5 105
Export Format not avaiable by Phil Smith
"The Format in which you are attempting to output the currentobject is not available." I hate access sometimes. It just get's weird, throwing bogus error...
November 24th, 2009 11:49 PM
by Phil Smith Go to last post
0 89
Convert to PST from GMT time by PhilT via AccessMonster.com
I need help to convert date and time to value rather than string. This is the background. 1. A table contain a Date field and Time field separetely. 2. In...
November 24th, 2009 11:20 PM
by PhilT via AccessMonster.com Go to last post
2 113
Post New Thread


Display Options
Showing threads 2181 to 2200 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:55 PM.


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