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
Copying data from one table to another by sexton75 via AccessMonster.com
I have a Sales Branch Audit database in development. I have all sales branch information contained in a separate table (i.e. address, city, state, etc.). The...
June 30th, 2008 04:09 PM
by Jeff Boyce Go to last post
3 204
Why do queries automaticly rearange columns? by Frank1927
Why are columns are in a different sequence each time I run certain queries and how can I stop it?
June 30th, 2008 03:44 PM
by Stephen K. Young Go to last post
5 161
help with a query by Nuno Gomes
Hello all, I have table Customer with the field CP I have the table Cpostal with the field CP_NUM The relation between this two tables is Customer.CP 1-N...
June 30th, 2008 03:35 PM
by KARL DEWEY Go to last post
1 199
Ungrouping in DSUM by acss
I created a query that works well using DSum , grouping and percentages yet i can not figure out how to target a specific period by date since it breaks up...
June 30th, 2008 02:39 PM
by acss Go to last post
4 180
Filtering for "Not Something" by Emma Hope
I have one table which contains all my contacts i.e. fields ContactID & Name and a second table containing tasks, i.e. fields ContactID & Task. So for...
June 30th, 2008 01:41 PM
by Bob Barrows [MVP] Go to last post
5 181
Using Filter by Form to create a Query and then a Report by HWhite
Somebody has told me that they would like to generate their own reports in Access. This person does not know access at all, so I need to come up with a way...
June 30th, 2008 01:22 PM
by Allen Browne Go to last post
6 159
Time difference between multiple times and dates by [email protected][_2_]
I am having a problem working out the logic for sorting out a date series that includes times as well. I have some data that looks at computer uptime, and I...
June 30th, 2008 01:13 PM
by Allen Browne Go to last post
1 172
Crosstab query - I need aditional information by Michael
Dear all in a follow up to another query I have run a crosstab query which has given me the seperation of information I needed however as always I need...
June 30th, 2008 12:43 PM
by John Spencer Go to last post
1 229
pivot chart legend shows "Sum of" by matthijs
Hello, I have a query that I want to show in the pivot chart view. The legend shows the field with "Sum of" in front. Even when I use an alias the "Sum of"...
June 30th, 2008 11:20 AM
by matthijs Go to last post
0 185
Unmatched Query creativity needed - date field by Jane Schuster
I have a table that contains ClientId and ScheduledDueDate (each Client must submit a plan within 2 days on either side of the ScheduledDueDate), this table...
June 30th, 2008 12:43 AM
by Jane Schuster Go to last post
5 298
Limiting the time in a Query by Julian
The exam site here has a Query in it which is mostly simple http://www1.edexcel.org.uk/spbs2007/d201/html/SPB201MusicULike.htm It also wants to restrict the...
June 29th, 2008 09:24 PM
by Julian Go to last post
8 250
Continuous Form Loading Problem by sexton75 via AccessMonster.com
I have a continuous form that has a combo box based on another field. That is not the problem. The weird thing is that when I am in the form adding data, the...
June 29th, 2008 09:06 PM
by Wolfgang Kais[_3_] Go to last post
3 214
Transform Access SQL to SQL server 2005 or SQLExpress by Juan Robledo
I need help about this crosstab query that works fine in an AccessDataSorce (Asp.net 2.0) Now i'm trying to pass all the web to sqlDataSource and i have...
June 29th, 2008 07:22 PM
by Juan Robledo Go to last post
8 223
Running Sum Error in Query by NEWER USER
I have read several posts and can not figure out where I have gone wrong - ANY HELP appreciated. I get an #Error in the RunSum Column of my query...
June 29th, 2008 06:36 PM
by Duane Hookom Go to last post
7 174
Count Check boxes and create short report by goodkitty
I have a database that has on one of the tables a selection of 19 checkboxes (for Yes/No Fields). I want to create a report that allows me to just have a...
(Multi-page thread 1 2)
June 29th, 2008 05:27 PM
by Ken Sheridan Go to last post
10 403
Parameter Query Problem by CollegeTry
This is for a simple database I'm creating at home for my daughter to help her in her college search. I have 5 columns in the DB: College Name, and then four...
June 29th, 2008 02:58 PM
by raskew via AccessMonster.com Go to last post
7 162
Date Format by Jim
I am working with a government database that has a number field that contains date information formatted to read 20080623. I am trying to get the difference...
(Multi-page thread 1 2)
June 29th, 2008 02:57 PM
by Jeff Boyce Go to last post
14 277
Time Difference 24 Hours by Jane Schuster
I need to determine the difference in hours between two events. DateDiff("d" ,) gives me the difference in days...
June 29th, 2008 08:01 AM
by Jane Schuster Go to last post
2 161
Complex for me but may be a very simple query for you experts. by knavlekar
I have four tables. I have not included all the fields and all the tables but the fields that I thought that are important for the query. 1) Orders: ...
June 29th, 2008 03:59 AM
by knavlekar Go to last post
2 236
SQL Syntax by JString
Need help with an append query statement that's being run from VBA and generates an error: INSERT INTO (Fields,Operators,Values) VALUES ("PLAINTIFF", "=",...
June 28th, 2008 10:57 PM
by JString Go to last post
5 189
Post New Thread


Display Options
Showing threads 10161 to 10180 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 06:15 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.