Running & Setting Up Queries - Page 17

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.

		Home » OfficeFrustration forum » Microsoft Access
Running & Setting Up Queries

Home

Page 17 of 2165

Threads in Forum : Running & Setting Up Queries

Forum Tools

Search this Forum

Thread / Thread Starter	Last Post	Replies	Views
How to Retrieve and diplay the details in the form by naveen prasad[_2_] Dear all good day.... pls help me here. I have created a table d1 d1 fields ac_no cust_name addr_1 tel_no now i have created a form with 4 textboxes... ( 1 2)	October 1st, 2009 10:35 PM by naveen prasad[_2_]	16	358
Concatenating the same field from multiple records by DawnTreader Hello All another wierd query question. i have a union query where i get some duplicated part numbers. there is a field that i would like to show the actual... ( 1 2)	October 5th, 2009 09:02 PM by DawnTreader	16	286
If Statement by LDA via AccessMonster.com Hello, I need help writing the following for my report I am trying to relace the ReportedResult field with BRL if it is less than the RDL (Reported Result is a... ( 1 2)	April 9th, 2009 02:31 PM by misschanda via AccessMonster.com	16	266
Strip leading characters from field name by alhotch I am running Access 2007 and have a field name (RidersName) in table (ReservationDetails). RidersName is a LastName, FirstName field with the comma... ( 1 2)	July 27th, 2009 07:54 PM by alhotch	16	237
Tricky query question by Jack slsman custnum Name Month01 Month02 Month03 Month04 Month05 Month06 Month07 Month08 Month09 Month10 Month11 Month12 932 171042 SIEMENS HLTHCARE... ( 1 2)	August 11th, 2009 01:24 PM by Duane Hookom	16	221
MSAccess major Bug or am I loosing my marbles ? by ipk* This MUST be a bug. There is no way this can be correct behaviour, or can someone correct me ? I am calculating a value test and want to evaluate whether it... ( 1 2)	August 11th, 2009 08:43 PM by Bob Barrows	16	237
Time Deducted From matching time frame??? by [email protected] HELP! (Please) First, let me explain. I need to enter 3 time ranges that make up a work schedule, StartupTime, productionTime, ReconcileTime. (Lets call this... ( 1 2)	May 6th, 2005 04:09 AM by Duane Hookom	15	300
MS Access - STRING Datatype (truncating data) by Jose I am consolidating multiple cells (data) into one cell and when I do that, it seems that when it finds large amount of data in one cell it does not select the... ( 1 2)	April 20th, 2005 09:13 PM by Jose	15	186
adding column with numbers in query by Giz Hi, I am relatively new to Access and was hoping someone could help me out. I have created a query that accumulates various columns of information... ( 1 2)	February 11th, 2005 11:09 AM by Michel Walsh	15	641
Query with Criteria pulling from a form by AJ What is the syntax to get a query to recognize the second column from a Combo box? In the criteria section of the query from design view I have... ( 1 2)	January 17th, 2005 01:59 PM by AJ	15	400
Eliminating Duplicate Items in a Query by The Chinaman Hi, I have two tables in a database. 1. Has several colums one of which can contain duplicate names, other colums are unique to the ID. 2. Has a number of... ( 1 2)	December 28th, 2004 12:52 PM by The Chinaman	15	293
LARGE function in access 2000 by Franky Is it possible to use the excel function: LARGE in access 2000. or to write it in vba??? ( 1 2)	August 24th, 2004 09:55 AM by Franky	15	1,297
Select TOP n * From table1 by Saber I'm using "Select TOP 10 * From tblPost" to show my first 10 posts in a weblog. to create "next 10 posts" button, how can I change my command text? I need... ( 1 2)	August 24th, 2004 05:08 PM by Saber	15	356
request for help with a SQL update query by Paul James I'm trying to create an update query that will set the value of a Yes/No field to -1 when two fields in all the corresponding records in a related (many) table... ( 1 2)	September 10th, 2004 08:30 PM by Paul James	15	277
Determining # of employees at point in time by Teri We have an employee database. I would like to run a query that tells me who was working for us at a point in time. Example: what drivers were working for us... ( 1 2)	September 9th, 2004 07:44 PM by Les	15	338
union query by Brenda @ AIM Look at the following code: SELECT LEFT(ZIP,3) AS ZIP3, COUNT (ZIPCODES.ZIP) AS COUNTOFZIP FROM ZIPCODES GROUP BY LEFT( ZIP,3) UNION SELECT LEFT(ZIP,5) AS... ( 1 2)	October 18th, 2004 11:05 PM by John Spencer (MVP)	15	192
Escalating invoice number. by SHIPP I have a table with multiple (duplicate) invoice numbers. What I would like to be able to do in a query is to read the table and for every duplicate invoice... ( 1 2)	October 29th, 2004 07:19 PM by Ken Snell [MVP]	15	196
Automatic Update Query? by Dumb Blonde I maintain a database for a non-profit and am self-taught. One of the monthly reports is titled Birthdays. The birthday field is a text field (mmdd). ... ( 1 2)	December 8th, 2004 09:18 PM by tina	15	453
Sum Time or durrations by vzbuster sI would like to know how to sum time values and display it in short time format. Example: I have a tech name joe that visited a particular location twice in... ( 1 2)	December 17th, 2004 05:12 PM by Rick Brandt	15	218
If for rounding numbers by Mike Does anyone know a IIf statement which tells a decimal number to round up to the nearest whole number? For example if a number is 87.54 to simple round to 88... ( 1 2)	July 31st, 2004 02:14 AM by Van T. Dinh	15	225

Page 17 of 2165

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

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:58 PM.