Running & Setting Up Queries - Page 986

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
iif statement with data parameter not working by PBISMaryland I am trying to run a query on a table (called SETS) that includes a date field (short date). If the date equals a specific date I want to return "Yes", if...	March 5th, 2007 05:52 PM by PBISMaryland	2	78
Need results without prompts by Frustrated in AL I have a table that lists appeals based on responsibility (5 different options). I am trying to get the query to list number of appeals, percentage of...	March 5th, 2007 05:09 PM by Frustrated in AL	2	74
Nested IIF statement by Pete Provencher I have a field that contains either 1, 2, or three characters. I want to add leading 0s to the number to make all numbers three characters long. I use this...	March 5th, 2007 04:50 PM by Frustrated in AL	3	69
memo field - manipulating data by needInfo25 I have a memo field from which I would like to extract a date. Sample text is: sent on 02032007 from US I want to create a parameter query, the date entered...	March 5th, 2007 04:27 PM by KARL DEWEY	7	100
Get SQL authentication Name from SQL Server using access front End by [email protected] Hi all I am trying to retrieve the SQL username for the currently logged on user from my backend SQL Database so i can populate a form. I have the following...	March 5th, 2007 03:29 PM by [email protected]	0	83
Can't Run Delete Query to Get Rid of Dupes by John D I have about 2000 Duplicate records in a Table with 100,000 records. I read the Microsoft online article about how to "Find, elimiate ... duplicate records":...	March 5th, 2007 02:44 PM by Gary Walter	4	195
Select Integers only by Cathy I have a field that has integer and non-integer data. For this one query, I need to select out only the integer values. How do I make a query ingore any...	March 5th, 2007 01:08 PM by Jamie Collins	4	98
no access by foxyman i cannot get past the logon screen on my compaq presserio when i type in my password it comes up did you forget your password have been using this password...	March 5th, 2007 01:08 PM by Michel Walsh	1	74
Queries and Multi-Column Reports by Devlin This question was previously posted in the reports section. However, we thought we might get better response here in queries. We are seeking a best way to...	March 5th, 2007 12:20 PM by Michel Walsh	1	108
Not enough space on temporary disk. by Michel Walsh With Jet? there is still a limit of 2Gig for the database, and that limits is also implied for the intermediate temporary database it creates to solve a...	March 5th, 2007 11:53 AM by Michel Walsh	0	82
Problem with different language versions of Access 2002/2003 by NRY Hi! I have a problem with a query in the German and Dutch version of Access 2002/2003. In the German version the query with criteria in queries, referring to...	March 5th, 2007 11:06 AM by NRY	0	78
Form and Query by Jason I have what I hope will be a simple question. I have a form that allows me to run a report based upon one of two criteria. The two fields are these and...	March 5th, 2007 10:11 AM by Wei Lu [MSFT]	3	174
PARAMETER QUERY FOR IS NULL OR IS NOT NULL by Sammie How can I write a parameter that asks the user to specify if a field is null or is not null? field: commission (currency) the criteria is null works just...	March 5th, 2007 08:19 AM by Jamie Collins	3	87
null value or zero string by [email protected] On Mar 2, 3:38 pm, goranimo1 wrote: Hi, I have a problem with creating a control that could lookup and indetify a ...	March 5th, 2007 07:11 AM by [email protected]	0	78
Date Query by Chris Simpson I am having some problems getting a Date lookup to work properly. I am using code from http://allenbrowne.com/casu-08.html method #2. It all works fine until...	March 5th, 2007 03:59 AM by Chris Simpson	0	80
Incorrect request for parameter by Sherry S. I created a form (Form A) for running queries. The form requests a start date and end date and one can then select from a list of queries. The form works...	March 5th, 2007 03:23 AM by Sherry S.	5	81
Query!!! loosing my Mind!!! by Lime This is really making me nuts... I have a small form with just one combo box named "HFC" in it. I have the combo box listing choices from the table named...	March 4th, 2007 11:17 PM by Lime	1	74
Problem running query in code by John Hi I am using the below code to run a sql on an underlying access table; insStr = "INSERT INTO ( Action, , , Request_Date ) " & _ "VALUES (""Modify...	March 4th, 2007 06:03 PM by RobinS	8	128
Help with Query by Alan I have the below query and I get the below error message. For the life of me I can not figure it out. Any help would be greatly appreicated. Query: SELECT...	March 4th, 2007 06:01 PM by Alan	2	80
WORLDS LARGEST COMMUNITY !! BE THE PART OF IT ! by M.K. WORLDS LARGEST COMMUNITY !! BE THE PART OF IT ! http://www.agloco.com/r/BBCC5087	March 4th, 2007 04:53 PM by M.K.	0	91

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