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
Calculation on incrementing record. by Phil
I have a probably simple question. I have a db with a usage field that increments daily. When I query it I want to find out the difference in the usage...
January 12th, 2007 12:50 AM
by Phil Go to last post
5 239
Parameter?? by Jani
Need help - have no idea on how to do this & am concerned that I should have built table differently. On a form are fields where associates enter in budget...
(Multi-page thread 1 2)
January 12th, 2007 12:18 AM
by Smartin Go to last post
10 379
Help - Query too complex by MN
Hello, Please help with this one: Sum(IIf( .=1 AND .=True,1,0)) AS RF0 I got an error! Please Help - Thank inadvance. MN
January 11th, 2007 11:49 PM
by John Vinson Go to last post
3 162
Tool Tips In Data Access Pages by RAMON
I have a data base which displays allot of data via data access pages. The reports share some of the same fields and field names. I would like to use the...
January 11th, 2007 10:49 PM
by RAMON Go to last post
0 188
changing student record based on previous record by Ward Deutschman
I have a table with some identical records except for email addresses, and I want to put the email addresses for one student into a single record, so I have...
January 11th, 2007 10:20 PM
by Ward Deutschman Go to last post
2 208
Update Query by Novice2000
Hi, I have a table with numbers that have -000 at the end and I would like to remove that. Example 01028632-000 to 01028632 Can this be done?
January 11th, 2007 10:17 PM
by John Spencer Go to last post
3 181
hyperlink by geebee
hi, I would like to have the user be able to click on a textbox, and have it be a hyperlink. The Hyperlink address would be the value of that in the...
January 11th, 2007 09:22 PM
by geebee Go to last post
0 144
Double criteria in one field by Thibodeau
My company has 18 locations and I want to make 18 reports to control there inventory to the exact items that is in each store. My idea behind this was in...
January 11th, 2007 06:45 PM
by Jeff Boyce Go to last post
5 232
can't update all the records-PROBLEM by cervantes008
I am trying to update a number field with / (-) and I keep getting the "can't update all the records" Error message. When I have only "-," it works fine, but...
January 11th, 2007 06:04 PM
by NthDegree via AccessMonster.com Go to last post
2 160
Using the result of a calculated field in another calculated field's expression by Paul
I am stuck on something that seems fairly straightforward but haven't found a solution anywhere! I understand that calculated fields are temporary and the data...
January 11th, 2007 05:53 PM
by John Spencer Go to last post
3 158
Show all records by tanhus
I have 2 tables Table1 contains with all the deal numbers Table2 contains with a portion of all possible deal numbers and Im trying to make a query that...
January 11th, 2007 05:53 PM
by KARL DEWEY Go to last post
1 138
Query Needs to show in subform by Tammy Wright
Time Cards Subform is in the Time Cards Form. The subform automatically updates the Time Card Hours Table. The subform elements...
January 11th, 2007 04:48 PM
by Tammy Wright Go to last post
0 163
Database closes when running rolling total query by JJEWELL
The following query crashes Access. I can't troubleshoot the code (I don't see anything wrong) because Access just gives me the generic Microsoft "do you...
January 11th, 2007 04:20 PM
by JJEWELL Go to last post
4 276
"Between" Parameter Query not working with DateAdd by Christy Wyatt
I added 7 days to a WkEndDate to come up with the paydate in a query. When I use "Between and to get all the pay days in that month, it gives me the right...
(Multi-page thread 1 2)
January 11th, 2007 03:58 PM
by Van T. Dinh Go to last post
11 321
yes/no box by JKE
I have a table that holds actions pending from visits to branches. This table has a "completed" field which is a yes/no (check) box. I have a query which...
January 11th, 2007 03:39 PM
by Allen Browne Go to last post
1 191
Use Query to find due date by mattc66 via AccessMonster.com
Hi All, I need some help..Some would say allot of help. I have a product that I need to report to our sales department the date of availablity. Example...
January 11th, 2007 03:28 PM
by Jamie Collins Go to last post
4 170
Create New Table not from Query by Hansford cornett
I have a need based on a value in my form to create a new table on the fly and then later append additional data to it. I know how to do the append however...
January 11th, 2007 02:34 PM
by Jamie Collins Go to last post
1 196
Query running forever by minnow
Hi all, I have a table called with the following fields, Text Primary Key Date Primary Key Double Text ...
January 11th, 2007 02:26 PM
by minnow Go to last post
2 153
Variable Select Statement (ASSIST PLEASE) by Hansford cornett
I am trying to write code that will allow the query to make a table when the command button is pressed. The dode I have is as follows please help my time is...
January 11th, 2007 01:31 PM
by Hansford cornett Go to last post
2 139
Problems with IIF by Miranda
Ok, this formula seems to work until all fields in the formula are null in which case it should return OK right?....but it's not. Do you see what I am...
January 11th, 2007 01:14 PM
by Miranda Go to last post
3 126
Post New Thread


Display Options
Showing threads 21001 to 21020 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:09 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.