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
Crosstab column heading order by Opal[_3_]
I am creating a crosstab query in Access 2003 as a basis for a report. I want to be able to sort my column heading but can't figure out how, is there a way? ...
September 24th, 2009 08:43 PM
by Opal[_3_] Go to last post
5 175
Keyword Search by tendoy5
I am using "Like" for a keyword search. is there a way to highlight or bold the keyword whenever it appears in the results? -- Tendoy5
September 24th, 2009 08:41 PM
by John Spencer Go to last post
4 164
Query issue by jo
Hi I have a query that will show wot has been done in the last 15 days but I want another query to show wot has not been done? I just cant think how to work...
September 24th, 2009 07:54 PM
by jo Go to last post
4 168
Massive Large Query Issues by JimS
I have a query that brings together data from 12 queries into a "shadow" flat table to reduce form load times for certain forms. Recently, it's begun running...
September 24th, 2009 07:42 PM
by John W. Vinson Go to last post
4 181
deleting duplicate data by pat67
hi. I have a table that has gotten some duplicates. I want to delete them, but I don't want to do it one at a time. Can someone show me a way to do...
September 24th, 2009 07:26 PM
by pat67 Go to last post
2 120
Take Parameter from Record Selected on Continuous Form to Run Quer by Valerie
I have a database for tracking items and money given to needy clients. I have a Search form I designed based on Allen Browne's tips with entry text boxes on...
September 24th, 2009 06:58 PM
by Valerie Go to last post
4 127
If/Then/Else Query by shm135
Hi, I have five date columns in my table: Date 1, 2 ,3 4, 5 I'm not sure how to do this in access but I want to create a query that show all the records...
September 24th, 2009 06:42 PM
by Ken Snell MVP Go to last post
6 178
Report Query Difficulties by RayToddJr
I have a query for a report. This this query, I have a sub-query. I think I have pinpointed my overall problem to the sub-query. The SQL for the sub-query...
September 24th, 2009 05:45 PM
by RayToddJr Go to last post
7 161
Extract part of text by MLS
Hi, I need to get the following data extracted into 5 different columns with each portion being defined by a "." PRZJFY.US.P.Coord Inside...
September 24th, 2009 03:32 PM
by MLS Go to last post
5 185
Query Multi Value Fields by Debra Lassman
Is it possible to run a query and show only the values that are not checked in a multi value lookup field? I have a list of 80 tasks that HR needs to...
September 24th, 2009 02:58 PM
by S.Clark[_2_] Go to last post
1 127
Rounding number by Boon
Hello, I would like to know what function in Access that would perform exactly the same as function Round() in Excel. In excel I use function, for instance,...
(Multi-page thread 1 2)
September 24th, 2009 02:20 PM
by Gina Whipp Go to last post
15 257
how to change format of data already entered by Beth A
I entered a list of phone numbers and changed the input mask to display the numbers including the dash and parenthese, ie. (555) 555-5555. However, the data...
September 24th, 2009 02:01 PM
by Jennifer Go to last post
5 134
How do I copy a record from one query to another? by Frank Martin
I have to create a Debtor account in my general ledger. Therefore my aim is to copy some fields of a record from the query "QryInvoiceTotals" into another...
September 24th, 2009 08:39 AM
by Frank Martin Go to last post
4 158
Crosstab sum doubles by Ron P[_2_]
I created a crosstab query that appeared to work fine. However after I looked at the numbers the query is returning double amounts in the sum columns. I...
September 24th, 2009 12:16 AM
by John Spencer Go to last post
2 120
parsing a field with right string by mibc
OCLC: Right(!,InStr(! ,"ocm")) I want only the numbers that come after ocm in the OCLC NO field to be returned in a new field called OCLC. The number is not...
September 24th, 2009 12:11 AM
by John Spencer Go to last post
5 160
Critera entries by tendoy5
I am trying to run a query based on the end date of a contract. Idealy, I would like to be able to enter a date and have the query produce all contracts...
September 23rd, 2009 10:01 PM
by KARL DEWEY Go to last post
5 146
Using a period or dot in a parameter query criteria line by Brucels
Is there a way to use a period or dot inside the square brackets when prompting a user for criteria in a query? I need to show an example of the format to be...
September 23rd, 2009 08:32 PM
by John Spencer Go to last post
2 123
How to use arithmetic rounding in Access by Boon
How to use arithmetic rouding in Access? so that the result is the same when doing round() in Excel. Thanks, Boon
September 23rd, 2009 08:25 PM
by John Spencer Go to last post
2 146
Type Conversion Failure Error by Jon22
I keep getting a Type Conversion Failure error when I run a particular append query. Four of the fields being appended are derived from Expressions. I've...
September 23rd, 2009 07:15 PM
by Clifford Bass[_2_] Go to last post
4 157
Query Help by booner
I have 3 tables ... 1 table list of devices ... 2 other tables contain references to those devices. Schema Overview: Devices - Id - AutoNumber CSDevices -...
September 23rd, 2009 07:03 PM
by booner Go to last post
4 141
Post New Thread


Display Options
Showing threads 3001 to 3020 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 09:19 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.