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
Recordset automatically updates by NevilleT
I am updating some records using a standard VBA function. I want to create a history record to show the old and new values. The approach I used was to create a...
February 20th, 2007 12:35 PM
by NevilleT Go to last post
2 187
ERROR: aggregate function? by musosdev
Hi, I wonder if someone could help. I'm trying to run the following query on an Access database.. SELECT Stories.StoryTitle, COUNT(Comments.CommentID) AS...
February 20th, 2007 11:38 AM
by musosdev Go to last post
4 127
Round 4 decimals up by Pilgrim
Hello, Using MS 2002. I know this is spelled out below but - need a liitle help. I have records that have a cost field out to 4 decimals (12.034). I would...
February 20th, 2007 10:38 AM
by Jamie Collins Go to last post
4 150
Export filename being trancated to 8 letter by Peter Tickler
When exporting queries to DBF (Dbase IV) format, the filename is suddenly being truncated to 8 letters. I am using Access 9.0.7616 Sp-3. Is this the result...
February 20th, 2007 10:11 AM
by Peter Tickler Go to last post
0 126
Ambiguous outer joins by gmore
Hello folks! I've got a problem. I guess it's why we always come in here when that's the case :) I have three tables as follows: SIR (PK : id) SIR_D (PK :...
(Multi-page thread 1 2)
February 20th, 2007 09:49 AM
by Jamie Collins Go to last post
11 327
Free Flash Games by Flash Games
Free Flash Games http://www.clipplay.com/ fun videos games and more. Fun flash games. Free flash games videos and more.
February 20th, 2007 01:50 AM
by Flash Games Go to last post
0 186
Add 1 when T/F fields are true by Rod
Hello, I have a field, . I have 6 true/false fields, , , , , , and . I would like to count the number of time is true and store that value in . My...
February 20th, 2007 01:49 AM
by Allen Browne Go to last post
2 110
Add to Data by LindaC
I have one form I am using for users to enter info on their archive records. They will input all fields except the location in the warehouse where their...
February 20th, 2007 12:14 AM
by Smartin Go to last post
1 107
calculating "how many" months by buckpeace
If I have 2 fields (DOB) and (service date) How woudl I calculate the number of months between them? I need to use an access query to calculate that. ...
February 19th, 2007 11:50 PM
by raskew via AccessMonster.com Go to last post
3 303
Change background colour on form with tabs by Anna
I am using Access 2003. Have created a database and trying to customise the format of an input form that uses tab controls. Can anyone help with how I can...
February 19th, 2007 10:40 PM
by Anna Go to last post
0 134
Removing duplicate items within a category by Mtnbiker
Hi, I have a table which appears below: ITEM PRICE DATE Paper clips 0.89 2/2/06 Paper clips ...
February 19th, 2007 10:13 PM
by John Spencer Go to last post
1 119
Repeated Data by K
Good day, I have two query’s that are linked together to generate information from two different tables and return the information into one query. Table 1...
February 19th, 2007 10:03 PM
by Duane Hookom Go to last post
7 150
Figure months from a anchor date by buckpeace
Lets say a child was born on 5-15-2004. (dob = Field 1) There is an immunization SERVICE date (Field 2) of 5-18-2005 I need to write a query that will show...
February 19th, 2007 09:48 PM
by Marshall Barton Go to last post
2 127
Make Table query from a Linked Table by conrad
Hello all, I am trying to create a Form with a command button that executes a "Make table" query with "date" criteria "Between !! And !!" that references...
February 19th, 2007 09:45 PM
by Marshall Barton Go to last post
2 113
query for Max date and previous date for report by DJTI via AccessMonster.com
I am stuck on a subform and need help or guidance. If I am going the wrong direction, someone help aim me in the right direction. :-) The report needs the...
(Multi-page thread 1 2)
February 19th, 2007 08:22 PM
by DJTI via AccessMonster.com Go to last post
13 225
Append Query by Red via AccessMonster.com
Good day everyone, I have an append query that is mis-behaving. When I view the query it shows the correct records that should append but when I actually run...
February 19th, 2007 05:22 PM
by Red via AccessMonster.com Go to last post
4 214
Creating a due date but exclude Bank holidays and weekends by sdg8481
Hi, I'm trying to create a Due Date based on a date plus a certain number of days, however i want to count only business days and also to exclude...
February 19th, 2007 04:45 PM
by Jamie Collins Go to last post
3 132
Expression on a report by oxicottin
I have an unbound text box with the expression =Sum(). I want to categorize by text box . For example, the sum of shift 1 is 12 hours, shift 2 is 24 hours,...
February 19th, 2007 04:17 PM
by oxicottin Go to last post
6 111
Now it works... now it doesn't... What is up with this query by John T Ingato
I have a query that was written a while ago that used a temp table which was deleted. I would like to use this query again. So I replaced the temp table's...
February 19th, 2007 02:30 PM
by Gary Walter Go to last post
3 163
WHERE AND OR by Tamal
Dear Sir I have to select from the field EXCHNG_CODE containing GMV or MBH and frm_dt contain 01/01/1986 or 01/01/1995. I have written in the quary as...
February 19th, 2007 08:54 AM
by raskew via AccessMonster.com Go to last post
2 132
Post New Thread


Display Options
Showing threads 20021 to 20040 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 07:46 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.