Running & Setting Up Queries - Page 2002

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
residential info by BVG HOA I have a residential database for a Homeownerâ€™s Association and Iâ€™m rather new at this Access thing. I have created a table with lists of unit...	November 5th, 2004 04:31 PM by BVG HOA	0	104
User choosing sort/group order at query runtime by Allen Browne The simplest way to do this is just to set the OrderBy property of your form to the name of a field. Remember to set OrderByOn as well. This kind of...	November 5th, 2004 04:16 PM by rgrantz	2	327
Limitation of 255 fields by SANJAY SHAH \(MICROBRAIN Computers Pvt. Ltd.\) Dear Sir, In Access 2000, it is having limitation of 255 fields in Table & in Recordset. But In database like Clipper 5 it was having facility to... ( 1 2)	November 5th, 2004 02:46 PM by Peter R. Fletcher	12	289
Search Engine by nir020 Please Help Can anyone let me know how to create an access query which display records from a table which contain the text specified by the user in one of...	November 5th, 2004 02:10 PM by JL	1	99
using # in a field name in an access query by omegagmike How do I use the # sign as a field name in a select query, ex "Library #: column"?	November 5th, 2004 02:10 PM by hermie	6	221
Could not delete from specified tables by Ed I want to delete all records that match the where criteria, but it does not work??? What am I doing wrong? DELETE DISTINCTROW tblSignals.*,...	November 5th, 2004 01:39 PM by Ed	4	233
Counting events in a query by Tom Tripicchio I have dates for each time a patient was seen. Is there a way to write a query that will give me the first 2 dates of each patient? Examples Patient 1) 9/1,...	November 5th, 2004 01:37 PM by Duane Hookom	4	151
Word mail merge can't 'see' Access queries with prompts by slope90 How do I get Word mail merge to 'see' MS access queries which prompt for data.	November 5th, 2004 09:51 AM by Van T. Dinh	1	398
validation in pass through query by dimwit Hi guyz! Can anyone help me how to pass validation in a pass-through query in MS Access. I want the between date to com from my ACCESS forms. how can i change... ( 1 2)	November 5th, 2004 05:46 AM by Duane Hookom	11	551
Help please by BVG HOA I am new at this access thing and I don't know if I set this up right, but I can't figure out the next step. I have a residential database for a homeowner's...	November 5th, 2004 04:46 AM by SteveS	1	90
duplicate record number problem by Dale Peart I am aware of how to create a table using SELECT DISTINCT to find record duplicates but don't know how to just select the duplicate records. The specific...	November 5th, 2004 03:18 AM by Allen Browne	1	143
how do you work sales totals seperately per year by Salbel I have an assignment that requires me to work out the number of products sold per year per company. but when i attempt to do so i get the same total for each...	November 5th, 2004 02:42 AM by PC Datasheet	3	166
CASE SENSITIVE? by PattyD I have a need to perform a query where I can find lower case text. I have looked at the Help menu in Access and found some information, but I can not get the...	November 5th, 2004 01:53 AM by John Vinson	4	162
Can't Acess filter combo box rowsource by field variable? by Brian Goodheim Trying to use a combo box lookup field in a primary table to select contact personnel in a secondary table. The lookup field is supposed to return...	November 5th, 2004 01:49 AM by John Vinson	4	177
using multiple conditions in a where clause by talktobatchu hello I'm using a query in MS Access 2003 in which I need to find out the sum of "number of cases" basing upon the WHERE clause. The query looks something...	November 5th, 2004 01:47 AM by Duane Hookom	3	120
RANKING by gambler I have a list of numbers( that come from a formula--Eg. FR1 + FR2) in one of my query fields. I would like to take these numbers and give them a ranking. The... ( 1 2 3)	November 4th, 2004 11:53 PM by gambler	22	1,112
How do I do a calculated field in access 2003 then update it to a. by MattH I am trying to do a billing reconciliation database and Im trying to pick out data. For example Totaling the dollar amount in a Purchase order then moving that...	November 4th, 2004 10:35 PM by Rick B	1	235
remove portion of data by harvey I use access 2000. In field entitled city, I have the following data examples: Brooklyn ORIG. MTG & AMT: East Rockaway N. Bellmore ORIG. MTG & AMT: Using an...	November 4th, 2004 09:49 PM by Brian Camire	1	297
crosstab query problem by Michael S. Montoya I have a crosstab query that works perfectly. If I have a field named Gender and put a value in the Where of "M", the query only showes the males. However, if...	November 4th, 2004 09:48 PM by Marshall Barton	1	473
Using check boxes in a form to be criteria in a query by HM All, I'm have a query which pulls 10 or so check box results from a table, along with other text and numerical fields. I have based a report on this...	November 4th, 2004 09:16 PM by Rick B	1	448

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