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 Reverse Sort Order / Thread Starter Last Post Replies Views
"And" "Or" Search Criteria by [email protected]
I have a field that contains summaries of articles. I want to search within the field for the following: "Red" and "Blue" or "Green" and Blue" I want my...
June 8th, 2007 09:16 PM
by [email protected] Go to last post
4 78
"and" criteria by lwilde
I'm very new to Access, so I"m not too sure how to create a query to get the results I want. What I have done so far is import a spreadsheet into a table...
April 9th, 2009 02:24 PM
by Michel Walsh Go to last post
1 81
"Between date" query by C_F
I have a query that I use to return transactions that happened between a specific set of dates, and the person responsible for those transactions. It worked...
December 15th, 2005 04:27 PM
by Michel Walsh Go to last post
2 98
"Between" Comparison by csarjeant via AccessMonster.com
Quick question, could someone answer for me: When using the "Between" function to filter records by date, as in Between And , do the filtered results include...
October 21st, 2009 04:55 PM
by vanderghast Go to last post
3 175
"Between" Parameter Query not working with DateAdd by Christy Wyatt
I added 7 days to a WkEndDate to come up with the paydate in a query. When I use "Between and to get all the pay days in that month, it gives me the right...
(Multi-page thread 1 2)
January 11th, 2007 03:58 PM
by Van T. Dinh Go to last post
11 321
"Cannot delete from specified tables" by [email protected]
Hello! Here is part of my database: tblStudents: StudentID tblStudentsAndMajors: StudentID, MajorID tblMajors: MajorID tblMajorsAndClasses: MajorID, ClassID
November 10th, 2005 10:08 PM
by Adam Turner via AccessMonster.com Go to last post
4 128
"Combine" Fields? by Debris
Hello, Employees have two available methods of entering time on a project (depends on the job function). One method uses the employee's ID, while the other...
August 13th, 2006 03:29 PM
by David Cox Go to last post
7 116
"Convert" command? by Ricardo Vazquez
Hi everybody! Is there a SQL command for MS Access similar to the CONVERT command in Transact-SQL? And could you please help me an usage example? I need to...
January 11th, 2008 04:04 PM
by Michel Walsh Go to last post
2 84
"Could not delete from specified table" Error by Eric @ CMN, Evansville
When attempting to run the following query I got the "Could not delete from specified table" Error. Any ideas why ? DELETE Raw.* FROM Raw INNER JOIN ON...
August 16th, 2006 05:11 PM
by Allen Browne Go to last post
1 99
"could not open table in workgroup information file" by JBrock
I'm getting an error message when I try to open the database up...stating that it "could not open table ... in the workgroup information file". What does this...
November 22nd, 2005 05:00 PM
by JBrock Go to last post
0 73
"Create a new query" option has disappeared, where is it? by Vanessa
I am trying to create a query on an office 2000 database. The database was created several years ago. Someone else created queries on the same database with...
February 27th, 2006 09:13 PM
by Duane Hookom Go to last post
1 89
"Currency" format lost in subform. by Frank Martin
I have a subform that has a combo which selects filtered records. The combo has a field "ItemPrice" which has lost the currency format, but this format is...
February 13th, 2008 03:41 PM
by John Spencer Go to last post
4 119
"Data Has Been Changed" error with MSSQL 2005 backend using left j by Joel Maxuel[_2_]
I am in the process of testing a database upsized to SQL Express 2005 (originally created through jet/local mdb). The data is comprised a couple dozen...
November 12th, 2009 07:59 PM
by Joel Maxuel[_2_] Go to last post
1 124
"Data type mismatch in expression" by mohsin via AccessMonster.com
Hi expert I got this ""Data type mismatch in expression" error message while running my queries. SELECT qrymaxallca1.NE, qrymaxallca1.Date, Sum(! ) AS...
July 2nd, 2007 12:59 PM
by mohsin via AccessMonster.com Go to last post
2 67
"Data type mismatch" without any criteria! by Mark Parent
I'm receiving a data type mismatch on a query that groups, but specifies no criteria at all. This query does rely on a previous query with a criteria, but...
July 30th, 2009 03:28 PM
by Mark Parent Go to last post
6 166
"Decompose" & randomly resample records? by LeAnne
Hi, all. This is one of those "Is this even possible?!?" posts, so please bear with me. Picture an Access recordset with the following nicely normalized...
July 28th, 2006 05:41 PM
by John Vinson Go to last post
3 99
"Delete Query" Problems by Devona
I am trying to run a Delete Query using two tables. Here is what I have so far: DELETE DISTINCTROW tblProjects., tblComments. FROM tblProjects INNER JOIN...
September 12th, 2006 08:49 PM
by DRB Go to last post
2 102
"Division by Zero" Question by AccessIM
I have a calculated field shown below: CasesReplenished: ((*)/) The field works great and the calculation is correct but, when I try to sort by this field,...
August 3rd, 2009 03:29 PM
by AccessIM Go to last post
2 110
"Division by zero", but... by rachael
I have a UNION query that's merging the results of several individual queries. When I run the UNION, i briefly see the results of the query as expected. A...
July 3rd, 2007 11:20 AM
by DAVID Go to last post
2 203
"does not recognize as valid field", but prompts when parameters d by aemAndy
I have a crosstab query that calls on a query that calls on other queries... you get the idea. I'm getting the "the Microsoft Jet database engine does not...
April 24th, 2006 09:53 PM
by Duane Hookom Go to last post
5 85
Post New Thread


Display Options
Showing threads 161 to 180 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 11:42 AM.


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