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
Query by Dalocky
Good Morning I have table with which has difference categorys which depend on the name of the form selected. How do I get this to show up when a form is...
April 20th, 2010 09:57 PM
by Dalocky Go to last post
2 125
QUERY to show record if text present in field by yorkielover02
I have a query that I would like for it to only show a record if there is something (text/anything) present in that field. Any ideas on how to do that would...
April 20th, 2010 09:22 PM
by Marshall Barton Go to last post
3 167
Query based on date in a filed more then 3 days old by Rob Hamlin
What is the firlter criteria so I only see data where the date in a field is more the 3 days old. I am having some trouble with this one. Please excuse me...
April 20th, 2010 07:32 PM
by Daryl S[_2_] Go to last post
1 190
field no show by seeker
The following query does not show the ID field. This is imperative because data change is dependent upon this field showing. select member_time.id,...
April 20th, 2010 06:27 PM
by Jerry Whittle Go to last post
5 122
How to Retrieve Data From Another Access Dataase Without Linking to It? by Stewart Berman
I would like to be able to pull data from another Access database without linking to its tables. If I create a database object that references the other...
April 20th, 2010 05:28 PM
by Marshall Barton Go to last post
3 284
You tried to execute a query that does not include the specified expression... by Nancy via AccessMonster.com
I originally thought this problem was with my report so I posted it under the reports section but not I'm seeing that it is a query problem so I am re- posting...
April 20th, 2010 05:21 PM
by KARL DEWEY Go to last post
1 655
Using a Password With an SQL IN Clause by revans611
I am trying to delete records from an external database using a SQL IN clause, but my syntax is obviously flawed. My code looks like this: DELETE * FROM...
April 20th, 2010 02:47 PM
by Tom van Stiphout[_2_] Go to last post
1 304
Between Dates Parameter Query by Linda RQ[_2_]
Hi Everyone, Access 2003. I have a query that I have set up so the user can type in "between" dates. They pull data for the month so the first date they...
(Multi-page thread 1 2)
April 20th, 2010 01:50 PM
by John Spencer Go to last post
13 391
Database engine cannot find the input table or query by Brendan
Hi It would be great if someone can look at this sql please. The query runs and brings back the correct data, but every time I run it, I get the error "The...
April 20th, 2010 06:02 AM
by Brendan Go to last post
4 180
Append Query with Oldest top Records by Group by Aaron
Hello All, I am not sure where even to began to start on this query. I am looking for a query that on table tblmaxdata that has the following fields (PN,...
April 20th, 2010 01:46 AM
by John W. Vinson Go to last post
2 189
creating a flag to identify first, second time etc someone has app by helpreq
Hi, If I have a dataset showing the same person three times, on three different dates but want to create a flag (as below) which states whether this is the...
April 20th, 2010 12:59 AM
by John Spencer Go to last post
2 123
How do you ignore entire tables in an Inner Join Query? by Marshall Barton
Martin Prunty wrote: Im trying to build an application that analyzes up to ten (10) tables that contain information about unique types of telephone calls...
(Multi-page thread 1 2)
April 19th, 2010 10:07 PM
by John W. Vinson Go to last post
13 279
Combobox not updating? by Farkyss
I have a FORM for purchase orders. On this form there is a Customer ID field whose values are listed in a combobox whose contents are pulled from a Customer...
April 19th, 2010 07:18 PM
by KARL DEWEY Go to last post
5 224
Please Help: compare values in two columns present in seperate tab by sam
Hi All, How can I compare values in two columns (columns are in different tables) ? I also want to display the values that dont match in a seperate...
April 19th, 2010 07:16 PM
by golfinray Go to last post
1 167
Using a combo box as a criteria for a query by neetkleat
I have 2 tables: Table 1 = Position Names PositionID - Data Type = AutoNumber Position Name - Data Type = Text Table 2 = Staff Positions StaffID - Data Type...
April 19th, 2010 07:15 PM
by KARL DEWEY Go to last post
1 159
Viewing expressions in a listbox by Peter Stone
Access 2003, XP Pro, semi-novice I presume that I need to solve this using a query. I have a table "Expressions" where records are similar to the one...
April 19th, 2010 07:05 PM
by vanderghast Go to last post
4 133
export query with formulas to excel by mark
Is there a way to export my Access query to Excel 2003 while keeping the formulas in Excel. For example, in my Access query I have a field called "Other"...
April 19th, 2010 06:55 PM
by NG[_2_] Go to last post
2 180
Report Printing by Farkyss
I have a FORM. On this form is a BUTTON. This button should be opening an REPORT and PRINTING it. The REPORT is based on information pulled together in a...
April 19th, 2010 05:16 PM
by Farkyss Go to last post
2 123
[email protected] by PayeDoc
Debbie Enjoy! Les
April 19th, 2010 05:06 PM
by PayeDoc Go to last post
1 118
Remove “www.” from a text string result in Access ExpressionBuild by setver
I have an expression with which I am determining whether or not there is a value for certain fields, then using either a Null string result, one of the field...
April 19th, 2010 03:02 PM
by Stefan Hoffmann Go to last post
2 130
Post New Thread


Display Options
Showing threads 461 to 480 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 05:15 PM.


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