Running & Setting Up Queries - Page 196

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
Like / IIF issues (as query criteria) by sha123 I have been working on this for hours and still cant figure it out.... I have a combo box that selects a description call "land" I want my query to be able...	July 17th, 2009 03:42 PM by John Spencer	2	108
Summing Check Boxes by GoBrowns! Can someone please check this over? I am trying to create a query to sum some fields and some check boxes.... I keep getting an error that I am missing an...	July 17th, 2009 03:35 PM by John Spencer	3	102
Get rid of Design View from print preview shortcut menu by h2fcell OK hereâ€™s a tricky one in Access 2007. I have a report that opens using the below code. Private Sub Command13_Click() Dim myFilter As String myFilter = " =...	July 17th, 2009 12:39 PM by Dale_Fye via AccessMonster.com	3	120
Limits of a Switch Function? (Recoding Value into Value Labels) by blobb Hi. I am attempting to use a switch function in a query and i have come across the error "Expression too complex in query experssion 'SWITCH(..." Basically...	July 17th, 2009 02:13 AM by Douglas J. Steele[_3_]	3	115
Access Checkbox and Sum (right post) by Miltos Hello. I need some help for this access db. doseis check 50 y/n 50 y/n 50 y/n i tryed to sum doseis only if check=0 like...	July 17th, 2009 02:13 AM by Miltos	2	117
Sorting in a Cross Tab Query by PerryK I have a basic Cross Tab Query that is feed by a table that is updated monthy. The months are labled as 200901, 200902, 200903, etc.. The are also lines for...	July 16th, 2009 09:36 PM by PerryK	2	116
Combining Queries by AGOKP4 Hi, I have a query I'm trying to "split" so it comes out by sex. the original query is: TRANSFORM Count(.) AS SELECT ., Count(.) AS FROM GROUP BY...	July 16th, 2009 09:20 PM by AGOKP4	4	116
Date subtraction by Stephanie Hi. I'm trying to perform a date subtraction between incident date and discovery date, but I can't get the syntax correctly. I'd like to have the output in...	July 16th, 2009 08:07 PM by Stephanie	3	121
Sorting Text Field containg letters and numbers by tpeter I have a field that is forced to be a text field. The field is called and contains numbers. This format can vary from 1 to J256. When I run my query I am... ( 1 2)	July 16th, 2009 07:31 PM by tpeter	11	179
Pull criteria from a Form by QB I set a query to pull its`criteria from a form using Forms!. That said, I now have a twist and need help in addressing it. The control in question is a...	July 16th, 2009 07:27 PM by John Spencer	2	103
"Enter Parameter Value" dialogue boxes by zufie I can't figure out why when I open my database the "Enter Parameter Value" dialogue boxes for the Date From and Date To textboxes appear on the screen. These...	July 16th, 2009 07:07 PM by KARL DEWEY	2	137
Report Summary by LG I built a query with the following: Date ID Num of Clms (control source= countofbatchid) I created a report and would like to have the total number of...	July 16th, 2009 06:45 PM by LG	2	90
making age group query work by Linda in Iowa[_2_] I recently posted this and received a reply as follows. Can anyone tell me how to make it work as I have not been able to get correct results if any. I am...	July 16th, 2009 05:49 PM by Linda in Iowa[_2_]	7	141
Maximum Value in 2 fields of a record by Williams My table has 2 fields and . I need to compare these fields if they are both not null and take the latest date. Is it possible to compare 2 fields in the...	July 16th, 2009 04:29 PM by KARL DEWEY	1	100
Importing Date fields from Excel by Pete I am importing a worksheet from Excel. The date columns are displayed in mmm-yyyy format, though the data shows on the formula bar in mm/dd/yyyy format. ...	July 16th, 2009 04:13 PM by KARL DEWEY	2	155
Queries returning with missing info (plus asks query question twic by spark Hi - I am hoping someone out there can help me. I am at wits end trying to figure this one out. I am using Access 2002 on Vista computer. Possibly that in...	July 16th, 2009 03:26 PM by spark	9	174
Convert Date by Jennifer Our DB2 tables has the create date field data type as "text" with the yyyymmdd format. I'm trying to convert to mm/dd/yyyy; but also need to change it to...	July 16th, 2009 02:47 PM by Marshall Barton	1	84
Case Sensitive Query by carl I posted this question a couple weeks ago and want to thank you for offering your help. I tried to follow the replies but still cannot get a quesry to do...	July 16th, 2009 01:24 AM by Clifford Bass[_2_]	7	123
Determine size of individual record & space taken in each table! by zufie I have been tasked with the following: See if you can figure out approximately how much space it takes to store 1 individual (record)? This would include all...	July 15th, 2009 10:55 PM by Jerry Whittle	3	110
Date Difference limited to 100 years by Richard S. I have a query to extract all persons with an age eaual to or greater than a user-entered paramater (criteria). The expression (Year(Date())-Year(.)) when...	July 15th, 2009 10:22 PM by Richard S.	6	110

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