Running & Setting Up Queries - Page 88

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.

		Home » OfficeFrustration forum » Microsoft Access
Running & Setting Up Queries

Home

Page 88 of 2165

Threads in Forum : Running & Setting Up Queries

Forum Tools

Search this Forum

Thread / Thread Starter	Last Post	Replies	Views
Totals Won't Count Nulls by jgraves My Access Table has a columns containing various values, including null. See below. Error Code ------------ A A B C (Null)	January 7th, 2010 06:17 PM by vanderghast	1	148
iif function syntax problem by angie i have the following expression in the criteria row of my query and it returns no records. can you help me with the syntax? IIf(!! Is Null,, Like "*" & !!...	January 7th, 2010 04:44 PM by Duane Hookom	5	176
Crosstab query question by CR I have a question about using crosstab query of course maybe there is another way and any help would be great appreciated. The problem is that the crosstab...	January 7th, 2010 04:31 PM by Duane Hookom	2	134
Group - Combine Consecutive Dates into a Date Range by MSJ I am attempting to combine all records within a table into a date range. John Doe \| 1/1/2010 John Doe \| 1/2/2010 John Doe \| 1/3/2010 John Doe \| 1/10/2010 John...	January 7th, 2010 03:00 PM by vanderghast	4	98
How to link Crosstab Query to other query problem... by Phil Smith I have a fairly complex query. Based around an ITEM_ID, I link various tables and queries, to get various counts totals, status, etc. One of the queries,...	January 7th, 2010 02:02 PM by John Spencer	7	201
Link multiple excel files at one time by JE I have about 60 excel files that I want to link in an Access database. Other than manually link each file individually, is it possible to link all at one...	January 7th, 2010 01:11 PM by JE	5	119
Trying to converting text field into numeric in a query by EA I have a query that is querying a text field from a table but the text values are numbers. Is there any way I can setup my query so that they query will... ( 1 2)	January 6th, 2010 11:55 PM by Phil Smith	14	248
Date query from datasheet in subform by Gamefewel I have a database of diabetic patients. I have a form that has all the patient info, like name, address, etc. I think have a subform that is a datasheet...	January 6th, 2010 11:02 PM by KARL DEWEY	1	126
One prompt for Four Queries by Wendelin I have four queries that are used as subreports in a summary report. All four queries use the same prompt (for the same field): How do I get only one...	January 6th, 2010 09:15 PM by SteveD	3	187
Please help. Question about querying a subform by Gamefewel I asked this yesterday and see all kinds of questions around me being answered and suppose i just did not word this correctly. I have a table of lab results....	January 6th, 2010 08:38 PM by Bob Barrows	4	144
Query 3 years by woods1119 I am trying to query from a query to find how many people have a duration of 3yrs. Query#1 (qrySeen2008) has: ingPtID LastOfdtmVisitDate I need to find...	January 6th, 2010 08:02 PM by John Spencer	1	99
query a table and subform by Icy Help, I have 3 tables 1. Printer table: printerID, ModelID, SerialNum, MACAdd 2. Toner table: TonerID, ModelID, PartName 3. Invoice table: InvoiceID, Date,...	January 6th, 2010 06:34 PM by Icy	0	85
Query for Single Field Value Where Another Field is at it's Max by Steve I have a table called tblCompletedMessages which gets updated information constantly from my department. A new row with the latest information is added every...	January 6th, 2010 05:26 PM by Steve	2	162
Expression builder in a select query by Krish I want to determine the qualifying % of commission based on Margin $ as follows 74.99 0.00% 75 and 149.99 8% 150 and 249.99 10% 25 and 349.99 ...	January 6th, 2010 03:09 PM by Duane Hookom	2	106
Parameter Query Lookup by Denise When a prompt asks for the "Company Name", I want to be able to select from a list rather than type in the name. Any suggestions? What do I put in the...	January 6th, 2010 02:31 PM by John Spencer	2	190
formula by Revned Hi, i have a select query with the following SQL SELECT tblOrder.CustomerID, & " " & AS Name, tblCustomer.SchedDelivery, tblOrder.OrderQty,...	January 6th, 2010 06:38 AM by Revned	6	137
report format by subs ocity ozip dcity dzip consignee a b c d clo e f c d clo l k c d clo t ...	January 6th, 2010 06:18 AM by Duane Hookom	1	147
Max plus additional field by Lorna_Jane[_2_] Hello, I've got 3 tables in a many to many relationship: Table 1: Catchments (AllCSL) Table 2: Regions (ProvincialEcoDistrictAttributes) Table 3: Lookup table...	January 6th, 2010 05:52 AM by Allen Browne	1	140
Group By, Max, many to many by Lorna_Jane[_2_] I tried posting this before, but it hasn't shown up, sorry if this ends up being a duplicate. I have the following tables and fields: Catchments...	January 6th, 2010 05:51 AM by Allen Browne	1	183
Using Table to Select Records from Larger Table with Join by Bev I am attempting to select records from a very large database by using a table with member ids joined to the larger tables with the same field. The Select...	January 6th, 2010 12:07 AM by KARL DEWEY	2	123

Page 88 of 2165

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

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is Off HTML code is Off

Forum Jump

All times are GMT +1. The time now is 12:07 AM.