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
Time() - 5 minutes by Scott
I have an update query that adds the time to a field as well as various other updates. I am trying to run a subsequent query that I am trying to get it to...
May 2nd, 2008 08:00 PM
by Scott Go to last post
2 101
How can I LEFT JOIN two subqueries in the same SELECT statement? by N L
Greetings, I have one table, and a few queries that I want to run off of that table. I would also like to view the results of LEFT JOIN operations on those...
May 2nd, 2008 07:37 PM
by John Spencer Go to last post
7 134
Help with and Update query by Brian
Hello, I have an Access table with tmpReportIndex PgNo AcNo NumPgs 1 0010 0 2 0010 0 3 0108 0 4 0108 0 5 0108 0 6 0138 0
May 2nd, 2008 07:22 PM
by John Spencer Go to last post
7 115
COMBINING TWO QUERIES by JOE POLLOCK
I HAVE TWO QUERIES WHICH I HAVE PRODUCED REPORTS FOR. ONE QUERY REPRESENTS SALES FROM YEAR 1 AND THE OTHER SALES FROM YEAR 2. WHAT IS THE BEST WAY TO COMBINE...
May 2nd, 2008 06:13 PM
by KARL DEWEY Go to last post
3 152
Union Query Removing records by Emma Aumack
Does anyone know why a union query would remove records? I have three data tables that I combine to get total sales and for some reason when I use the union...
May 2nd, 2008 05:47 PM
by Emma Aumack Go to last post
4 153
combining 2 fields that are in the same column, into 1 field by Freida
I need help writing a query based on Diag codes. If I get a claim with 9 diag codes, then my table will show that claim 9 times(1 for each diag code). I...
May 2nd, 2008 05:08 PM
by Freida Go to last post
4 107
convert to number by Rich[_14_]
When defining a field being used in a query, how do I convert it's format from Currency ( typical ex. $12,575.22), to the straight number 12575.22 ...
May 2nd, 2008 04:29 PM
by Rich[_14_] Go to last post
4 125
Passing parameters via MS Query to Access by Yoam69
I have an Access query that contains a parameter called . When I run the query in Access, it does what I expect...it asks for the value of and then...
May 2nd, 2008 04:07 PM
by Michel Walsh Go to last post
1 105
Delete dups in a table by Dominick D.
Hello, I have a table of 280K rows; in this table, I have many dup rows. It looks like this: 101 102 .. .. 20405 20405 20405
May 2nd, 2008 04:05 PM
by John Spencer Go to last post
3 129
HELP with Query by Robin
Here's my problem: Sales tax= If a customer lives in CA, calculate the sales tax as 7% otherwise calculate sales tax as 5.5%. How can I build a calculation...
May 2nd, 2008 04:05 PM
by Duane Hookom Go to last post
3 138
Using combo box in a form -- how to make drop-down work? by Rachel Garrett
I created a form from a query, and I would like users to be able to select the key field from a combo box in order to find the record they want to edit. I went...
May 2nd, 2008 04:04 PM
by Rachel Garrett Go to last post
3 96
Selecting Distinct Memo Fields by Daffy
I know that an error will occur when setting up a Query to display Distinct records of a Memo field. I also know that there is a work around this, which...
May 2nd, 2008 04:02 PM
by John Spencer Go to last post
1 84
Top 3 of multible catorgies by Ed Jordan
SELECT Patrols.Level, Events., Patrols., Patrols.Troop, !*0.75+!*0.25 AS Expr1 FROM Troops INNER JOIN (Patrols INNER JOIN (Events INNER JOIN Score ON Events....
May 2nd, 2008 03:54 PM
by Michel Walsh Go to last post
2 93
Problem with percentages by Golfinray
I have a table and query for an index. The index runs from .0000 to .995. There can be many different numbers of decimal places, like .333560000 or just...
May 2nd, 2008 03:27 PM
by Michel Walsh Go to last post
2 98
Help with Query by SX
I have a set of data. In the field there are datas such as Diet, Health Diet, Non-Fiction Romance, Health Non-Fiction, Diet Romance, Diet
May 2nd, 2008 02:17 PM
by Jeff Boyce Go to last post
2 98
SharePoint MultiValue Field Data Extraction and UNION Query by Mike Hill
I am trying to extract data from a SharePoint list that are of type multivalue. I am able to extract the data correctly from a single column using .Value in...
May 2nd, 2008 02:10 PM
by Mike Hill[_2_] Go to last post
2 121
Crosstab Qry, column heading, by week number, show "Mar 9-16" by Todd
Below is the query that returns everything I want to see but I wish to have the column headings to be like "Mar 9-16" as that would allow me to copy and...
May 2nd, 2008 01:42 PM
by Ken Sheridan Go to last post
3 122
Crosstab query problem by Bongard
Hi I have a crosstab query that only has two records. It is a very simple query with a sum field that is working for one of the records but not the other. Here...
May 2nd, 2008 02:23 AM
by Bongard Go to last post
6 101
convert zero-length to Null by [email protected]
I am trying to change zero-length strings to Null on a table. How do i do this.
May 1st, 2008 11:31 PM
by KARL DEWEY Go to last post
1 114
Do you have to pay for the translating service on Office? by Othello
I want to translate a document into French do you have to pay World Lingo for the translation or is it a free service?
May 1st, 2008 11:27 PM
by KARL DEWEY Go to last post
1 98
Post New Thread


Display Options
Showing threads 11201 to 11220 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 08:31 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.