Running & Setting Up Queries - Page 395

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
Multiple Time criteria by Slightly Befuddled I have a database that records several times. I need to report on time intervals for several points. I am using a select query to gather the data. Several of...	June 1st, 2005 09:17 PM by Slightly Befuddled	5	133
group by clause by rv I want to count the number of groups returned by a query. Conversely can some one help me in creating a query which will take a number like 3 or 4 or 5...	June 1st, 2005 09:21 PM by Michel Walsh	1	72
Using parameters by anthonysjo Is it possible to enter a range in the criteria box? For example WE 051405 - WE 052105. What I would like to do is enter a criteria of then when prompted...	June 1st, 2005 09:29 PM by anthonysjo	3	94
Access 97 using a saved query in MS Query by Eric Hello all, I am hoping someone can shead some light here. I am using the ODBC Client Access driver to access some information from the iSeries. I have set up...	June 1st, 2005 09:52 PM by Eric	0	200
use between statement in an iif statement by Jim Lambrecht I need help with an iif statement in a query. Basically I have a form that the person uses to either choose a month or choose all months using option buttons....	June 1st, 2005 11:34 PM by John Spencer (MVP)	2	62
Create data in a field with multiple lines? by Larry Hodges Hi all, Running A2k I have to export data from Access to QuickBooks. Part of that is the addresses for customers. The problem is, QuickBooks views the...	June 2nd, 2005 12:47 AM by Larry Hodges	2	81
creating a query for a report by Edward Letendre I am in a bit of a confused mode at the moment. I am building a new query to get data that is linked between an access 97 front end database and a sql server...	June 2nd, 2005 03:04 AM by Edward Letendre	1	70
Setting the level of precision by anthonysjo Can someone tell me how to se the level of precision when defining criteria for a field. For example: I am trying to limit my result set to anything 0 but...	June 2nd, 2005 11:21 AM by JohnFol	1	63
Need to convert this code to a query by pokdbz I have this code and I need to convert this to a query. The reason it is a new field and the current records being entered will do this but I also need to... ( 1 2)	June 2nd, 2005 03:20 PM by pokdbz	12	196
Packing a number with zeros by Baby Face Lee Hi guys, A quick question (I hope). I've got a field which have numbers in them which I need to pack to four-digits with preceding zeros. To enable this I've...	June 2nd, 2005 03:43 PM by Lynn Trapp	3	79
Select Query By Month. by Terry I am currently using the following query to determine which invoices remain unpaid since the first of the year in our invoice processing database. Currently...	June 2nd, 2005 04:10 PM by Van T. Dinh	6	475
Query to filter all but two items by DDBeards I have a query that filters data based on a field Status. I want to return all but two items; "Completed" and "Archived". I know this should be simple but I...	June 2nd, 2005 04:15 PM by Van T. Dinh	2	83
Add months with last day by GrandMaMa I know how to use the DateAdd command on adding months. DateAdd("m", 45, ThisDate) However I need to insert the last day of the month. 6/2/05 + 45 = 3/3/09 ...	June 2nd, 2005 04:30 PM by Duane Hookom	1	84
Convert #Error to 0 by Eric Hi everyone, I am doing some calculations in a field that have some zeros and I get #error since I can not divide by zero (I know this too). Is there a way...	June 2nd, 2005 04:33 PM by JR	8	114
Parameter Query Criteria by rwitosky Is it possible to create a criteria based on a work week number for a field that is formatted as a standard date (mm/dd/yyyy). I would just like to enter a...	June 2nd, 2005 04:47 PM by fredg	1	233
Syntax Error in FROM clause by MrMike Hi. I have the query as shown below. When executed it produces the error "Syntax error (missing operator) in query expression tblSQFTByStation.OrderID =...	June 2nd, 2005 04:56 PM by MrMike	2	141
a macro sometimes does not run one of its make table query?? by needhelpwith_macro I have a form which autoexecutes every time a database is opened. that form has a button with which runs a macro onclick. In that macro there are a series of...	June 2nd, 2005 04:57 PM by Lynn Trapp	1	71
Driver update by lostnovice I keep getting this message when I try to put my pc on standby, "device driver 3'com etherlink xl 10/100 pci for complete pc management NIC (3c905c-tx)' needs...	June 2nd, 2005 05:08 PM by Rick B	1	89
displaying additional data that correlates to my query by margo1518 I have a query that gets the following information from my tables ProductName, Voltage, Current, Peak, TargetDifference (Peak and target are the same unit) I...	June 2nd, 2005 05:16 PM by David Lloyd	1	93
Updateting WO Number by Brent I have a query that is looking at the assigned date and if it is not null it goes to the WO# field and adds the next number to it using the Nz(DMax("",""),0)+1...	June 2nd, 2005 05:25 PM by Brent	2	62

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