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
Appending zero-length string by Claire
Hello all, I recently ran Allen Browne's function to change all my fields to not accept zero-length strings- which makes so much sense to me. Of course, I'm...
February 19th, 2010 07:31 PM
by David W. Fenton Go to last post
4 235
Help with computing date\Time between previous record by Dave
I am trying to calculate how long it has been from a previous visit. I am tracking visit dates for customers. So I am sorting visit dates by customer. I...
February 19th, 2010 06:53 PM
by vanderghast Go to last post
5 251
Struggling when there are no records by Tara
Forgive me...I know this has been covered extensively, but I still can't get it quite right. I have a query that is currently set up like this: FFAmended:...
February 19th, 2010 06:47 PM
by Tara Go to last post
3 211
How to redisplay the text field based on a stored ID field by Billiam
I stored the ID of a lookup table for Salutation as a foreign key in my People table. I did the same thing with a suffix lookup table. I am trying to produce...
February 19th, 2010 06:44 PM
by John W. Vinson Go to last post
2 178
LIKE function help needed in combobox in the form by naveen prasad[_2_]
i have a table t1, fields names,age,place in form , a combo box c1 added and in its properties row source type is table/query row source "select distinct...
February 19th, 2010 05:33 PM
by Ken Snell Go to last post
3 229
Sum up by cust w all details by hoachen
Table Data CustID Item# ItemName Amount 123 A11 Abc 11.5 123 A13 cde 10 123 A16 fgh 20.5 111 A11 Abc 11.5 111 A16 fgh 10 Output example 123 A11 Abc 11.5
February 19th, 2010 04:03 PM
by hoachen Go to last post
3 230
IIF statement, proper formula by jligue via AccessMonster.com
Not entirely sure if the IIF statement is the correct way to go about this, I have a field on a query that has total pounds of either printed or plain product....
February 19th, 2010 03:43 PM
by Allen Browne Go to last post
1 235
IIf by kevcar40
Hi i have a crosstab query that takes values from 2 tables table one weekly prod scores (entered weekly) table two takes scrap numbers (entered daily) the...
February 19th, 2010 02:59 PM
by John Spencer Go to last post
1 148
Do I need a subquery? by Barry
Hi: I am having problems creating a query to show cars with WorkOrders. The tables involved are Customers (CustomerID as PK), CustomerCars (CardID as PK,...
February 19th, 2010 07:47 AM
by Barry Go to last post
2 215
Turning off action query confirmation messages by mhmyers40241
How do I turn off ALL confirmation messages for make-table and append queries when running them from a macro in an Access 2007 .accdb database? I've tried...
February 19th, 2010 07:34 AM
by Allen Browne Go to last post
1 239
remove the database link by subs
i have a table which is linked to some other table or database. how would i remove the link to this table?
February 19th, 2010 07:18 AM
by John W. Vinson Go to last post
3 187
Between Dates Criteria by Apprentice
Can’t' seem to get it. I have two fields: Start_Date and End_Date. Both are Short Date Format. Note: Both date fields are previously calculated dates...
February 18th, 2010 10:50 PM
by vanderghast Go to last post
2 189
IIF statement by jligue via AccessMonster.com
Not entirely sure if the IIF statement is the correct way to go about this, I have a field on a query that has total pounds of either printed or plain product....
February 18th, 2010 10:35 PM
by jligue via AccessMonster.com Go to last post
4 201
Query wont sort ? by Dorian
Any idea why this wont sort by Lastname ? SELECT C.Restitution-NZ(P.TotalPaid,0) AS , Trim(C.Firstname & " " & C.Lastname) AS ,...
(Multi-page thread 1 2)
February 18th, 2010 09:20 PM
by Dorian Go to last post
10 304
Qry with dupes looking for only most recent date by The Joker via AccessMonster.com
Hello all, I have a query I'm running and when it pulls it has a bunch of duplicates, which is expected. Is there some type of criteria or something I can do...
February 18th, 2010 05:54 PM
by Daryl S[_2_] Go to last post
2 211
SQL by KenSheridan via AccessMonster.com
Firstly you'd need to create a form then add a command button to it. Then select the button in form design view and open its properties sheet if its not...
February 18th, 2010 05:50 PM
by KenSheridan via AccessMonster.com Go to last post
0 164
Help required in Update query by naveen prasad[_2_]
Hi, pls help me here table t1 has 3 fields, and data is as below name , grade , marks n1 a 10 n2 b 20 n3 c ...
February 18th, 2010 03:38 PM
by naveen prasad[_2_] Go to last post
2 171
Hyperlink within Database 2007 by mroser1
I am creating a rather extensive database in Access 2007 that is going to have many tables. To make this database user-friendly I want to create Hyperlinks...
February 18th, 2010 03:30 PM
by mroser1 Go to last post
0 150
Relationship - Outer Join - Microsoft Access 2002 by Vanessa Simmonds
Good Morning, I have a queries which for the moment contains two tables (DUIT and NPI) and one outer join (all Values on DUIT and one value from NPI). I...
February 18th, 2010 02:20 PM
by John Spencer Go to last post
1 212
cross tab query by subs
ozip dzip week no1 week no2 week no3 i have the above fields in a cross tab query. columns week no1 , week no2 and so on could be dynamic-- it could also...
February 18th, 2010 07:00 AM
by Duane Hookom Go to last post
1 172
Post New Thread


Display Options
Showing threads 1161 to 1180 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 02:03 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.