Running & Setting Up Queries - Page 501

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.

Thread / Thread Starter	Last Post	Replies	Views
Need MAJOR HELP to complete this query problem by troy I received this response from Mr. Walsh and it almost answers my question but is not 100% complete. I need to take my expression (see below) and update it to...	May 2nd, 2006 07:37 PM by Phil	5	144
UPDATE a new field with the combination of thre others by justagrunt Hi, I tried an UPDATE query on an existing table to populate a new field with the following; "Tag"= & "-" & Format(,"0000") & Format(,"00") but the result...	February 11th, 2007 02:46 PM by Douglas J. Steele	3	144
need help with percent by oxicottin I have a qry where I want to divide "Regular Delay" by "Employee Regular Time" and give me a percent. Example: Regular Delay 2.5hrs Employee Regular Time...	February 15th, 2007 12:14 AM by oxicottin	4	144
Make 1.5 million in 11 minutes by Virgin Mobile Find out how Roy . Made over 1 million in 15 minutes. http://alberta-oilsands.blogspot.com/	February 15th, 2007 06:27 AM by Virgin Mobile	0	144
query not giving results but with no error? by oxicottin Hello, I have a query that gets information from a tbl_AttendanceData which has 3 fields. (Field 1) Employees Name "Text" (Field 2) Attendance Code "Text"...	February 25th, 2007 08:17 PM by John W. Vinson	1	144
Date Search in Date & Time Field by hobbit2612 via AccessMonster.com Hi, Wonder if someone can help me please. I have a date and time field which shows the dates and times that files were received onto a server at work. This...	February 28th, 2007 06:37 PM by hobbit2612 via AccessMonster.com	9	144
paramter query by JRS I would like a query where I am prompted (thinking parameter query) for a name such as sally. the names however in the database are merged from many systems...	February 27th, 2007 06:47 PM by fredg	2	144
where statement by Dries Hi Guys, I got the following problem I have a table Nr Country Cost 1234 DE 1.21 1234 NL 1.28 1234 BE 1234 ...	February 28th, 2007 03:37 PM by Jerry Whittle	2	144
query calculating from a table by Falty Hey i have a table which contains new orders information includes date, model, quantity, cost , total cost. I need some way of calculating and displaying the...	March 2nd, 2007 01:16 PM by Michel Walsh	1	144
date in a query by soj I am using Office XP or Office 2000 Premium. On some of my compagnys computers, the expression for today, date(), is accepted in a query, and on other...	February 6th, 2007 11:47 PM by Jerry Whittle	1	144
Function or nested IIF in query by Dale Fye I am trying to do some analysis on some data I've pulled from an enterprise database. One of the fields contains a character string, and I need to use the...	January 12th, 2007 05:38 PM by John Spencer	2	144
complex query error by geebee When I try to save the following query, I get an "expression too complex in query expression" error: SELECT M., M.PopEnterDt, IIf(MP. Is Not Null...	May 9th, 2006 03:22 PM by Barry Gilbert	1	144
Why am I asked to enter parameter value? by JZ My query calculates the percent of hours worked on a project compared to total hours worked. Here are the relevant fields: Field: HoursWorked Table:...	May 16th, 2006 11:05 PM by KARL DEWEY	7	144
Date Format Conversion by Paputxi In a query (hopefully), how do I convert a date/time value from "MM/DD/YY HH:MM:SS AM/PM" format to just "MM/DD/YY", i.e., drop the hours, mins and secs? ...	June 7th, 2006 02:04 AM by Douglas J. Steele	3	144
Hours per WorkWeek calculated from Start / Finish Dates? by [email protected] My table lists pieces of equipment and the date/time they are taken down for maintenance, and date/time maintenance is complete (put back up to production). ... ( 1 2)	July 21st, 2006 11:50 PM by Michel Walsh	14	144
Removing the first several characters from returns by ray Have the following query SELECT MSysQueries.Attribute, MSysQueries.Expression, MSysQueries.ObjectId FROM MSysQueries WHERE (((MSysQueries.Attribute)=6) AND...	July 10th, 2006 04:16 PM by ray	2	144
Calculate between two expressions by JK I have created an expression #1 *1.03- to obtain the average on the deposits.Now i want to create expression #2 which will use the results of expression #1... ( 1 2)	August 29th, 2006 11:16 PM by Duane Hookom	13	144
computation of calculated field in query based on conditions by anyaley I want to compute taxes on salaries in a test access payroll query. Conditions are as follows: salary is a calculated field in the query and is monthly. It...	December 13th, 2006 07:10 PM by taurus via AccessMonster.com	5	144
hyperlink by geebee hi, I would like to have the user be able to click on a textbox, and have it be a hyperlink. The Hyperlink address would be the value of that in the...	January 11th, 2007 08:22 PM by geebee	0	144
rtrim using the function a query by wgreen I am trying to trim off the spaces in a text field. I started a make take query and insert expr:Rtrim() but when I run the query I gets errors. "undefined...	March 15th, 2007 12:50 PM by wgreen via AccessMonster.com	4	144

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed