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
Distinctrow by Ann
I'm trying to get only the distinct rows for the following but it doesn't work. What am I doing wrong? Thanks for any help you can provide. SELECT...
November 20th, 2009 10:32 PM
by Bob Barrows Go to last post
4 149
Identify missing numbers by Tara
I have a table that uses a text field to store receipt numbers. Currently I use VAL to sort the numbers numerically. Is there a way to identify which...
November 20th, 2009 09:55 PM
by Tara Go to last post
4 179
Access Query by Ken Taylor
I have a table with approx 270K records. One colum contains an ID codes i.e. WATUA1, WAXUB0 etc. I need to change the last to letters to AA, i.e. WATUAA,...
November 20th, 2009 09:45 PM
by John Spencer Go to last post
1 167
can not rerun Make table query - say has to delete prev. by babs
I set up a make table query to get a List of Jobs that I care about scheduling for the month - at the end of each Day I would like to update and Over write...
November 20th, 2009 09:13 PM
by babs Go to last post
5 125
Date Function in query by RoyS1031
I have two tables. One is INVOICES, the other is "INVENTORY. Each has a DATEMODIFIED field. The dates in INVENTORY are formatted dd/mm/yyyy hh:mm:ss. Yet...
November 20th, 2009 08:32 PM
by RoyS1031 Go to last post
3 147
Sorting in Queries by Charles
Hi, I am trying to write a query that assigns contributions for each account considered to either East or West depending on which territory has the larger...
November 20th, 2009 08:16 PM
by KARL DEWEY Go to last post
2 142
Data Conversion Expression returns #Error by D. Stacy
Objective: Convert txt data representing a time stamp on a particular activity into DateTime format. 1. If the data field contains any data convert it to the...
November 20th, 2009 05:56 PM
by John Spencer Go to last post
2 123
Data Conversion Expression returning an #Error by D. Stacy
Looking for some guidence on how to get this expression out sick bay! The data field comes from a legacy system and may or may not have data in it, may or...
November 20th, 2009 04:28 PM
by D. Stacy Go to last post
0 150
DateDiff("yyyy",[Anniversary],Now()) returns rounded number by apex77
I am using DateDiff("yyyy",,Now()) in a query to return the number of years between two dates. Since it is an Anniversary calculation, the result needs to...
November 20th, 2009 04:08 PM
by Jerry Whittle Go to last post
3 135
Type mismatch in Function by PatK
Hoping someone might be able to help. I have the following Function that I have used in excel 2007 (and it works fine), that I am trying to now use in MS...
November 20th, 2009 04:03 PM
by PatK Go to last post
5 179
WHERE CLAUSE by Martin
Hi, I have a query that I need to assign a WHERE clause within the statement. This is below: Monthly Update: IIf(!="*BR*",!* ! WHERE ! = "BR",0) Does...
November 20th, 2009 03:20 PM
by John Spencer Go to last post
2 177
iif and between by Justin T
hello i have a set of numbers 1-52 in a field. when i query criteria ...between and -13....i get the answer i need with the query: a set of...
November 20th, 2009 03:15 PM
by John Spencer Go to last post
2 148
Query to populate combobox with names of tables, only if they contain data by Skru spammers
I just came up with an interesting trick that may be useful to someone else. I have a form with a combobox, populated by names of tables in the database....
November 20th, 2009 02:37 PM
by Skru spammers Go to last post
0 126
How do I add a field to a query and make a calculation? by Terry Hollands
I have a database with fees paid field and in a query I need to add a 15% rebate if the student has paid the fee already. On the query in the criteria line...
November 20th, 2009 01:11 PM
by Wolfgang Kais[_4_] Go to last post
3 152
Crosstab qry not adding up by deb
I've built a crosstab qry for a tenant sales database based on a select qry, the original select query works (adds up correctly) ive checked by sorting and...
November 20th, 2009 07:43 AM
by KARL DEWEY Go to last post
1 117
Problems with Crosstab Query by Rob Parker
This should be so simple, but I'm about to tear my hair out. I have a crosstab query based on a table, left joined to a query which selects distinct FYs from...
November 20th, 2009 02:17 AM
by Rob Parker[_3_] Go to last post
4 168
Using Criteria for a Y or N response by TKorell
I am using a large database and I want to have it give me only the Y responses not the N responses for the labels. This might sound nuts but there are 12...
November 20th, 2009 12:08 AM
by Jeff Boyce Go to last post
2 147
Clause order in SQL select query by .Len B
Are there any rules that govern clause order? Does the parser care? Obviously SELECT must be first but does WHERE have to precede ORDER BY? This question...
November 20th, 2009 12:06 AM
by .Len B Go to last post
4 174
Counting records matching criteria by OssieMac
I have the following queries that count records matching particular criteria. One counts ProdPrefix="C" and the other counts ProdPrefix="M". Output is in 2...
November 19th, 2009 11:53 PM
by OssieMac Go to last post
4 119
Web based news browser by Dale Fye
Don't know what has happened lately, but the the MS web based news browser functionality has decreased lately. Up until recently, searching on my name in a...
November 19th, 2009 11:19 PM
by [email protected] Go to last post
2 165
Post New Thread


Display Options
Showing threads 2241 to 2260 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:35 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.