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
Create a query for specified text in a field by Jacqueline _Neo
Hi there, I have a number of fields in my query. They are Customer, Document, Title. In this query, i have include a input dialog for the user to enter the...
May 6th, 2010 01:48 PM
by John Spencer Go to last post
2 265
How to calculate overdue? by Jim
We have a customer that has terms of June/1 or Net 60. Any orders placed between 10/2 of the previous year and June 1 of the current year have terms of 6/1....
May 6th, 2010 01:35 PM
by John Spencer Go to last post
2 231
Help With SQL Update by Jason[_40_]
Hello, I have a table in an Access database that I want to create an SQL Query for. Here is the table structu Location Number Area1 2 Area1 ...
May 6th, 2010 09:07 AM
by XPS350 Go to last post
1 304
Function is not availalbe in expressions in query expression error message (0/1) by [email protected]
I recently received this error message when opening the source DB in Access 2007. I have attached two jpg pics. Does this error message give enough details...
May 6th, 2010 03:39 AM
by Gina Whipp Go to last post
9 451
Help with InStr in a query by cherman
I have values like "2010 WW14" and "2010 WW7" in a query and I'm trying to grab the number part to the right of "WW". It will always be a 1 or 2 digit number...
May 5th, 2010 11:07 PM
by Jerry Whittle Go to last post
2 264
multiple query criteria by olive
Let's start with the fact that I am an Access novice, so if this looks like I am way off base, and cannot get any guidance here, just let me know. ...
May 5th, 2010 09:30 PM
by John W. Vinson Go to last post
4 310
Integers behaving like strings by night_writer
I hope someone can help me find the reason for this behavior. I am using a query to run a report that needs to capture status at the end of the month, so I...
May 5th, 2010 08:26 PM
by KARL DEWEY Go to last post
5 296
Check Box query help by Steph[_3_]
Morning all, looking for some more help from my gurus. What I have: A table with 4 or 5 text fields, and 8 Check Boxes. What I want: A query that will...
May 5th, 2010 08:17 PM
by KARL DEWEY Go to last post
2 260
Appned Query Performance by Walt Herman
I have an Append query with approx 25000 records with 8 fields and I am trying to append it into a static table and the performance is abysmal. Can anyone...
May 5th, 2010 08:06 PM
by Jerry Whittle Go to last post
2 271
DateDiff with variable criteria? by Jim
I have a query field that uses DateDiff("d",,) to calculate the difference between a ship date and paid date. I also have =50 in the criteria row to...
May 5th, 2010 07:51 PM
by Jim Go to last post
5 287
Summing multiple fields in matrix/table (qry) by Steve Stad
My form populates a table with Products, Employees, and Emp hours worked on each product. Example: Product Emp1 Emp1hrs Emp2 Emp2hrs Emp3 ...
May 5th, 2010 05:34 PM
by PieterLinden via AccessMonster.com Go to last post
4 282
Linking on field that allows nulls by K Essmiller[_2_]
I have two queries that I need to link together on several fields. I need to link on a PPOCode that is sometimes null. I need a count of claims for each...
May 5th, 2010 04:59 PM
by Jeff Boyce Go to last post
3 266
Help! Unmatched Data Query by ChelseaS
Hello! Here's what I'm trying to do, I'm not sure if an Unmatched Data Query is the best answer or that this can even be done in Access. I have one table that...
May 5th, 2010 04:49 PM
by Jeff Boyce Go to last post
1 218
grouping issue with ' is not null ' by trevorC via AccessMonster.com
Hi All, This first query all works fine, giving the expected results. The second query is a copy of the first query and i changed the " IN " to " OUT ", but...
May 5th, 2010 04:41 PM
by Marshall Barton Go to last post
1 238
Two records one row by Marcie
I have a table that has 2 records per id. I want to display in a query each value as a record. So if Id 123 has a record with the value of 7 and another...
May 5th, 2010 02:51 PM
by vanderghast Go to last post
1 226
Make Table query, but remove character from field by Andy
I already have a rroutine set up and part of that is a make table query. One of my fields has some values as G35.X and some as G35X. I want to make this...
May 5th, 2010 01:32 PM
by Andy Go to last post
5 290
Expressions by Amin
Kindly explain to us what this expression actually means. i got it from the sample database 2007 temlate Qty To Reorder: IIf(0,IIf(,,),0)
May 5th, 2010 01:28 PM
by John Spencer Go to last post
1 224
Add Fields from Record by Scott
I have two tables. One has a unique PersonID with a lot of information about the person (one to one). Another table has one to many records with addresses...
May 5th, 2010 01:21 PM
by John Spencer Go to last post
1 280
How do i get the product of max. price in access2007 query? by amr
in query i want to get product ID with the Max. or Min. price
May 5th, 2010 01:00 PM
by John Spencer Go to last post
1 274
Using Variable as criteria by Mr. Bud
Hi and TIA. I have a procedure that constructs an In statement and stores that value in a module level variable. I then want to use criteria in my query to...
May 5th, 2010 07:50 AM
by Mr. Bud Go to last post
4 333
Post New Thread


Display Options
Showing threads 281 to 300 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 12:02 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.