A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Running & Setting Up Queries Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Computing Median by mcl
I need to compute the median not an average. Using help in Access 2000 it says there is a worksheet function "median". No there is not. It says undefined...
September 13th, 2005 07:08 PM
by MGFoster Go to last post
3 92
returning all records by Jason
Thank you to everyone out there who has tried to help me over the past few days. I am having a hard time getting my mind around this problem. The SQL at the...
September 13th, 2005 07:13 PM
by Jason via AccessMonster.com Go to last post
6 139
Create records using defaults by Alex
Each month I create a new table using the SQL below, where the records are just copied from the GoalsMain table, except that the NewDate changes each month. ...
September 13th, 2005 07:55 PM
by Lynn Trapp Go to last post
3 96
Expr1002 by aak
I have a query something like this. I want to order it by total. Everything else works OK only ordering doesn't work. It displays me window - 'Enter Parameter...
September 13th, 2005 09:20 PM
by Marshall Barton Go to last post
1 117
HELP With DATA and Make Table Query by Doc
Hi, SQL Srv2000 and Production Database - what I want to do is open the live database, keep the data and save it to be manipulated in a "non-connected" manner...
September 13th, 2005 09:27 PM
by Doc Go to last post
2 90
Query Puzzle by Bradley
Hi I have 4 separate tables of which all have fields "Surname", "Forename" and "DOB", plus the data column. Tbl_0 = S | F | DOB (this is all 5 users) Tbl_1 =...
September 13th, 2005 09:48 PM
by Marshall Barton Go to last post
2 114
can you specifie criteria for a parameter query in an Auto Num by Ofer
Try this WHERE .= Or WHERE .=cdbl() Or WHERE . Like cdbl() -- I hope that helped Good luck
September 13th, 2005 10:28 PM
by Lea Go to last post
1 182
Criteria in Query by Gibson
I have a query (main query) whose data comes from one table and one query (data query). In the main query I have criteria such as Forms!frm1!Field1 so it only...
September 13th, 2005 10:31 PM
by KARL DEWEY Go to last post
1 88
how to feed result from P_T query to combo box? by homer
I have this line of code working. Form2 Form_load currentdb.QueryDefs("qryPassthrough").SQL = "Exec INV_getParentItemBYID " & Me.OpenArgs I also have a combo...
September 13th, 2005 10:34 PM
by Ofer Go to last post
3 84
Modify table based on ID by ChuckW
Hi, I have a table that I import from another access database. It has field in it that include Name, ID, Weekly Target etc. That is a person in the...
September 13th, 2005 10:37 PM
by KARL DEWEY Go to last post
1 76
Conditional Query by Hafeez Esmail
The first thing that comes to my mind is this: Create 4 separate queries (one for each category) Create a union query that combines the four queries created...
September 13th, 2005 10:38 PM
by Hafeez Esmail Go to last post
0 60
make table query error by TTL
Hi, I'm having problems running a make table query from an linked table in access 2003 (via ODBC connection) I can view the data as a query but when I try to...
September 13th, 2005 10:42 PM
by KARL DEWEY Go to last post
1 72
criteria, checkboxes, and/or by bicyclops
I have a matrix of checkboxes on a continuous form. I would also like to use checkboxes in the header to specify parameter criteria in the form's query. The...
September 13th, 2005 10:47 PM
by bicyclops Go to last post
4 138
Date/Time by Jay
Table has a field named TIME. Datatype:Date/Time Format: 09/12/2005 6:24:45 in 24 hour format Want to have a field, named TIMESUB that substracts TIME by 7...
September 14th, 2005 04:21 AM
by Van T. Dinh Go to last post
2 85
can you specifie criteria for a parameter query in an Auto Number. by Lea
I have created a parameter query, and specified criteria in an Auto Number field (which is also the primary key) and when i run the query i get no results. ...
September 14th, 2005 04:31 AM
by Van T. Dinh Go to last post
3 94
criteria and dates by kryszystof via AccessMonster.com
Hello to all, -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200509/1
September 14th, 2005 04:37 AM
by Van T. Dinh Go to last post
7 121
Query performance by TomHinkle
Can Anybody tell me what performs better in a where clause looking for several text strings: Method 1: Like "Example_A" or like "Example_B" Method 2: In...
September 14th, 2005 04:51 AM
by Van T. Dinh Go to last post
2 75
a Query that collected parameters from a form just stopped working by WebDude
My parameter query was working perfectly.. it collected values from a row of text boxes on a form...but now its acting as if it doesnt see the form/parameters ...
September 14th, 2005 06:37 AM
by WebDude Go to last post
3 80
Sort Order of Queries by Samaritans
I have a query where I enter the auto numbers allocated by access in a table to produce a report of interview questions. I want the query to be in the order I...
September 14th, 2005 07:58 AM
by Allen Browne Go to last post
1 122
vba Query for column name by ismail
Please help me in this issue....here is my code..and tabel struct. column name datatype dateofS date stid ...
September 14th, 2005 08:04 AM
by ismail Go to last post
2 71
Post New Thread


Display Options
Showing threads 10001 to 10020 of 43289
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread 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 08:24 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 OfficeFrustration.
The comments are property of their posters.