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
How to approach complex query by Julia Boswell
Hi folks, I'm having a real problem getting a query (or set of queries to work) and no matter what I try I fail :-( I wonder if someone could help me with...
January 23rd, 2006 05:51 PM
by Vincent Johns Go to last post
5 254
If then else statements in sql by Akilah
I want my query to return a message based on the input received. How do I make this statement return a message to the same column (...
January 23rd, 2006 04:48 PM
by Allen Browne Go to last post
1 151
Transfer Database opening queries in Access 2003 by ChristinaH
We have a database that our software will download and run a module to import code fixes from that database into our software - sometimes the fixes...
January 23rd, 2006 04:37 PM
by ChristinaH Go to last post
0 124
Help with Query Checking 2 Fields by Alan
Hi, I'm hoping that someone will be able to help me with a problem I'm having with queries. At the moment I have 3 tables as follows: Table 1: ID MasterList:
January 23rd, 2006 02:58 PM
by Jeff Boyce Go to last post
3 134
help on query for a report by Bart
Hi, Can someone get me started in the right direction. I have 2 tables, one is production the other is incoming_inventory. In production we have a fields for...
January 23rd, 2006 12:59 PM
by Vincent Johns Go to last post
6 322
Help please! by jo152
Hi My query does not work correctly but I really can't see the problem. What I want to do is to count the number of times T_Details_EnFormation.NIP is either...
January 23rd, 2006 06:56 AM
by Tom Ellison Go to last post
2 108
Left, LTrim, or what by JWCrosby
I have a field with Lastname, Firstname (ex: "Smith, John") I want to extract the Last name and first initial (ex: "Smith, J). What's the code? Thanks in...
January 23rd, 2006 05:23 AM
by JWCrosby Go to last post
4 168
Add to rows in the same table with query? by Monsignor JAV
Hello I am relatively new to MS Access 2003 and have a question that is probably quite simply to answer. I have a a query from a report data table with the...
January 23rd, 2006 02:07 AM
by Monsignor JAV Go to last post
2 200
functions in queries by bindurajeesh
I have created a function and am calling it from a query as an expression. When I run the query all is fine but when I run the report that uses the query I am...
January 23rd, 2006 12:12 AM
by david epsom dot com dot au Go to last post
6 225
create new expression?field? in a query based on two fields by Abby
HI- I have two tables 1. Donor information (with fields: ID, last name, first name) and 2. Donations (with fields: ID, gift date, gift amount). I have set up a...
January 22nd, 2006 10:27 PM
by Duane Hookom Go to last post
5 226
Combining two IIf expressions into one by Peter Lawton
I am trying to combine two IIf expressions that work fine by themselves into a single expression. I have fields and and two Expressions a) FinalPub:...
January 22nd, 2006 09:35 PM
by Peter Lawton Go to last post
4 201
Count No of orders for customer by mogens
I have a qry that extracts the open orders, ie orders that have not yet been processed. The qry is based on table_orders and a...
January 22nd, 2006 08:58 PM
by mogens Go to last post
4 134
Query to replace unwanted characters by John
Hi How can I replace all characters except a-b,A-B,0-9 and hyphen from a field in a table? Thanks Regards
January 22nd, 2006 04:52 PM
by John Spencer Go to last post
2 123
Calculation by Sam
Hello All I need to calculate the average weighted interest rate for a report. I know how to calculate this manually (using a calculator) however I cannot...
January 22nd, 2006 03:01 PM
by Jeff Boyce Go to last post
1 112
Error querying Access text fields if dash or minus sign in middle of text by Dan V.
I read somewhere that minus signs or plus signs in access fields are bad news. Is that true? If so this is a major bug with MS Access. I can't 'cast' using...
(Multi-page thread 1 2)
January 22nd, 2006 12:58 PM
by Go to last post
14 259
Query based on multiple selections in list box by Snowsride
How can I create a query that uses multiple selections from a list box as criteria?
January 22nd, 2006 08:31 AM
by Snowsride Go to last post
2 185
Help with Date and Time Query by REA
I hope someone can help me with this; I am using Access 2003 and I have a date and time field. I would like to have a query that I enter the date into and it...
January 22nd, 2006 07:19 AM
by Duane Hookom Go to last post
2 102
Troublesome query by RWhittet
Hi, I have built two different queries, one works, and the second does not work correctly. I am attempting to pull all records from one table, and only the...
January 22nd, 2006 07:15 AM
by John Vinson Go to last post
4 437
How to add a new field to a Make Table query? by Baby Face Lee
I've got a make table query that gets it's source from three different tables but I would also like to add two (new) additional fields to the...
January 22nd, 2006 04:34 AM
by Allen Browne Go to last post
4 166
Using exist/not exist in subquery by Damon Heron
I have four containers in my containers table. I want to eliminate the three that are in my transactions table and just retrieve one. Here is my sql code that...
January 22nd, 2006 12:40 AM
by Damon Heron Go to last post
2 104
Post New Thread


Display Options
Showing threads 30001 to 30020 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:40 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.