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
Calculations based on cross tab intersection values by Carlee
Hi there, I have created a cross tab query that gives me a serious of values based on a column and row intersection. Question: I need to make addition...
February 26th, 2007 12:15 AM
by Duane Hookom Go to last post
3 138
Help updatecommand not updating by Fendi Baba
I wrote to his of code to update a staus field ina table. Somehow nothing happens though no error was thrown eitheie. Where did I go wrong? Please help....
February 26th, 2007 12:12 AM
by Gary Walter Go to last post
1 141
ORDER BY help needed by cinnie
Hello to all Lets say I have a query like this... SELECT P.CustID, P.CustName, P.A1, P.A2, P.B1, P.B2, ... FROM ............ AS P WHERE ........... ORDER BY...
February 25th, 2007 09:55 PM
by Rick Brandt Go to last post
4 128
SQL UPDATE Query doesn't Update Table by Andy6
Can anyone see why my Update query doesn't Update the table 'DiaryDates' This function is called on the 'ON EXIT' event of each text box on my 8 day diary...
February 25th, 2007 09:29 PM
by Andy6 Go to last post
5 143
query not giving results but with no error? by oxicottin
Hello, I have a query that gets information from a tbl_AttendanceData which has 3 fields. (Field 1) Employees Name "Text" (Field 2) Attendance Code "Text"...
February 25th, 2007 09:17 PM
by John W. Vinson Go to last post
1 143
AS question by cinnie
This is my second post in 10 minutes - hope that's OK! My query has several similar calculated fields called PRank, QRank, RRank, ....etc. Here is part of...
February 25th, 2007 08:22 PM
by John Spencer Go to last post
1 152
Access 2003 : Numbering alarms by PermitNo so that after 365 days of the last number 1, the count returns to 1 by Céline Brien
Hi everybody, FormPermit with SubFormAlarms writing in QryAlarms. The form describe the owner of a permit for an alarm. The subform the list of false alarms...
(Multi-page thread 1 2)
February 25th, 2007 05:33 PM
by Céline Brien Go to last post
12 268
Referring to a text field in SQL by Steve
Hi, This function with SQL statement parameter works fine when the field MRN is a number field but it does not work when MRN is a text field. How do I refer...
February 25th, 2007 03:48 PM
by Jeff Boyce Go to last post
1 152
Query to update table fails by Steve S
I am trying to update a field in a table with the first corresponding value in a small (30-40 records) subset of records in the same table. Before the...
February 25th, 2007 12:07 PM
by Gary Walter Go to last post
4 148
Text Export needs CR/LF at end - how to?? by willjs
Using Access 03 - Exporting table to Text with ~ delimiter. Receiving system is Unix and requires CR or LF to separate the records as it reads - currently it...
February 25th, 2007 08:41 AM
by John Nurick Go to last post
4 161
Do I need to separate queries for this... by Dave
I have a Access 2003 parameterized query that is called from a web page. The parameter passed to the query is an integer primary key. If no id key is...
February 25th, 2007 06:56 AM
by John W. Vinson Go to last post
1 145
Two Out Of Three Ain't Bad... by Bill Foley
Have sort of a strange request (I guess) and was wondering if it was possible. Access 2003. I have three tables imported from an Excel spreadsheet that have...
February 24th, 2007 11:36 PM
by Bill Foley Go to last post
4 158
query results to columns in excel by Ian
Can anyone tell me how to structure a query or output to turn two tables into a single row in excel: I have one table with contractID in it that has a one...
February 24th, 2007 07:14 PM
by Ian Go to last post
3 143
How to use a function in a query by Zeunasc
I found a query while searching the newsgroups that I think will accomplish exactly what I want. I will include the function after I finish this post. ...
February 24th, 2007 07:07 PM
by fredg Go to last post
1 159
Access 2000 Workgroup Administrator by Albert
On Monday I may have to advise someone 200 miles away on how to use Workgroup Admin on Access 2000 without ever having seen the package and without it in...
February 24th, 2007 03:57 PM
by Albert Go to last post
2 133
Pivot Query ?? by Devlin
I am using a pivot query to display totals by year and transaction type. Example: 2000 2001 2002 TransType1 3,000 ...
February 24th, 2007 03:32 PM
by John Spencer Go to last post
1 174
Please help with Comparing tables!!! by totallyconfused
I am in a pickle!! I have two tables that I update. However, I did not update a couple of fields. Now I have to go back and compare table B against table...
February 24th, 2007 01:59 PM
by Gary Walter Go to last post
4 139
Getting % As Total A97 by Kahuna
Hi Folks - using the following query I calculate a total area based on three criteria. SELECT qryFabricCondition.fc_base_year1 AS ,...
February 24th, 2007 11:10 AM
by Kahuna Go to last post
2 122
Finding Overlapping Data from a Table by FG
I have an Access table that contains just over 200 groups of data identified by a unique # for each. Each group has monthly dates, and twenty-five columns of...
February 24th, 2007 09:17 AM
by FG Go to last post
3 139
What queried should I use??? by lee
Hello! As you can see, I have vendors listed as below in vertical format (vendor 1, vendor 2,vendor 3). And I also have accounts across (100000, 100001,...
(Multi-page thread 1 2)
February 24th, 2007 07:01 AM
by John W. Vinson Go to last post
13 194
Post New Thread


Display Options
Showing threads 19881 to 19900 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:56 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.