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
Runtime Error 3079 by Little Penny[_3_]
I trying to create a query that will that show me all the records in the tbl_OperatorLogJobData that that have a value greater than 2000 in the link table...
March 8th, 2010 03:44 AM
by Little Penny[_3_] Go to last post
2 224
Help ! by Yaar75
Novice to Access, so apologies for daft question I need to clean up the record. address quoted with house number ie 25 Connaught Street 253 Ellis...
March 8th, 2010 01:32 AM
by Yaar75 via AccessMonster.com Go to last post
5 249
mdb file by Eitan
Over the years I have assembled in ACCENT a database called "Music Archive", to which the latest addition was made in January 2009. Now, when I wish to open...
March 7th, 2010 10:55 PM
by John W. Vinson Go to last post
1 168
pivot table calculations by Bibi
I have not done much in pivot tables. But I have designed a pivot table form that does all I need except for the last step - creating a column to show a net...
March 7th, 2010 06:54 PM
by Bibi Go to last post
0 173
How do I access multiple records within a query? by Hirsutus
I am trying to calculate the total quantity of components in a nested Bill Of Materials where the true quantity of any sub-level component is dependant on...
March 7th, 2010 05:01 PM
by KenSheridan via AccessMonster.com Go to last post
1 251
mdb file by Eitan
Over the years I have assembled in ACCENT a database called "Music Archive", to which the latest addition was made in January 2009. Now, when I wish to open...
March 7th, 2010 03:59 PM
by Eitan Go to last post
0 202
Calculating the days in a month by Leo
I have a Control which is a Date field named 'NEWTOPD'. Based on the date entered in the field it calculates the days offor the whole month making amends...
March 7th, 2010 02:12 PM
by John Spencer Go to last post
3 172
howto copy only newer OrderID data(and the other fields) from onetable to another table by Bartus[_2_]
howto copy only newer OrderID data(and the other fields) from one table to another table So the new table is updated only with the new OrderID and...
March 7th, 2010 08:44 AM
by Bart[_4_] Go to last post
7 253
Criteria in append querie by Bart[_4_]
I want to append only non existing ClientID fields into the destination table. Client ID is not a primairy field because it is a import file...
March 7th, 2010 08:42 AM
by Bart[_4_] Go to last post
3 216
how to run onhand value report by junebugg
I get the message enter parameter when entering the zoom feature
March 7th, 2010 03:39 AM
by John W. Vinson Go to last post
1 199
two criteria in DLookup by Song Su[_4_]
No error when compiling but when open form, got 'type mismatch'. Here is the code: Private Sub Form_Load() If DLookup("", "users", "Trim() = '" &...
March 7th, 2010 01:54 AM
by Song Su[_4_] Go to last post
5 273
Query to Include cboSymbols or ‘*’ by ryguy7272
For the past four hours I’ve been at this; still no solution! Argh!! I now yield to the SQL experts. I have two small loops that run through a ListBox...
March 6th, 2010 05:17 PM
by ryguy7272 Go to last post
4 349
Query Records in Linked table by Little Penny[_3_]
I have a Left Join query to find all the record in the tbl_LogJobData that do not have link records in the tbl_Check. Tables tbl_LogJobData and tbl_Check are...
March 6th, 2010 03:15 PM
by John Spencer Go to last post
4 230
QUERY by igg via AccessMonster.com
any query to get from tableA to tableB?. tableA: author titlea titleb vol1 sold count date share comment a b c 10 ...
March 6th, 2010 03:11 PM
by John Spencer Go to last post
2 182
Access 2007 - Date Serial by Cettina
I want to set up a criteria for the Date Serial where I want to be able to run a report that will allow me to enter a date and then be able to tell me what...
March 6th, 2010 01:14 AM
by KARL DEWEY Go to last post
2 170
Why does MSAccess cut query after 2886000 records by PhilK
We have a large database (Access 2007 on XP) with a data table containing over 10 million records. We have a series of queries and observed that one query...
March 5th, 2010 08:49 PM
by Jerry Whittle Go to last post
1 255
divison by zero error by khanner
this never used to show up till now. 'Compute Appraisal Value If BBG("Orig# LTV").Value 1 Then ltv = BBG("Orig# LTV").Value Else ltv = BBG("Orig#...
March 5th, 2010 07:41 PM
by Jerry Whittle Go to last post
1 227
Calculating Values in a Query by tsquared1518
I have 4 fields in a query, Drawing Dim., Tolerance, Upper Limit, and Lower Limit. I am trying to calculate the Upper and Lower Limit fields by taking the...
March 5th, 2010 07:12 PM
by John W. Vinson Go to last post
8 327
Using Combo Boxes as a Source for Parameter Queries by venajoe
Access Gurus, I often encounter a situation where I want to run a select (parameter) query on a particular table, but instead of having the user type in...
March 5th, 2010 06:10 PM
by John Spencer Go to last post
2 467
query to trim name field? by Cam
Hello, There is a name field (last, first) in my query that I would like to create a new field that only return the last name. What is the proper function to...
March 5th, 2010 06:08 PM
by John Spencer Go to last post
5 237
Post New Thread


Display Options
Showing threads 961 to 980 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 11:58 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.