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 Replies Views Reverse Sort Order
Looping through data with calculations by clalc
I have to loop through the data from one table (demand) and calculate total supply expected depending on the data from the other tables, here is example and...
June 7th, 2010 02:34 PM
by vanderghast Go to last post
1 5,548
Time and Attendance System Query by Dan Young
I am attempting to query a time and attendance database (Attendance Enterprise by Infotronics) to determine the hours worked for any range of time periods,...
March 7th, 2006 10:01 PM
by Dan Young Go to last post
2 3,860
Create A "Check Register" in Access by LauraK
I have a user who wants to keep track of an account balance in Access...similar to a check register. She wants to enter amounts and have them add/subtract...
November 9th, 2006 07:32 AM
by Peter Yang [MSFT] Go to last post
3 3,343
Bitwise And by Sam Hobbs
I have the following in a module that works: Const DB_SYSTEMOBJECT = &H80000002 Public Function IsSystemObject(Flags) IsSystemObject = (Flags And...
(Multi-page thread 1 2 3 ... Last Page)
October 14th, 2004 04:19 AM
by david epsom dot com dot au Go to last post
44 2,969
create a table within an access2007 database using code in a vb.net app ? by Aussie Rules
Hi, Is it possible to create a table via code (create table ........) in an access 2007 database from a Vb.net 2008 application? Any tips/samples/links on...
February 14th, 2008 09:51 AM
by Allen Browne Go to last post
1 2,888
Appending data from one table to multiple relational tables by Stranger
Situation: Computer inventory is currently in one table. I have created a new database with several tables related together for the new inventory database. ...
(Multi-page thread 1 2 3 ... Last Page)
August 18th, 2004 02:55 AM
by Stranger Go to last post
42 2,866
Action Query (Append) didn't add records due to key violations. by Nick X
Hi all, I am using MS Access 2007 as front-end and SQL Server 2005 as back-end. In SQL Server I have a PK plus a multi-field index that is unique. I can add...
March 22nd, 2010 06:05 PM
by Nick X Go to last post
7 2,762
Access Subtotal in Query by scott
I have a simple query that uses 3 fields. Location, Person and Value. When I group by location and person and sum value, I get all the results I need but I...
May 12th, 2010 11:36 AM
by Bob Barrows Go to last post
3 2,590
Need query to separate 2 entry types in a table field by Jan Il
Hi all Access 2002 XP - Windows 2000 SP4 I now have a field in a table that records both Checks and Debit Card transactions. I would like to be able to sort...
(Multi-page thread 1 2 3 ... Last Page)
November 23rd, 2004 06:57 PM
by Steve Schapel Go to last post
31 2,581
UNION ALL Query by Brook
To All: I am trying to joing two tables with the same data fields using the UNION All query. My two tables are tblCustomOrders and tblStockOrders and I would...
(Multi-page thread 1 2 3 ... Last Page)
August 1st, 2004 01:07 AM
by Ken Snell Go to last post
42 2,554
Delete Query Does Not by Ron Le Blanc
I have a database that won't let me delete records using a Delete Query. I have an Access 2003 database that has several tables in it that are all related to...
(Multi-page thread 1 2 3 ... Last Page)
February 16th, 2006 09:56 PM
by Ron Le Blanc Go to last post
33 2,454
General solution for missing sequence numbers by Peter Danes
I occasionally need to determine a number that I don't have in a sequence, either the first missing one in a gap in a set of sequential numbers or the next one...
(Multi-page thread 1 2 3 ... Last Page)
December 8th, 2005 04:14 PM
by Peter Danes Go to last post
33 2,449
ympäristöinsinöörin prosenttilaskua by Pekka Kruger
01.05.2008 Jää historian kirjoihin erityispäivämääränä josta alkaa ydinalan vaikeudet kasautumaan aivan erityisesti myös Suomessa. Jo siitä asti...
November 21st, 2008 01:00 PM
by Pekka Kruger Go to last post
0 2,426
Syntax error in CREATE TABLE statement. (Error 3290) by zufie
I am trying to Create a table from DDL code. Upon running the query I get the error: Syntax error in CREATE TABLE statement. (Error 3290) Here is my code...
May 24th, 2010 05:11 PM
by Bob Barrows Go to last post
2 2,371
SelectCase statement by dtoney
I'm trying to calculate the business week by looking at logdate. Below is the entire syntax for the select query with the case statement indented for easier...
January 5th, 2010 05:50 PM
by Clifford Bass via AccessMonster.com Go to last post
7 2,308
"Screen Scrape" by PC Datasheet
Does anyone know how to do a "screen scrape" to get data off a website and enter it into an Access table? Thanks for all help? Steve PC Datasheet
(Multi-page thread 1 2 3 ... Last Page)
January 27th, 2005 12:15 PM
by Darryl Kerkeslager Go to last post
64 2,284
trying to minimize Write Conflicts in a multi-user database by Paul
I have a multi-user Access 2003 database and lately a number of our users are running into the Write Conflict message gives them the choice to either Save...
(Multi-page thread 1 2 3 ... Last Page)
January 22nd, 2010 09:07 AM
by Paul Go to last post
51 2,244
Likert Scale data- how to enter in Access by Struggling graduate researcher
I have created a database to record responses to a questionnaire in which respondents must answer YES, NO or I Don't know for each question. For EACH...
September 23rd, 2008 02:52 AM
by Struggling graduate researcher[_2_] Go to last post
4 2,235
April 6th, 2010 03:43 AM
by John W. Vinson Go to last post
2 2,086
Use first record found in expression? by CASJAS
My calculation is coming up with two different values for the following SQL: SELECT A.ID, A.Site, A., A., A., ((C.-B.) /(C.-B.))
(Multi-page thread 1 2)
July 22nd, 2004 09:21 PM
by Tom Ellison Go to last post
17 2,065
Post New Thread


Display Options
Showing threads 21 to 40 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 02:23 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.