Running & Setting Up Queries - Page 947

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
Pass Thru Times out by Ross Criteria Section: WHERE (((RESC.func_biz_num)='41322') AND ((SCH.TIME_FY_DATE) = '1/7/2007' AND (SCH.TIME_FY_DATE) = '1/13/2007')) I have a passthru query...	April 6th, 2007 06:06 PM by Ross	2	140
Dates that are not the last day of the month by Makeover Hi: I need help with a query. I have a date field in my db and I need to identify dates that are not the last day of the month. Thanks	April 6th, 2007 05:29 PM by John W. Vinson	3	113
Alternative method for crosstab qury by Alp Bekisoglu Hi Experts, Here's the environment: A2K, FE on each pc and BE on one PC on the network I have a table to record forms returned from clients with fields...	April 6th, 2007 05:28 PM by KARL DEWEY	1	90
duplicates by Pammy I have a table with user names and security modules. There are 1700 users and 65 security modules that will have a Y or N depending on if they have that...	April 6th, 2007 05:25 PM by John W. Vinson	6	234
IMPORT EXCEL AND QUERY by Pammy This is what I imported from excel into access: user name, module, edit, query, add, delete, review... (65 columns in all with Y&N ) pmayes....... bkin...	April 6th, 2007 03:42 PM by Andy Hull	2	80
Import data directly from Word forms to Access 2003 tables by CZ I'm trying to automatically transfer a word doc that has shaded fields to a database table. I found a proceedure from Access 2000 but is doesn't work with...	April 6th, 2007 03:28 PM by CZ	0	81
Need report to show totals and percentages by CEV I am not sure how to get the numbers I am looking for. I have a query that shows all the records I need totals for. The numbers I need on a report are the... ( 1 2)	April 6th, 2007 03:18 PM by CEV	11	172
Query design question? by JimP[_2_] Query1 retrieves data for 2,000 records from a series of linked tables that have about 100,000 recordset Query2 retrieves data for 5,000 records from another...	April 6th, 2007 01:08 PM by JimP[_2_]	2	98
Two instances of the same table by BruceM I have a database for managing a review process that has several steps. The data are stored in the table tblCAR. Each step has an employee assigned to it. ...	April 6th, 2007 12:27 PM by BruceM	2	88
how can i create a parameters entry in query with list/combo box? by Nelson The Missing Lead I am trying to create a query with parameter entry c/w list/combo box for the user to chose? But i can't. Pls help. Eg. { I hope that a list/combo box will...	April 6th, 2007 10:16 AM by Ofer Cohen	1	85
Subquery Problem by PPCO This is my first attempt at writing a subquery...I am trying to return the top 3 records for each itemname. Here is what I have written: SELECT...	April 6th, 2007 09:05 AM by Allen Browne	1	89
upper and lower limit function. "BETWEEN.....AND....." by Tamer My Table has Few Fields two of them hold dates. the two date fileds are "FROM" and the other is "TO". I want to be able to run a query that will bring me...	April 6th, 2007 08:56 AM by Allen Browne	2	86
Passing a variable into a SQL statement using Like "" & varCurrentForm& "")); by CES All, I know the issue is in the number of quotation marks that surround the variable however with every attempt to solve the problem I continue to get and...	April 6th, 2007 03:04 AM by Marshall Barton	6	80
Finding all Authors in a Query by MilGar I have a Query that includes Authors,Rating Books and other fields. The criteria control is in Rating Books and is (is Null). This criteria will list all the...	April 6th, 2007 02:12 AM by Smartin	2	110
Select Statement in query to append to a table by Newbie Hello, I have a table with the following Master Stock Code Header ID and I want to append this information to a table, kind of ike a cross tab query but I...	April 5th, 2007 10:34 PM by Newbie	2	80
Open Table With Macro by T1thinker I have a DB that creates new tables weekly for tracking changes to another system. When I launch the DB I would like to have a button to open the most recent...	April 5th, 2007 09:43 PM by T1thinker	4	126
SUBQUERY WOES by BillA Hello: I have a Query that is used to support a read-only continuous form. I am trying to include a Comments section in this form where only the most recent...	April 5th, 2007 09:06 PM by Michel Walsh	9	98
Memo Field is truncated by Bob My queries are truncating memo field after 255 characters. I want the entire memo field displayed -- Bob	April 5th, 2007 08:30 PM by David W. Fenton	5	108
Union Query by LindaC I have one table called tblArchive where I have a department and a location A1a, A1b, A1c, etc. I then have a table tbllocation where I have all the...	April 5th, 2007 08:18 PM by LindaC	0	78
DateAdd Function by TeeSee Attempting to place this in a query .... DueDate: DateAdd("y",3, ) returns an error message "undefined function 'DateAdd' in expression" Also placing...	April 5th, 2007 07:49 PM by fredg	4	134

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