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 - Adding 50000 to an ID field by KARL DEWEY
If it is a numerical field then try this -- MS_link: 50000 + If it is a text field then this -- MS_link: 50000 + Val() "Matt_Fairfield" wrote: hey...
November 30th, 2006 09:20 PM
by KARL DEWEY Go to last post
0 80
Date Calc/Criteria by Anthony Viscomi
I am trying to filter records via a query; the query has a Date field "DueDate". I would like to display the records that meet the following date...
November 30th, 2006 09:14 PM
by Klatuu Go to last post
5 90
1 to Many. Duplicate field values by KARL DEWEY
If the data in table2 is a roll-up report of table1 data I see two ways to go. Just use as a subreport. Or use report Sorting And Grouping and have a...
November 30th, 2006 09:08 PM
by KARL DEWEY Go to last post
0 90
if/lookup?? by chris
help my mind is blank again !! i have my value field and my invoice frequncy field, value field been the price and the inv freq been a number 1 to ...99. i...
November 30th, 2006 09:02 PM
by chris Go to last post
2 70
Trouble appending values to a primary key by E10
I had a somewhat similar issue...Here's what I did. I exported the data into Excel. In Excel spreadsheet I select such item (RMG-1), right click - fill...
November 30th, 2006 09:02 PM
by E10 Go to last post
0 85
only show certain rows in a query by jlorick
If you have consistently used this format for all of your records, you can add a criterion with a wildcard in your query. You would type in the first letter...
November 30th, 2006 08:41 PM
by jlorick Go to last post
0 78
Calculating group total in report by Danielle
Thank you Duane! "Duane Hookom" wrote: Group your report by PositionID and display the Group Footer section. Add a text box in the Group Footer section...
November 30th, 2006 08:28 PM
by Danielle Go to last post
0 91
append queries by [email protected]
i have this append query its working apart from one bit for the field Manufacure ID, I would like it to get the number from the form i am on How do i get it...
November 30th, 2006 08:27 PM
by kingston via AccessMonster.com Go to last post
2 88
union query memo field by SeekAns
I use a union query to generate a report in excel. The report has a memo field. I use excel version 10 and all the messages in the memo fields are displayed....
November 30th, 2006 07:53 PM
by SeekAns Go to last post
0 78
SQL by Klatuu
I assume you are in a form, but you did not say what you would do to initiate the search, so I am guessing you will be entering the customer ID in a text box...
November 30th, 2006 07:44 PM
by Klatuu Go to last post
0 76
Deleting values in a field in a table with several fields by ChuckW
Jerry, Thanks for your help. I place the button on my form which is a continous form. When I click the button with the code you suggested it deleted the...
November 30th, 2006 07:33 PM
by ChuckW Go to last post
0 66
SQL by Ramtin
I have query, finding customers based on customer ID, What I can not do is when there is no record on my table meaning the customer is new i want access to...
November 30th, 2006 07:01 PM
by Ramtin Go to last post
0 75
STEP BY STEP DATA ACCESS PAGE by juan de dios
hi i'm new on asp may some one send me an example of how to bind data to a dropdownlist and depending of the value connect to a hipperlink and open a word...
November 30th, 2006 06:45 PM
by juan de dios Go to last post
0 64
only show certain rows in a query by veronicamars
I have a product/serviceID Field. In a query I just want to show the product information. The product ID numbers are like P100, P101,P102 and the serviceID...
November 30th, 2006 06:43 PM
by veronicamars Go to last post
0 73
Quering Fields With Value and Only Those Fields by HLD920
That did it! I was overthinking it. Thanks for simplifying it for me. "Klatuu" wrote: If you are using the Query builder and only want records with a value...
November 30th, 2006 06:31 PM
by HLD920 Go to last post
0 86
Quering Fields With Value and Only Those Fields by Klatuu
If you are using the Query builder and only want records with a value in Date Cancelled, put the following in the Criteria for that field in the query: IS NOT...
November 30th, 2006 06:24 PM
by Klatuu Go to last post
0 85
league by Dale Fye
Gil, Try something like: SELECT T1.TeamName, T2.TeamName FROM tbl_Teams T1, tbl_Teams T2 WHERE T2.TeamName T1.TeamName This should give you all of the...
November 30th, 2006 06:21 PM
by Dale Fye Go to last post
0 87
Trying to return unique records only by Dale Fye
Krista (I assume this is Krista), Is it a hyphen separator or an underscore as you mentioned in your response to my post yesterday? One of the problems with...
November 30th, 2006 06:14 PM
by Dale Fye Go to last post
0 80
Updating primary key in multi-table db by hime
I have a database of graduate students that uses their SS# as the primary key in the main table, and as a foreign key in the related tables. I have enforced...
November 30th, 2006 06:06 PM
by hime Go to last post
0 117
Quering Fields With Value and Only Those Fields by HLD920
I need help. I have a table that includes a field for Date Cancelled. I want to create a query where it will only generates the records that include a field...
November 30th, 2006 06:02 PM
by HLD920 Go to last post
0 93
Post New Thread


Display Options
Showing threads 21821 to 21840 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:26 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.