Running & Setting Up Queries - Page 943

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
Simple non-VBA way to delete table contents before append? by G Lykos Greetings again! Is there a simple way using standard Access mechanisms to clear existing records out of a table before appending new ones to it with...	April 11th, 2007 05:46 AM by G Lykos	6	249
How to deal with variable fields to achieve constant output structure? by G Lykos Greetings! Have an interesting challenge. I'm using a crosstab query to count five categories with two states each - General structure is counts for...	April 11th, 2007 05:46 AM by G Lykos	2	91
Removing Spaces in a string by hdfixitup What Function or ??? can I use to remove blank spaces within a string? Example: FS 8406 PT 1 to read FS8406PT1. Anyone with any ideas. thanks in advacnce	April 11th, 2007 01:54 AM by hdfixitup	2	97
Date difference for single field by accesskastle Hi. I'd appreciate any help with this problem. I've read threads on this before, but couldn't get it right. I want to calculate the difference between...	April 11th, 2007 01:13 AM by Tom Ellison	3	109
Update Sum Query by Samantha I need to update a temp table (tblBOM) with a summed quantity from a query (WOShortagesWithSOSum). Here's what I have so far that is giving me error "not...	April 10th, 2007 11:19 PM by John W. Vinson	2	99
Counting total records found? by Dennis I need to count the total number of records that were found in a sub-query (Access 2002). How can I do that please? This isn't in VBA, but is in an actual...	April 10th, 2007 10:46 PM by Veritas	3	93
Pivot Chart with several series fields by karaeloko I have a form with a combo box to choose a flight number and then a command button to requery the subform that is based on a PivotChart query. How can I add...	April 10th, 2007 10:02 PM by karaeloko	0	90
sintax error in FROM clause. And then what??? by rocco Hello, I got trouble. I have a query that has always worked fine, and it still do!!. I need to make few changes to it but can't open it!!! When I try to...	April 10th, 2007 09:22 PM by Ofer Cohen	2	145
grouping by pammy I have a query on a database I imported from Excel, the datatbase shows all the users we have and what access they have on a particular module. In this query...	April 10th, 2007 06:23 PM by Marshall Barton	3	92
If null skip/ignore by GiBB Im a little stuck doing a query. In one of the tables the name of the user can be in any one of three fields, and i have been asked to create a query where a...	April 10th, 2007 06:07 PM by Michel Walsh	5	285
Make table query not returning value for expression by Joker via AccessMonster.com Hello, I am having a problem with a make table query expression that is relatively a simple calculation. The expression that is returning null is for...	April 10th, 2007 06:03 PM by John W. Vinson	3	105
Very simple update query running super slow! by Flipandboef I have two tables: Rugman and PDrive The table look like this: Rugman -- ID (Auto/key) / Number (text!) / location (text) / test (text) PDrive -- ID (Auto/key)...	April 10th, 2007 05:57 PM by John W. Vinson	4	96
Substring Search & Replace by Fredriksson via AccessMonster.com I only want to replace a certain character within a string. Will the Replace command do a substring search and replace? What happens if some of the...	April 10th, 2007 05:39 PM by Allen Browne	2	87
Prorate Amounts over 12 Periods by Kirk P. Starting with this set of data, Eff Date Annual Revenue 07/04/07 $56,600,000.00 Can I design a query that would display the annual revenue spread out...	April 10th, 2007 05:38 PM by Kirk P.	2	174
Most 3 recent dates in separate columns by Gwen Please assist. I need a count of patient visits in the most 3 recent dates for each clinic with the dates in separate columns. I attempted to use a crosstab...	April 10th, 2007 05:34 PM by Gwen	2	140
VBA for Print and delete command by Nick I want to delete data with the criteria of using "Year" and "Quarter" but before that happens. I would like a message box to appear asking "Do you want to...	April 10th, 2007 05:22 PM by Nick	0	86
Delete records that match criteria in another table by Frank Hi Folks, This should be very simple and I don't understand why it's giving me trouble. I'm trying to delete records from a tbl whose field matches a...	April 10th, 2007 04:50 PM by Frank	2	178
Working days calc error by Apples76 I am using the Calculate working days function provided by Ken Getz and i keep on getting data mismatch error when trying to run it. both of the scource...	April 10th, 2007 03:54 PM by Apples76	6	118
Append Query Date Criteria Problem. by Hunter57 I need some help with an append query. The date criteria is not working in the append query, but it works fine when I change it to a Select query. Also, I... ( 1 2)	April 10th, 2007 01:54 PM by Hunter57	13	183
Running Sum Query by Andy friends, Q.1: I have table "HMADetail" That has fields as Date Lot# SubLot# HMAPlacedToDay HMAPlacedToDate ....... (1) (2) (3) ...	April 10th, 2007 01:07 PM by Michel Walsh	7	102

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