Running & Setting Up Queries - Page 413

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
date problem by Jean-Paul Hi In following SQL i have a date-problem: sql = "SELECT .Datum_bezoek, .Naam, .bezoeken, .Datum_bezoek FROM WHERE .Datum_bezoek Date And .Bezoeken...	October 14th, 2008 08:07 PM by Al Campagna[_2_]	1	74
Emailing by Markus Hallo I hope some one can help me i have a table with the users Name and email address but i have a field with CC which will have email address with the...	October 14th, 2008 07:52 PM by Markus	2	83
connect to odbc by Graham Feeley Hi guys I have a python script to run. it extract a zip file and adds data to a mdb database I get this error message in a prompt window any ideas...	October 14th, 2008 07:33 PM by Graham Feeley	1	139
How do I use Records returned from a query to run another query? by BABs I have a query that returns the names of sites for a certain job number and exports the data to excel. Now I want to take each of the sites and run a query...	October 14th, 2008 07:31 PM by BABs	2	45
Crosstab with SQL Backend Problem by [email protected] I'm very new to SQL, and having problems transfering our old Access 2003 Database to a new Access 2007 Frontend- SQL server Backend. I have figured over the...	October 14th, 2008 07:13 PM by [email protected]	9	102
Same Field, Multiple Criteria by Sara I might be going about doing this the wrong way, but this is what I'm trying to do: I have a query that takes the date a position was vacated and shows me...	October 14th, 2008 06:27 PM by Marshall Barton	7	110
Creating a Query that Deletes Duplicates by Date by [email protected] Alright, I am trying to create a query that will sort by First Name, Last Name, Perm Address, and date updated that will find duplicates between FNAME, LNAME,...	October 14th, 2008 05:21 PM by [email protected]	8	132
Query from multiple tables by PA Using Access 2007, the db has 11 tables on job assignments. SrDirector and Director(primary key) in one table Director and Mgr (primary key) in another Mgr...	October 14th, 2008 04:38 PM by NetworkTrade	1	57
Relationships Between Tables by [email protected] I have two tables. One lists 7 different managers which are servers that have been assigned numbers for simplicity and the other table, which we shall call...	October 14th, 2008 04:18 PM by Keith Wilby	1	169
The difference between 117.50 and 117.5 !! by No Name Hi This one is driving me mad. I've got a query looking at a table which has two values 100.00 and 17.50 (for example). The query adds the two together and...	October 14th, 2008 04:05 PM by Allen Browne	6	157
Query - Resolved First Time (Make Table) by [email protected] Hi, Hope you can help. I need a query to do the following: Query all records from P2P-Request where Closed-Date is Not Null (this part I can do). With this...	October 14th, 2008 03:54 PM by KARL DEWEY	5	84
Date/Time Return all in Specified Date by Snickers I have a table containing date/tame info as mm/dd/yyyy hh:nn:ss AMPM, I want to put together a parameter query that prompts you for a date and returns all...	October 14th, 2008 03:48 PM by Snickers	2	64
Using the Table Analyzer by [email protected] I am reading a really thick book to help me get into Access and learn everything but one thing I don't understand is that when I use the table analyzer, it...	October 14th, 2008 03:38 PM by [email protected]	2	65
Computed Column from Date Field by Rita Brasher Microsoft Office Professional 2000 (SP3) Windows XP Professional I have a table that accumulates data for each day of the year (MM/DD/YY). I need to...	October 14th, 2008 03:28 PM by RonaldoOneNil	1	57
how do i connect microsoft access to c language by mohit please do tell me how do i coonect excel or access to c language i m in need please do respond on my mail	October 14th, 2008 03:26 PM by Michel Walsh	3	82
Help with a Union Query, I think... by MeSteve I have a union query that is doing almost what I need. SELECT tbl_Projects., tblProjectMilestones. FROM tbl_Projects INNER JOIN tblProjectMilestones ON...	October 14th, 2008 02:59 PM by MeSteve	7	109
Running an SQL Statement with a GROUP BY Clause by [email protected] Running an SQL Statement in Access I'm trying to run the following query in access: SELECT Average(!-!) AS Duration, .Manager FROM ; GROUP BY .Manager It is...	October 14th, 2008 02:17 PM by John Spencer	5	104
Query help needed by Savage I am current making a search engine using infopath and access 2003. I am trying to make the search engine able to search on part words because i want to be...	October 14th, 2008 08:29 AM by Savage	0	79
Return "yes" or "no" if value in one field matches any value in ot by datadyl I have two tables: tbl_shipments and tbl_bldr_assigned_counties I am trying to create a query that returns a "Yes" or "No" depending on whether a particular...	October 14th, 2008 05:10 AM by Marshall Barton	7	76
Round to 100 by Boon Hi, I would like to round a number to hundreadth like this 100 - 100 101 - 200 150 - 200 199 - 200 200 - 200 What is the best way to qrite a query to do...	October 14th, 2008 04:00 AM by Allen Browne	3	64

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