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
How Many Employees Were At Work At 10:00am? by tbl
Employee StartTime and FinishTime are stored, and I'd like to make a query that will show the number of employees present for each hour during the...
November 22nd, 2006 04:22 AM
by tbl Go to last post
5 93
Append Query by QC Coug
I have a make table query and an append query table. The append query table is not appending the amount, but it is appending everything else. The formats...
November 22nd, 2006 03:54 AM
by Duane Hookom Go to last post
1 69
different value formats in crosstab by Jeff C
I have built a union query of 8 different calculations and then transformed this into a crosstab query with the month as the column, a label as the row and...
November 22nd, 2006 03:29 AM
by Allen Browne Go to last post
1 88
Update Query Problem by Nick Bradbury
Hi Everyone I am having difficulty in creating a query that will update the status of an order on completion of all the order details, I have pasted the SQL...
November 22nd, 2006 02:04 AM
by Jeff Boyce Go to last post
5 161
Fiscal Months Query by Nanette
I have Fiscal Months that are very strange. i.e. November 2006 is from October 23 through November 19, 2006. I need to sort dates by Fiscal Month and sum the...
November 22nd, 2006 01:58 AM
by Nanette Go to last post
8 146
Week Ending Date by Baffee
I have a subquery that I use in a crosstab quety. The subquery takes the billable hours for each employee for the period from 1/1/06 to 4/29/06. It looks...
November 22nd, 2006 12:37 AM
by KARL DEWEY Go to last post
1 69
Use combo box to set parameter for query by Joanna
I know how to create a parameter query, but is it possible to get the dialog box that it invokes to display a drop-down list of potential values instead of...
November 22nd, 2006 12:33 AM
by Joanna Go to last post
2 87
Access 97 Correlated Updates by Roger
Does anyone know how to do something like this in Access 97? UPDATE tableB SET date_ferment_completed = EXISTS ( ...
November 22nd, 2006 12:08 AM
by Roger Go to last post
8 105
Average Days by Charles Phillips
Hello, I have a form in MS-Access 2003, that has 2 date field. 1. Date Survey Sent 2. Date Received Survey Response I maybe stating this wrong, so please...
November 21st, 2006 11:53 PM
by Charles Phillips Go to last post
5 129
Amount of time between records by chowda
Hello. I have a table that I need to add a column that shows the time difference(in minutes) between records. ID date 1 4/15/06 11:30 PM 2 4/15/06 11:00...
November 21st, 2006 11:30 PM
by Michel Walsh Go to last post
4 92
Req Help with Crosstab query by pottymouthed
Assuming I have 2 tables. t_sexes sex_ID Sex_Name 1 Male 2 Female and
November 21st, 2006 11:19 PM
by David F Cox Go to last post
1 83
form1 OR form2 parmeter box problem by Lez
Hi Guys, I have a report that I want to use from 2 different forms and have added in the criteria section: .. or .. The problem is if using either form a...
November 21st, 2006 11:12 PM
by Duane Hookom Go to last post
2 81
Create a table with an autogen field using SQL by kramer31
Can anyone tell me how to create a table a table with an autogen field? I can do this to create a table CREATE TABLE Employee ( Name varchar(50), Age int(3)...
November 21st, 2006 09:49 PM
by kramer31 Go to last post
3 224
Strange Situation by Lori
Okay, everytime I think I'm done... I have a table for contract changes. This table fits in the value of the change. In the query I have the change table...
November 21st, 2006 09:47 PM
by Lori Go to last post
2 92
web by Dan @BCBS
I've been using Access a very long time but never had the need to create an access page for users on the intranet. I just put one out for my users to enter...
November 21st, 2006 09:33 PM
by Dan @BCBS Go to last post
2 55
DLookup Function by QC Coug
In one table I have a transaction date, in a second table I have the closing dates for the accounting periods. In the same table as the closing dates I have...
November 21st, 2006 09:31 PM
by Klatuu Go to last post
3 68
November 21st, 2006 09:24 PM
by Anthony Go to last post
1 90
Pivot question by PEJO
Assuming I have 2 tables. t_sexes sex_ID Sex_Name 1 Male 2 Female and
November 21st, 2006 09:21 PM
by pottymouthed Go to last post
1 61
Customer Query by LiquorGuy via AccessMonster.com
Hello, I am trying to run a query that lists all my clients, their invoice totals, and total payments thus far. I have created two separate queries. ...
November 21st, 2006 09:13 PM
by QC Coug Go to last post
1 112
Date and Time Query by Matthew P
I have been browsing around here looking for a solution to this problem for a bit now and thought I might just try asking directly and see if someone can...
November 21st, 2006 09:04 PM
by Matthew P Go to last post
2 78
Post New Thread


Display Options
Showing threads 22101 to 22120 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:34 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.