Running & Setting Up Queries - Page 511

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 and currency by miles hi, i kind of urgently need help, i doing a database and there is a problem i encounter..... i have three field a name, date and currency - when i use...	March 20th, 2006 04:28 AM by Wolfgang Kais	4	99
Calculating the Difference between two times/ dates by Simon If I have two date fields with respective time fields, how do I need to calculate the time difference between two times that sometimes carry over to the next...	March 22nd, 2006 05:04 PM by Simon	4	209
make-table query by SP Hi I'm using Access 2003, and I have a make-table query. Every time I run the query, there are about 3 messages with various warnings (saying the table will...	March 22nd, 2006 11:37 PM by SP	4	73
converts secs to nn:ss by Theresa Hi, I have a field ('Time') in short time format, and another that is number of seconds (i.e 9 or 148 etc, 'Seconds'), in number format. I would like to...	March 22nd, 2006 05:43 PM by John Vinson	4	91
Matching results in query based on periodically updated field by [email protected] Hello, I'm building a query that shows the total sales value of our company's widgets over time. I have the following tables: 1. A table with the various...	March 23rd, 2006 02:58 AM by [email protected]	4	81
Seperating parts of data by Jez Hi, If I have a field with instructions in.. How can I query on a certain part of that field. example Delivery before 9am Delivery after 1pm Delivery before...	March 22nd, 2006 01:05 PM by Tom Ellison	4	103
Column Parameters by Jacqua5 I know how to set a parameter for enetering data from a single column. How do I do as follows: Vendor TX AR MN NY Pepsi Y ...	March 23rd, 2006 12:09 AM by Tom Ellison	4	294
The query-expression deletes some of the fields by shannieboat Hi, In the past I've had no problems with creating a huge expression to sum up several fields. All of a sudden, when I open up the query it has cut...	March 27th, 2006 12:07 AM by shannieboat	4	82
Export to Excel by microsoft Hi I have created a database which captures all trades performed by the Investment Team on a daily basis. All the necessary tables, forms, queries and...	March 26th, 2006 11:49 PM by microsoft	4	58
Query help by rblivewire I have to make a query that goes: If ( AND AND .........= Not NA,"Multilingual", English Only). My problem is that I have about 20 columns of different...	March 22nd, 2006 03:49 PM by rblivewire	4	305
Access Query Problem by AmyD I have say 3 columns 1st=Date, 2nd and 3rd=May and June. May and June columns have a list of budget figures. I have written a query where I want to be ably...	March 22nd, 2006 12:13 PM by Kernow Girl	4	76
Grouping Records by Household by In need of assistance Alrighty then. I have a table that has a mass of individual mailing addresses, and I want them to be grouped by household. For Instance: Transform...	March 17th, 2006 08:47 PM by In need of assistance	4	109
how to avoid slow count function by Nugimac I have recently purchased total access analyzer â€“ a great tool. When I ran it, I got a message about a slow Count function. I would like to know how to...	March 18th, 2006 06:43 PM by Brendan Reynolds	4	109
Query to add potential nos to list in Table by Wilie Loh How to add potential nos to list in table but append to column in another table? 2499 --- 2899 or 2199 or 2466 or 5499 3678 --- 3675 or...	March 19th, 2006 09:54 PM by Duane Hookom	4	74
Date question by confusedinc I am trying to figure out how I can produce the following: I need to show accounts that have (0)zero days left before they need to be paid. I have created the...	March 20th, 2006 12:27 AM by Tom Ellison	4	67
List Box Criteria by Ant I have an unbound list box with the multi Select properties set to ‘Extended’. One of the fields in the list box is a unique Number field . I would like to...	March 20th, 2006 09:58 PM by Ken Snell \(MVP\)	4	46
Nested IIFs by jab Im pretty good at Excel but am a new user of Access to which I moved when my requirements became more than Excel could cope with. Currently I am trying to...	March 22nd, 2006 10:20 AM by jab	4	104
delete query by geebee hi, I have the following: DELETE * FROM tbl_masterpop_main WHERE in (SELECT DISTINCT Tbl_archive., Tbl_archive.pasted, Tbl_archive.PopEnterDt FROM...	March 21st, 2006 05:25 PM by John Spencer	4	51
Max of Date with/without grouping? by JavyD Hello everyone, I need to know how to get the Latest date, which I take it would be the max, in a Purchase Order file, that includes the below. At the...	March 21st, 2006 05:05 PM by Michel Walsh	4	59
Want Duplicate Information by apollo8359 I ran a query on all accounts and selected unique values, which filtered out the duplicate accounts. Now I want to see the duplicates. Any ideas on what type...	March 27th, 2006 12:17 AM by Tom Ellison	4	73

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