Running & Setting Up Queries - Page 996

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
How to use the result from a function in a query? by Hallgeir I have a function that gives me the UserName with which the user is logged into the network. In other word the function returns the network login name. In my...	August 29th, 2004 08:12 PM by Hallgeir	2	509
Trim() function not working? by Will I have the expression: IIf(=Null Or Len(Trim())=Null,"This Manufacturer is not in the system"," ") in an Access2000 report. It's always worked (for over 2...	August 31st, 2004 07:39 PM by Will	2	340
setting "date" criteria by Jeff G When I set a criteria in a query "between and " to prompt for dates "a" and "b" and then type in "8/16/04" for "a" and "8/31/04" for "b" when prompted, I...	August 31st, 2004 09:30 PM by Jeff G	2	398
Comparison query by Su Cooper Hi, I'm new to queries and I'm trying to work out (without success) how to do the following. I have two tables: tbl1 (the key of which is employeeID) tbl2...	August 31st, 2004 10:33 PM by Gerald Stanley	2	126
Removing specific characters from a text string by Mr. Perry Hello, Is there any way to remove specific characters from a text string using a query? I don't want to use the find and replace feature because the process...	September 1st, 2004 02:52 PM by	2	347
Running averages challenge.. by Robert Cs. I have a form based on a simple table, where data gets inputted on a real time basis, with the following fields: time and color value. Example: Time Color...	September 1st, 2004 10:38 PM by Tonín	2	126
Update Query, Stumped by Chris Howdy. Here's my scenario. Fields in table: SecYrsExp SecPts SecPts is based on SecYrsExp. SecPts has a max of 5 points. You receive .5 SecPts per year of...	September 2nd, 2004 12:29 AM by John Spencer (MVP)	2	103
DateAdd using "w" by RB I am trying to create a query that adds two week days to a date. I have tried to use DateAdd("w", 2, ) in my query, but this simply adds two calendar days. Is...	September 1st, 2004 08:10 PM by RB	2	118
How does my append query replace the repeating cells in Access? by Theo I have a table that I append with info on a daily basis. Sometimes, the company that provides me with this info is sending me updated info for previous periods...	September 2nd, 2004 12:27 PM by	2	297
How do I limit the number of records in a query. by rnprice If I have a query that is combining information from two or more tables, one of which has a date field, and I want to limit the query to the most current 20...	August 31st, 2004 04:27 PM by rnprice	2	385
Autonumber in a query by Fabio How can I include an autonumber in a field of a query ? Or hoe can I select just the 5 first records of my query?	August 31st, 2004 05:29 PM by Fabio	2	158
Concatenation by jz I have a table that was imported from Excel that contained fields Note and Comments. I want to concatenante the 2 together separated by a comma. As you can...	August 28th, 2004 12:05 AM by Michael Keating	2	139
Big brain problem! by Jeff Klein I have a table with check boxes for every day of the week. My query shows all dates (between MonthStartDate and MonthEndDate) if its respective checkbox is...	August 30th, 2004 08:33 PM by Jeff	2	146
Export To Excel in one shot by Spammastergrand Is there a command to export a table to excel in one shot with VBA? I know how to do it with DAO, running through an entire recordset populating cells based on...	August 29th, 2004 08:04 PM by Spammastergrand	2	210
Date Value: Week Begin by Bernie I'd like to use an expression to identify the Week Beginning date (using Monday) of a given entered date value. Users can enter any day of the week, but I...	August 30th, 2004 12:58 AM by Bernie	2	303
The Query Grid Disappeared by Cyndi The query grid will not display - only the field list. How can I fix? Thanks.	August 31st, 2004 02:30 PM by Joan Wild	2	128
first of the month date question by ave I have a table that contains the date/time for each record How would i write a query so i could show the records for the first day of each month Likewise to...	August 30th, 2004 10:24 PM by John Spencer (MVP)	2	139
Action queries changing when reopened in design view by Kendra Hello, I am rephrasing/simplifying a question I posted earlier so that somebody might know what's going wrong. I am using two action queries in a form. A...	August 31st, 2004 12:34 AM by Ted Allen	2	991
SQL view of messed up action queries by Kendra I really appreciate your kindness in helping me out. Here is the SQL for the action queries (if it clarifies things): SQL of append query...	August 31st, 2004 09:53 PM by John Spencer (MVP)	2	1,964
How to sum a text column containing numbers? by Terry I have access 2003 running against a SQL database and I created a view that returns the last few characters from a text column (with an AS statement) Now I...	September 2nd, 2004 01:00 AM by John Spencer (MVP)	2	123

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