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 Replies Views Reverse Sort Order
Transpose rows to columns in Access. by SAP2
I have only 2 fields and want to change rows to column headings. My table looks like this: ColA ColB N1 1 N2 2 N3 3 N4 4 The data...
August 6th, 2007 12:02 AM
by MGFoster Go to last post
4 1,063
Concatenate Text Fields to Date Field by alhotch
I have three (3) columns in a table which represent the month, day, and year. The values in these columns are 04 (month) 21 (day) 2010 (year). I want to...
May 19th, 2010 06:43 PM
by alhotch Go to last post
5 1,053
Query Join Problem by Tom
Hi all, I am trying to join two queries together, but the join is on a normal field in one query to a calculated field in another. The join is working fine,...
May 31st, 2004 09:54 AM
by Tom Go to last post
0 1,044
more dates!!! by brigid
How is this any different than the current code? -----Original Message----- Hi, .... WHERE myField BETWEEN Nz( Nz( StartDate, EndDate), date() ) ...
May 26th, 2004 10:59 AM
by Michel Walsh Go to last post
6 1,041
pivot table by AccessAddict
I can create a pivot table to show data from a query in the view that the user would like to enter the data into. However, the pivot table will not let me...
(Multi-page thread 1 2 3)
September 16th, 2005 07:16 PM
by AccessAddict Go to last post
21 1,041
SQL query showing diff between actual and budget by Bon
Hi All, I have a table with the following attributes: Customer_Code, Product_Code, Category, Month, Value Where category has the domain BudgetTurnover and...
August 25th, 2005 12:07 PM
by Bon Go to last post
3 1,035
Transpose Access Table / Query by Corey Ryan
Hi Duane, Thanks for your reply. I have been trying to get this to work for a few days without success so I have broken it down to a simple problem. I have a 3...
December 8th, 2009 11:54 PM
by Corey Ryan Go to last post
0 1,031
UNION query question by Dale Peart
This question relates to an earlier post (7/9/04). I am trying to combine all the records of Table1 with all the results of Query 1 and Query2. The tables...
July 14th, 2004 12:26 AM
by Dale Peart Go to last post
6 1,031
Union Query Access 2007 SP2 MSO by Bruce
I have a union query that keeps telling me that there is a data type mismatch. When I first run the query everything is okay and it displays the fields...
May 21st, 2010 10:20 AM
by Bruce Go to last post
7 1,027
Temp Variable for Criteria in Query Design by Chris F via AccessMonster.com
Is there a way to reference a set Temp. Variable in Access 07's query design under criteria. In VBA, I can call a temp variable and use it in a query built at...
June 20th, 2008 01:35 AM
by [email protected] Go to last post
1 1,027
Blank Fields in NOT Null Query Criteria by Steve Stad
Why would a few blank fields show up in a query where I am using 'Is Not Null' in the criteria. The rest of the Nulls are filtered out - but there are 7...
May 28th, 2010 03:19 PM
by KARL DEWEY Go to last post
5 1,026
Random Function for Selecting Records by esn
Hi everyone, This should be simple. I'm trying to pull one random record from each group within a table. The groups are "Units" - geographic areas, and I...
June 1st, 2010 08:19 PM
by esn Go to last post
5 1,025
Run time Error 3035, System resource exceeded by Ryan
I have this union query in access which produces a Run Time 3035 System Resource Exceeded error. If I remove one of the queries from the Union it works, but...
December 3rd, 2008 09:58 PM
by Ryan Go to last post
4 1,020
Struggling with append query by KJ
I was trying to execute an append query that gets input parameters from a form using a macro but I think what Help just told me is that I need to use the DoCmd...
June 2nd, 2004 05:15 PM
by John Spencer (MVP) Go to last post
2 1,017
Crosstab queries, and null values by Edwinah63
Hi everyone, I have a crosstab query attached to a graph on a report. It shows quantity of widgets produced by each employee for a specified period. The...
May 21st, 2010 02:28 PM
by John Spencer Go to last post
3 1,014
Query Running Balance by Abdul Shakeel[_2_]
I am using the following query to create running balance at every change of Invoice Number but no luck, here Invoice Number is a text field SELECT...
May 31st, 2010 02:33 PM
by Abdul Shakeel[_2_] Go to last post
4 1,009
A field (string) is into other field (string) by Victor2020
Using 2 tables I want to get the rows that match where the content of the field (string) is equal or is into other field (string) from other table.
June 5th, 2010 02:15 PM
by Marshall Barton Go to last post
2 1,009
Calculate "week-ending" date by Mona-ABE
In an Access query, I'd like to have an expression that takes the current day of the week (Sun through Sat) and returns the date for Saturday (in "Short Date"...
November 22nd, 2005 06:15 PM
by Mona-ABE Go to last post
4 1,003
adding a Carriage Return or Line Feed character to an update query by Paul
I'm building an update query that will concatenate two fields and update the first field with the combination of the two fields. However, I would like to...
May 26th, 2010 01:37 AM
by Paul Go to last post
3 1,000
No data returned from query by gchichester
I can't seem to figure out why this query will not return any data. SELECT AsiaContracts.AsiaContractShipper,...
May 18th, 2010 06:42 PM
by KARL DEWEY Go to last post
1 999
Post New Thread


Display Options
Showing threads 161 to 180 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 05:44 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.