Running & Setting Up Queries - Page 1451

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
Merge two tables together with same fields. by [email protected] i have import a csv file in a table in Ms Access. However i have a table that created for projects. I now have to merge the data between two table. For example...	February 27th, 2006 03:26 PM by Rick B	3	102
Datediff function by Amazing Hi, I am trying to write a query that gives the number of working days between two dates so I can calculate transit time for some shipping based on working...	February 27th, 2006 02:30 PM by BruceM	2	171
How do I run a query and exempt certain numerical values? by ~spookyg~ I want to create a query that lists values. I have 4 values I don't want to include in this particular query. ie: 10, 20, 30, 40, 50, 60, 70..... etc.. I...	February 27th, 2006 04:32 AM by Duane Hookom	1	126
Counting the days sequentially in a month on a date field. by BFish via AccessMonster.com I'm stuck and hopefully someone will give some needed help. I have a totals query from a invoice table that totals the sale and the cost of each record by day...	February 27th, 2006 04:14 AM by BFish via AccessMonster.com	2	143
output to a formated excel sheet by SF Hi, I have a simple query contain several column as below: Province Project type Number AAAAA Received 3 AAAAA Approved ...	February 27th, 2006 03:34 AM by SF	2	164
Extract Field Values from Multiple records for a single criteria by Greg K. Not quite sure how to explain this. I have orders in a table that can get shipped from a multitude of warehouses (13 potential to be exact) spanning many...	February 27th, 2006 02:59 AM by tina	3	174
if then by sierralightfoot ACCESS 2003 I need to put three or more "if, then" in one expression: If "city"="wa" then "Watsonville" If city ="HO" then "hollister" etc.... Also sometimes...	February 27th, 2006 01:36 AM by Duane Hookom	3	96
MonthNo: DatePart text not number? by triplespiral I am using the current expression MonthNo: DatePart("m",) While I am receiving the correct numerical results, I would like to display the results in the...	February 27th, 2006 01:09 AM by triplespiral	2	109
How do you subtract two dates in an expression? by Paul Ponzelli I'm trying to calculate the number of days that have elapsed between two dates: 1. a date field named Target, and 2. today's date. I've tried using...	February 26th, 2006 10:36 PM by strive4peace	3	112
Queries with no records by Michalis J. I have a report that is giving totals from three independent tables. A query with three independent tables is the source of this report. The problem is that if...	February 26th, 2006 10:33 PM by strive4peace	7	242
how do I extract the date between two date fields in Access by Struan I have made a reservations database in ms access. It has two fields which are and and for various reasons I need to extract, using a query, the dates...	February 26th, 2006 10:26 PM by Rob Oldfield	4	125
Generating passwords automatically by Amy Blankenship I've created a Password function that creates a random password Function Password(passlength) As String Dim i As Integer, tmp As String, tmpChar As String,...	February 26th, 2006 10:23 PM by strive4peace	4	124
Eliminate duplicate records by Stan Brown Sun, 26 Feb 2006 21:23:34 GMT from Dr. Brad : I use Windows XP Pro and Access XP Pro (2003). I have a table with some duplicate...	February 26th, 2006 09:57 PM by Dr. Brad	1	111
Taking Last Value from range before query starts. by Mike Abbott Good Morning from the UK. I am a newcomer to access sorry if this is a simplistic question. I guess this is part a Query question part a report question,...	February 26th, 2006 08:25 PM by Tom Ellison	1	99
duplicate data by Tracy Lamphier My tables in my query are all linked by an account number. In all of the tables there is only data for each account number once, except in my Alert table. If...	February 26th, 2006 07:58 PM by Tom Ellison	1	90
labeling a value by Tracy Lamphier If the data in my query is a numerical value how can I change it to show what the value represents. For example, if 01 means Customer, how can I get my report...	February 26th, 2006 07:40 PM by fredg	1	88
Storing and Querying MS Word Docs in a mdb by paul69 I have a number of reports on stores in MS Word. Can I store these reports in mdb and query them? Can you do that through a web site. I use FrontPage 2003.	February 26th, 2006 07:06 PM by John Nurick	3	125
NUMBERING GROUP OF RECORDS IN QUERY by ClaudioGuru My problem is to be able to number the records in a query according to the group they pertain to. Example GROUP MEMBER NUMBER A ...	February 26th, 2006 06:27 PM by Steve	6	125
matching days by flymeoutofhere i have an access database with two tables. one is details of customers and the other is installers. in both tables i have the fields "available...	February 26th, 2006 04:44 PM by Ken Sheridan	4	152
Combo box show values based on value in Option group? by Pat Dools Hello, I would like to limit what is shown in the drop-down list of a combo box based on the value that is checked off in an Option group. Right now, I have...	February 26th, 2006 04:13 PM by Pat Dools	3	119

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