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 09:47 PM
by Joseph Atie[_2_] Go to last post
2 179
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 09:39 PM
by donna Go to last post
4 229
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 09:37 PM
by dlmaz Go to last post
12 414
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 08:19 PM
by Hadi Go to last post
6 258
ciao by miranda
November 25th, 2009 07:46 PM
by miranda Go to last post
0 137
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 07:07 PM
by Bruce Meneghin Go to last post
1 195
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 06:59 PM
by Duane Hookom Go to last post
3 167
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 06:56 PM
by John W. Vinson Go to last post
2 184
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 06:13 PM
by KARL DEWEY Go to last post
2 162
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 05:53 PM
by Jerry Whittle Go to last post
4 177
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 05:34 PM
by KARL DEWEY Go to last post
1 151
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 05:30 PM
by mp80237 Go to last post
2 172
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 05:12 PM
by joe_G Go to last post
3 206
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 04:53 PM
by dsmith via AccessMonster.com Go to last post
4 273
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 04:33 PM
by Daryl S[_2_] Go to last post
3 160
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 03:41 PM
by kimb via AccessMonster.com Go to last post
8 394
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 07:13 AM
by Loggical via AccessMonster.com Go to last post
9 310
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 02:45 AM
by Ken Snell Go to last post
5 202
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 25th, 2009 12:49 AM
by Phil Smith Go to last post
0 143
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 25th, 2009 12:20 AM
by PhilT via AccessMonster.com Go to last post
2 241
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 11:37 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.