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
Query with Form problem by steven
I have a query that one of the fields keys off a Textbox in a form. Form = frmLU Field in Query: PeriodClosed Field in Form: tbPeriodClosed Field...
February 19th, 2007 02:35 AM
by Michael Gramelspacher Go to last post
1 162
An IIF statement for a single character(s) Only by sdg8481
Hi please help, In a field i have variuos characters that represents orders, there is an indefinative number of combinations, all along the following...
(Multi-page thread 1 2)
February 18th, 2007 11:19 PM
by John T Ingato Go to last post
10 340
IIf statement by [email protected]
Hi, I'm pretty new to this and am trying to make a multiple IIF statment work. I'm trying to create a date based on current date and a constent month and day....
February 18th, 2007 09:00 PM
by [email protected] Go to last post
3 202
Too few parameters. Expected 2 by debraj007
Hello, and thanks for your efforts in advance :-). I have written an append query that runs when you click on a button in my form (appends the current record...
February 18th, 2007 08:43 PM
by debraj007 Go to last post
7 289
cant figure out qry by oxicottin
Hello, I have a qry that has these fields: What I want to do is I want to get the gross hours per shift. Gross hours would come from In Days date I have a...
February 18th, 2007 07:46 PM
by oxicottin Go to last post
0 151
Crosstab query totals by Blair
My sql TRANSFORM Count(QDailyWheplingReport2.) AS SELECT QDailyWheplingReport2., Count(QDailyWheplingReport2.) AS FROM QDailyWheplingReport2 GROUP BY...
February 18th, 2007 05:38 PM
by Blair Go to last post
0 138
What is an "image shape"? by kmewing
I'm fairly experienced with Visio. Most of my knowledge comes from hands-on experimentation. I see a section in the ShapeSheet called Image Properties. ...
February 18th, 2007 05:45 AM
by kmewing Go to last post
2 141
Grouping Problem in Totals Query by Connell Giacomini
My query has three fields; WorkDate, Part#, PartQty. I want to sum the total qty for each part# within a specified start & end WorkDate, as specified in the...
February 18th, 2007 04:22 AM
by Rob Parker Go to last post
3 121
Help with criteria by Paul B
I need a criteria or formula in a query to look at two fields, STATUS_CODE and STATUS_DATE, what I need is to look at status code for 25-assgn and...
February 18th, 2007 02:32 AM
by Paul B Go to last post
9 170
Using "AND" in an IIF function statement by AMFLMSC
This is what I am trying to do: I have two conditions that I want the if statement to look at. If my CF_Premium is greater than 0 and my FLS_Premium is less...
February 17th, 2007 09:25 PM
by Josh D Go to last post
3 152
Filter subform via different queries by fapa via AccessMonster.com
Hi there I've been told that it's possible to create filtered queries and assign them to different buttons on a parent form. The aim of doing so, would allows...
February 17th, 2007 05:46 PM
by tina Go to last post
4 159
Query Help for a report by [email protected]
Ok, I have a report that is tied to a query. This report works for some jobs and for some it gives me this error: This expression is typed incorrectly, or it...
February 17th, 2007 05:30 PM
by [email protected] Go to last post
2 199
how to assign a sequential row numbers for each row in a query in by Lina Manjarres
I have a large database with some complex queries. I need to have a new query based on the others. And I need to have a running sum column. My problem is that...
February 17th, 2007 04:08 PM
by Lina Manjarres Go to last post
2 228
Getting a total control to find totals for last 7 days via a query by efandango
I have an unbound control on a form that is doing a total on a query field called , I want to set the criteria from the control box and not the query. my...
(Multi-page thread 1 2)
February 17th, 2007 08:16 AM
by Marshall Barton Go to last post
18 380
Getting information from two tables with no apparent relationship by Phil
It 's late, I'm tired, and things are getting fuzzy. I have a table of parts which require numerous identified operations to be performed on them. I have a...
February 17th, 2007 06:15 AM
by Duane Hookom Go to last post
1 168
Parameter Dates in Queries - not calculating correctly by Supple
I have set up a query to determine deadline dates based on a start date. The deadline dates range from 1/1/07 to 3/31/08. I have set up a query to pull the...
February 17th, 2007 06:08 AM
by Duane Hookom Go to last post
1 173
using dlookup and multiple table querie on a single form by M G Henry
I have posted in the forms group looking for some assistance... I have a project that requires the use of dlookup to retrieve data from a matrix and then use...
February 17th, 2007 06:06 AM
by M G Henry Go to last post
2 150
Crosstab query help by Blair
I didn't get a response on this question, so I am wondering if I didn't explain what I am tiring to do well enough, or is this not possible Thanks Blair My...
February 17th, 2007 05:15 AM
by KARL DEWEY Go to last post
3 161
Finding the overall nearest match to a group of parameters (number by Frank
The real-world problem is this: I have a large number of facilities around the world that I want compare based on their operating parameters/configuration....
February 17th, 2007 04:48 AM
by Frank Go to last post
8 173
Combining Fields in a Query into Two Fields by martin
I have search the newsgroup and found some related examples, but not matching to what I need to do. I have created Query1 from a table, and I am trying to do...
February 17th, 2007 12:31 AM
by John W. Vinson Go to last post
3 101
Post New Thread


Display Options
Showing threads 20041 to 20060 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 04:12 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.