Track Changes Query

Hi I wonder if someone could help me please with a problem that's been
baffling for a few weeks now.

I am trying to create a query, which in turn feeds a report, that shows
tracked changes. I have previously posted on this forum and got some great
advice that's really helped me along but I'm really struggling with the query
to extract the data. I am relatively new to Access in particular VBA but I am
willing to learn.

What I would like to do is to use a date parameter to extract those fields
with an updated time stamp within a given time period, which in turn I can
show the related updated information with. I've managed to be able to do this
bit of it, but the problem I'm having is with the date pararmeter. If say for
example on a given record I have one field with a timestamp of 02/0/210,
another with the 03/02/10, if I use the 02/02/10-02/02/10 as my date
parameter it will still pull all of the fields that were updated for that
record rather than actually lifting the one field I want from the record.

Can anyone help me please?

Many thanks

Chris

-- 
Message posted via http://www.accessmonster.com

0
hobbit2612
2/6/2010 3:04:05 PM
access.forms 6864 articles. 2 followers. Follow

9 Replies
1471 Views

Similar Articles

[PageSpeed] 58

On Sat, 06 Feb 2010 15:04:05 GMT, "hobbit2612 via AccessMonster.com"
<u27332@uwe> wrote:

>What I would like to do is to use a date parameter to extract those fields
>with an updated time stamp within a given time period, which in turn I can
>show the related updated information with. I've managed to be able to do this
>bit of it, but the problem I'm having is with the date pararmeter. If say for
>example on a given record I have one field with a timestamp of 02/0/210,
>another with the 03/02/10, if I use the 02/02/10-02/02/10 as my date
>parameter it will still pull all of the fields that were updated for that
>record rather than actually lifting the one field I want from the record.
>
>Can anyone help me please?

With a bit more information perhaps. Could you post the fieldnames and
datatypes of the date field, and the SQL view of the query you're trying to
run?
-- 

             John W. Vinson [MVP]
0
John
2/6/2010 5:36:35 PM
Hi John, many thanks for your reply.

What I've done in my table and also included in my query, is to create
another field to contain the date stamp for the changes to my fields, so the
query not only includes the date stamp fields but also the associated fields
that contain the actual data.

All the 'Date...Changed' fields are obviously Date/Time datatypes, the rest
of the fields in the query are as follows:

CRVersion - Text
AdditionalRefNo - Text
CRTitle - Text
Status - Text
LID - Date/Time
DateImplemented - Date/Time

The SQL for my query is as below:

SELECT tblCR.DateVersionChanged, tblCR.DateAdditionalRefNoChanged, tblCR.
DateTitleChanged, tblCR.DateStatusChanged, tblCR.DateLIDChanged, tblCR.
DateImplementedChanged, tblCR.CRVersion, tblCR.AdditionalRefNo, tblCR.CRTitle,
tblCR.Status, tblCR.LID, tblCR.DateImplemented
FROM tblCR;

To allow the user to input the data parameter I have created a Input form and
added this line to the criteria line in the query as an OR statement:

>=[Forms]![frmDateInput]![StartDate] And <=[Forms]![frmDateInput]![EndDate]

However I'm not sure whether this is the problem so I left it out of the
query. 

I hope this helps, and once again many thanks for your help.

Regards

Chris


John W. Vinson wrote:
>>What I would like to do is to use a date parameter to extract those fields
>>with an updated time stamp within a given time period, which in turn I can
>[quoted text clipped - 6 lines]
>>
>>Can anyone help me please?
>
>With a bit more information perhaps. Could you post the fieldnames and
>datatypes of the date field, and the SQL view of the query you're trying to
>run?

-- 
Message posted via http://www.accessmonster.com

0
hobbit2612
2/6/2010 6:15:48 PM
On Sat, 06 Feb 2010 15:04:05 GMT, "hobbit2612 via AccessMonster.com"
<u27332@uwe> wrote:

>What I would like to do is to use a date parameter to extract those fields
>with an updated time stamp within a given time period, which in turn I can
>show the related updated information with. I've managed to be able to do this
>bit of it, but the problem I'm having is with the date pararmeter. If say for
>example on a given record I have one field with a timestamp of 02/0/210,
>another with the 03/02/10, if I use the 02/02/10-02/02/10 as my date
>parameter it will still pull all of the fields that were updated for that
>record rather than actually lifting the one field I want from the record.

waitaminit....

A Query either pulls the entire record, or none of it.

If you want a query to selectively pull some fields and not other fields of a
record, dynamically, you've got a very different problem.

You may need a UNION query to turn each little non-normalized block of data in
your record into a freestanding record.
-- 

             John W. Vinson [MVP]
0
John
2/6/2010 9:26:16 PM
On Sat, 06 Feb 2010 18:15:48 GMT, "hobbit2612 via AccessMonster.com"
<u27332@uwe> wrote:

>SELECT tblCR.DateVersionChanged, tblCR.DateAdditionalRefNoChanged, tblCR.
>DateTitleChanged, tblCR.DateStatusChanged, tblCR.DateLIDChanged, tblCR.
>DateImplementedChanged, tblCR.CRVersion, tblCR.AdditionalRefNo, tblCR.CRTitle,
>tblCR.Status, tblCR.LID, tblCR.DateImplemented
>FROM tblCR;
>
>To allow the user to input the data parameter I have created a Input form and
>added this line to the criteria line in the query as an OR statement:
>
>>=[Forms]![frmDateInput]![StartDate] And <=[Forms]![frmDateInput]![EndDate]
>
>However I'm not sure whether this is the problem so I left it out of the
>query. 

See my reply elsewhere in the thread. If you're expecting the query to pull
only certain fields, you're misunderstanding how queries work! They either
pull the whole record, or nothing at all.

Do post the full SQL with the WHERE clause though, it's certainly part of the
problem. You say "as an OR statement" but I have no idea what you're "or'ing"
it with.
-- 

             John W. Vinson [MVP]
0
John
2/6/2010 9:27:57 PM
Hi,

John,

Please find the whole SQL including the WHERE statement. 

SELECT tblCR.DateVersionChanged, tblCR.DateAdditionalRefNoChanged, tblCR.
DateTitleChanged, tblCR.DateStatusChanged, tblCR.DateLIDChanged, tblCR.
DateImplementedChanged, tblCR.CRVersion, tblCR.AdditionalRefNo, tblCR.CRTitle,
tblCR.Status, tblCR.LID, tblCR.DateImplemented
FROM tblCR
WHERE (((tblCR.DateVersionChanged)>=[Forms]![frmDateInput]![StartDate] And
(tblCR.DateVersionChanged)<=[Forms]![frmDateInput]![EndDate])) OR (((tblCR.
DateAdditionalRefNoChanged)>=[Forms]![frmDateInput]![StartDate] And (tblCR.
DateAdditionalRefNoChanged)<=[Forms]![frmDateInput]![EndDate])) OR (((tblCR.
DateTitleChanged)>=[Forms]![frmDateInput]![StartDate] And (tblCR.
DateTitleChanged)<=[Forms]![frmDateInput]![EndDate])) OR (((tblCR.
DateStatusChanged)>=[Forms]![frmDateInput]![StartDate] And (tblCR.
DateStatusChanged)<=[Forms]![frmDateInput]![EndDate])) OR (((tblCR.
DateLIDChanged)>=[Forms]![frmDateInput]![StartDate] And (tblCR.DateLIDChanged)
<=[Forms]![frmDateInput]![EndDate])) OR (((tblCR.DateImplementedChanged)>=
[Forms]![frmDateInput]![StartDate] And (tblCR.DateImplementedChanged)<=[Forms]
![frmDateInput]![EndDate]));

It sounds as if a Union query is what I will need, could you tell me please,
is this is easy to pull together?


Many thanks

Chris

John W. Vinson wrote:
>>What I would like to do is to use a date parameter to extract those fields
>>with an updated time stamp within a given time period, which in turn I can
>[quoted text clipped - 4 lines]
>>parameter it will still pull all of the fields that were updated for that
>>record rather than actually lifting the one field I want from the record.
>
>waitaminit....
>
>A Query either pulls the entire record, or none of it.
>
>If you want a query to selectively pull some fields and not other fields of a
>record, dynamically, you've got a very different problem.
>
>You may need a UNION query to turn each little non-normalized block of data in
>your record into a freestanding record.

-- 
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201002/1

0
hobbit2612
2/6/2010 9:52:41 PM
On Sat, 06 Feb 2010 21:52:41 GMT, "hobbit2612 via AccessMonster.com"
<u27332@uwe> wrote:

>Hi,
>
>John,
>
>Please find the whole SQL including the WHERE statement. 
>
>SELECT tblCR.DateVersionChanged, tblCR.DateAdditionalRefNoChanged, tblCR.
>DateTitleChanged, tblCR.DateStatusChanged, tblCR.DateLIDChanged, tblCR.
>DateImplementedChanged, tblCR.CRVersion, tblCR.AdditionalRefNo, tblCR.CRTitle,
>tblCR.Status, tblCR.LID, tblCR.DateImplemented
>FROM tblCR
>WHERE (((tblCR.DateVersionChanged)>=[Forms]![frmDateInput]![StartDate] And
>(tblCR.DateVersionChanged)<=[Forms]![frmDateInput]![EndDate])) OR (((tblCR.
>DateAdditionalRefNoChanged)>=[Forms]![frmDateInput]![StartDate] And (tblCR.
>DateAdditionalRefNoChanged)<=[Forms]![frmDateInput]![EndDate])) OR (((tblCR.
>DateTitleChanged)>=[Forms]![frmDateInput]![StartDate] And (tblCR.
>DateTitleChanged)<=[Forms]![frmDateInput]![EndDate])) OR (((tblCR.
>DateStatusChanged)>=[Forms]![frmDateInput]![StartDate] And (tblCR.
>DateStatusChanged)<=[Forms]![frmDateInput]![EndDate])) OR (((tblCR.
>DateLIDChanged)>=[Forms]![frmDateInput]![StartDate] And (tblCR.DateLIDChanged)
><=[Forms]![frmDateInput]![EndDate])) OR (((tblCR.DateImplementedChanged)>=
>[Forms]![frmDateInput]![StartDate] And (tblCR.DateImplementedChanged)<=[Forms]
>![frmDateInput]![EndDate]));
>
>It sounds as if a Union query is what I will need, could you tell me please,
>is this is easy to pull together?

Maybe I'm not understanding the problem.

What - specifically - results do you want to see?

As written this will find all records (and all of each record) where any one
of the date changed fields is within the date range.

You're having difficulty because (as has been said here before...!) your data
structure is WRONG. "Fields are expensive, records are cheap"; if you're
trying to keep a field-by-field audit trail you need a relationship to a
second table with fields such as FieldChanged, DateChanged, and any other
desired info (such as the ID of the person making the change).

Failing that, you can simulate it with a UNION query. You can't do this in the
query design grid, it's a SQL-only operation; you would edit code like

SELECT "Version" AS WhatChanged, tblCR.DateVersionChanged
FROM tblCR
WHERE (((tblCR.DateVersionChanged)>=[Forms]![frmDateInput]![StartDate] 
And (tblCR.DateVersionChanged)<=[Forms]![frmDateInput]![EndDate])) 
UNION ALL
SELECT "Additional Ref" AS WhatChanged, tblCR.DateAdditionalRefNoChanged
FROM tblCR
WHERE (((tblCR.DateAdditionalRefNoChanged)>=[Forms]![frmDateInput]![StartDate]
And (tblCR.DateAdditionalRefNoChanged)<=[Forms]![frmDateInput]![EndDate])) 
UNION ALL
SELECT "Title" AS WhatChanged, tblCR.DateTitleChanged
FROM tblCR
WHERE (((tblCR.DateTitleChanged)>=[Forms]![frmDateInput]![StartDate] 
And (tblCR.DateTitleChanged)<=[Forms]![frmDateInput]![EndDate])) 
UNION ALL

<etc etc through all the fields>
-- 

             John W. Vinson [MVP]
0
John
2/6/2010 10:53:49 PM
Hi John,

Many thanks for your continuing help.

The results I would like to see are only the fields with the date stamp that
the user has keyed in on the entry form and the associated data field. I
guess it's very similar to how you would write a copy and paste macro in
Excel. I want it to look through all the fields picking and taking the fields
that fit within the criteria and pasting them elsewhere.

I think the Union query is perhaps the way to go. I'll have a go at this and
see how I get on.

Many thanks and regards

Chris 

John W. Vinson wrote:
>>Hi,
>>
>[quoted text clipped - 22 lines]
>>It sounds as if a Union query is what I will need, could you tell me please,
>>is this is easy to pull together?
>
>Maybe I'm not understanding the problem.
>
>What - specifically - results do you want to see?
>
>As written this will find all records (and all of each record) where any one
>of the date changed fields is within the date range.
>
>You're having difficulty because (as has been said here before...!) your data
>structure is WRONG. "Fields are expensive, records are cheap"; if you're
>trying to keep a field-by-field audit trail you need a relationship to a
>second table with fields such as FieldChanged, DateChanged, and any other
>desired info (such as the ID of the person making the change).
>
>Failing that, you can simulate it with a UNION query. You can't do this in the
>query design grid, it's a SQL-only operation; you would edit code like
>
>SELECT "Version" AS WhatChanged, tblCR.DateVersionChanged
>FROM tblCR
>WHERE (((tblCR.DateVersionChanged)>=[Forms]![frmDateInput]![StartDate] 
>And (tblCR.DateVersionChanged)<=[Forms]![frmDateInput]![EndDate])) 
>UNION ALL
>SELECT "Additional Ref" AS WhatChanged, tblCR.DateAdditionalRefNoChanged
>FROM tblCR
>WHERE (((tblCR.DateAdditionalRefNoChanged)>=[Forms]![frmDateInput]![StartDate]
>And (tblCR.DateAdditionalRefNoChanged)<=[Forms]![frmDateInput]![EndDate])) 
>UNION ALL
>SELECT "Title" AS WhatChanged, tblCR.DateTitleChanged
>FROM tblCR
>WHERE (((tblCR.DateTitleChanged)>=[Forms]![frmDateInput]![StartDate] 
>And (tblCR.DateTitleChanged)<=[Forms]![frmDateInput]![EndDate])) 
>UNION ALL
>
><etc etc through all the fields>

-- 
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201002/1

0
hobbit2612
2/7/2010 4:37:36 PM
Hi John,

You very kindly gave me a section of SQL code to help me creating a query
that showed tracked changes. Since I got this I've been working with it and
understanding how they work.

I'm now trying to incorporate another field into the query. i.e a record ID
already built into the table just to give the user some more information that
I just can't seem to get to work. I've added the ID field at the beginning of
the code because, well to me it seemed the logical place to put it so the
coding looks like this:

SELECT tblCR.ID, "Version" AS WhatChanged, tblCR.DateVersionChanged, tblCR.
Version
FROM tblCR
WHERE (((tblCR.DateVersionChanged)>=[Forms]![frmDateInput]![StartDate] 
And (tblCR.DateVersionChanged)<=[Forms]![frmDateInput]![EndDate])) 
UNION ALL
etc

The problem is, is that I get an error message that says the 'number of
columns in the two selected tables or queries of a union query to not match'.
Now I'm pretty sure that the error occurs because I know in a Union query the
tables must match in terms of the number of fields, but I'm just not sure
where I can add the ID field.

Could you perhaps point me in the right direction please?

Many thanks and regards

Chris

hobbit2612 wrote:
>Hi John,
>
>Many thanks for your continuing help.
>
>The results I would like to see are only the fields with the date stamp that
>the user has keyed in on the entry form and the associated data field. I
>guess it's very similar to how you would write a copy and paste macro in
>Excel. I want it to look through all the fields picking and taking the fields
>that fit within the criteria and pasting them elsewhere.
>
>I think the Union query is perhaps the way to go. I'll have a go at this and
>see how I get on.
>
>Many thanks and regards
>
>Chris 
>
>>>Hi,
>>>
>[quoted text clipped - 35 lines]
>>
>><etc etc through all the fields>

-- 
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201002/1

0
hobbit2612
2/10/2010 8:12:56 PM
On Wed, 10 Feb 2010 20:12:56 GMT, "hobbit2612 via AccessMonster.com"
<u27332@uwe> wrote:

>I'm now trying to incorporate another field into the query. i.e a record ID
>already built into the table just to give the user some more information that
>I just can't seem to get to work. I've added the ID field at the beginning of
>the code because, well to me it seemed the logical place to put it so the
>coding looks like this:
>
>SELECT tblCR.ID, "Version" AS WhatChanged, tblCR.DateVersionChanged, tblCR.
>Version
>FROM tblCR
>WHERE (((tblCR.DateVersionChanged)>=[Forms]![frmDateInput]![StartDate] 
>And (tblCR.DateVersionChanged)<=[Forms]![frmDateInput]![EndDate])) 
>UNION ALL
>etc
>
>The problem is, is that I get an error message that says the 'number of
>columns in the two selected tables or queries of a union query to not match'.
>Now I'm pretty sure that the error occurs because I know in a Union query the
>tables must match in terms of the number of fields, but I'm just not sure
>where I can add the ID field.
>
>Could you perhaps point me in the right direction please?

What's the point of the ID? What will you do with it when you see it?

The error suggests that you have the ID in your first SELECT statement but not
in your others. A UNION query is very specific in its requirements: it
consists of two or more SELECT statements separated by UNION (or UNION ALL)
operators. Each SELECT statement must return the same number of fields, of
matching datatypes; your SELECT above returns four fields - a (number) ID, a
literal  text string "Version", a Date, and the text Version. For your UNION
to work, every single one of the SELECT statements must also return four
fields - a number, a text, a date, and another text field, in that order. My
guess is that you need to include the ID field in all of the SELECTS.


HOWEVER....

As I've said before, *your table design IS WRONG*, which is why you're having
all these problems, and why you need the UNION query in the first place!!!!
I'd really strongly suggest *fixing your table design* first, rather than
continuing to struggle with the endless problems your incorrect design will
give you!
-- 

             John W. Vinson [MVP]
0
John
2/10/2010 11:38:03 PM
Reply:

Similar Artilces:

Cross-Tab Query
I have a cross-tab query that works as desired. I can get it to post to a report. My problem is the report (legal - landscape mode) is limited to 12 items. How can I get the report to go beyond the 12 items? The data in the cross-tab query will take multiple pages to print all the data. Is there a way to get the report to pick up with the next "12" items if the cross-tab has more than 12 items? I can post a stripped-down version of the database if needed. Creating a dynamic cross-tab report is by no means easy, but it can be done. Here's Microsoft's take on it: ...

Changing the name of the CRM server
I have been asked to change the name of our CRM server. The ip address will not be changing, just the server name. Has anyone tried this? Is it as simple as just changing the name. I plan on reinstalling the outlook plugin for everyone so that won't be an issue. Are there other issues? Thanks! You may run into problems with the Exchange router or the Crystal configuration as well. You can always rename it back if you run into problems. If you do have problems, you might also try uninstalling CRM from the server, do the rename, then install using the exinsting DB & AD info. ...

Linking Queries
Can anyone help? I have a system where employees register property with us. They then report back to us when they sell the property. Registered properties are held in one table and sold properties are in another, where the common field is the employee. I want to create a query where it will show the employee and the details of the registerly and the sale. I cant seem to get the details of the registry and the sale to assign to the correct employee. Thanks If you were limited to working with a spreadsheet, you might come up with a design that puts properties in one status on one s...

How to create DSN Less connection on pass through query?
I have DSN Less connection code as follows for linked tables which the code is on the switchboard form: Private Sub Form_Open(Cancel As Integer) ' Minimize the database window and initialize the form. ' Move to the switchboard page that is marked as the default. Me.Filter = "[ItemNumber] = 0 AND [Argument] = 'Default' " Me.FilterOn = True Dim ServerName As String Dim UserName As String Dim Password As String ServerName = "CPSHOUDB15" UserName = "********" Password = "********" 'Attach the linked database table...

OWA change password button does not display
I am testing the OWA change password feature in the lab following Q297121. However I still cannot see the change password button after following the article line by line. In my test environment I have 2 front-end servers and a cluster back-end. User connects to OWA using a common namespace that is load-balanced by NLB. The certificates with that common namespace is installed on both front-end servers. Steps I have performed 1) make sure that SSL certificates is installed on default web site on both FEs. 2) run adsutil.vbs to set the paswswordchangeflags to 1 3) created IISADMPWD manua...

changing the semicolon as separator in csv
hi all when i save a worksheet to a .CSV Excel uses the semicolon ";" character as the default separator Where do I chnage the setting so that it uses a comma "," character? thanks In Windows XP, it's under the control panel|Regional options tab then click customize and look for List separator on the Numbers tab. Or you could rename your .csv file to .txt And the specify the delimiter when you get the text import wizard. console1 wrote: > > hi all > > when i save a worksheet to a .CSV Excel uses the semicolon ";" character > as the def...

Problem: Publishing changes with Deployment MAnager
Hi I have a problem publishing changes with Deployment Manager (CRM 3.0) My Deployment Manager has only 3 nodes ( Server Manager, License Manager & User Manager). If I get it right, any time I make changes (for ex. Customizing Leads adding new Industries) I need to publish changes in Deployment Manager, and I simply can't because I don't have such an action. Any idea? many thanks George You publish changes in the web client under Settings, Customizations, Customize Entities, highlight the Entity and click the Publish button. "George Athanasopoulos" wrote:...

Almost got it. Change order on subform After new record added
Almost there I have a customer sub form Every thing works great. I have ordered the records in descending order. The only thing is when I hit the new call record and save it the record appears at the bottom of the list. When I change to another customer then go back every thing is how it should be. New record at top of the list. I have put a me.requery command in the subform but does not seem to work Use OrderBy to set the name of the field to sort on and which direction, Desc for descending, and leave blank for the default of ascending. Then set OrderByOn to True. ...

Global Margin Change
MS Publisher 2002 I've been given a 70 page document with two columns per page and want to change the margin for every page. Can I make a change in one place that will change the margin on all pages? Changing the layout on the Master Page seems to change only the pink margin guides and has no effect on the text on the pages. Can margins or text box widths be set in styles so I can change a style and get a global change in text box width? TIA While waiting for decisions from his 6 university choices, Ed sees a message from John Smith <someone@microsoft.com>. On it is written: &g...

changing thickness of Excel row and column headers
By this I mean the gray A through IV and 1 through 65535 on the edge of all worksheets. I haven't discovered a way to reproduce this on demand but it very definitely happens: some workbooks show thicker headings (BOTH) than others. If you haven't experienced this yourself there's no need to read further. You might see it if you open a half dozen workbooks created over a long span of time. http://www.mrexcel.com/board2/viewtopic.php?t=32415&highlight= seems to describe the problem exactly, if that helps... I recognize that the row number heading expands as you cross row 100...

update a table based on a sum query
Hi All, I have seen the zillions of answers to this that state "never add a total into the table.." But there are cases, such as mine when it is prefered. I want to update a project table with the final invoice cost. I want it entered as a hard figure so that I can then export the table for accounting purposes. Additionally, once an invoice has been generated, there isn't any need for the total to ever, ever change! In fact it shouldn't. So the question is.... is there a way to do this? To update a table with a value from a sum query? Thanks for any help. ...

Change radio button when sheet is protected
I have two radio (option) buttons (from the forms menu, not controls), one to protect the sheet and one to unprotect the sheet. These are linked to cell $D$1 I also have code that protects/unprotects the sheet in order to sort the data. How can I get the radio buttons to change to reflect the current status of the worksheet (protected/unprotected) when the code runs to sort the sheet. My code: Sub SortRoom() Call UnProtSheet Application.Goto Reference:="DataEntry" Selection.Sort Key1:=Range("B4"), Order1:=xlAscending, Key2:=Range("C4") _ , Order...

How to use different type Query for Excel PivotTable? (ODBC)
How to use two different type of Database Query for Excel PivotTable? (ODBC) My PivotTable gets data from Microsoft Query by ODBC. But I can not get two different type database for ONE PivotTable. For example, one table is *.dbf, the other is *.btr, Can i use these different table for ONE PivotTable? I know Crystal Report can do it. How about Excel PivotTable? try Vb, ADO programs or SQL.Request function (Excel ODBC Add-In) with "SELECT....IN... UNION SELECT....IN... " statement. I do such a queries into another file and make PivotTs basing on it ...

UNION query and Data type mismatch in criteria expression
I did some searches on this problem before trying to post here to the newsgroup, but what little information I found did not seem to help. Here is the problem. I have a UNION query that joins 2 queries into 1 dataset. Each sub-query works fine individually, but when I place them into a UNION query it gives the error message "Data Type mismatch in criteria expression" I first double-checked to make sure any JOIN fields were of the same data type - which they are (everything is in TEXT format). Also, the information I found suggested there might be problems when an empty field...

Change contour plot
Hi folks. This is (hopefully!) a simple this to answer... I've got a contour plot, and the contour lines are too are apart. How do I change the scale on the Z-axis to fix this? (Also, I presume there's a way to change the number formatting on the legend. I can change the formatting on the X- and Y-axies, but not on the legend display.) Thanks. On Thu, 30 Oct 2003 16:19:17 -0000, Invisible <dev@null.domain.net> wrot= e: > This is (hopefully!) a simple this to answer... I've got a contour plo= t, = > and > the contour lines are too are apart. How do I change the ...

Change "Account" to "Company" in Navigation pane
Ok, what am I missing here. We don't want to call companies "Accounts". So I went and changed the "Account" Entity "Name" field to "Company" (and the corresponding plural name to "Companies". However, in the navigation pane, it still shows up as "Accounts". What am I doing wrong? Do I need to edit the site map for this? Thanks, Elie Wildman. After you changed the name of the entity to Company/Companies, did you publish the changes? After you publish, you might have to refresh the page to see the changes. I have been able...

List Box to create a Report based on crosstab query
I have a form with a list box to select a value, and a button that is pressed to create a report based on the value selected in the list box. The problem is the query used to create the report and populate the values in the list box is a crosstab query, which is not updateable of course. Here is the SQL for my query: TRANSFORM Avg(Val([tblCourseGrades].[Grade])) AS AvgOfGrade SELECT TblStudents.[ClassNumber], TblStudents.Rank, TblStudents.[Last Name], TblStudents.[First Name], Avg(tblCourseGrades.Grade) AS AvgOfGrade1 FROM TblStudents INNER JOIN (tblCourses INNER JOIN tblCours...

Charts that don't change size
I have 2 charts on a sheet, each representing different data, one on top of the other. I would like the plot areas to line up with each other. I can do this easily with no data, but when data is added, one will be bigger or smaller than the other. There is new data added every month and no matter how hard I try to keep them aligned, they just keep changing sizes!! The chart is not the problem, it's just the plot area. Is there a way to lock the plot area size, whether there is data in it or not? Thanks I think -- but I am not sure -- you could write a macro that aligns the plot areas. ...

tableadapter Query linked to Access 2003 table
I'm trying to write a query for my Dataset's table adapter. It is linked to an access 2003 database. Basically, I'm trying to duplicate the following query. SELECT Parts_Inventory.Aisle, Parts_Inventory.Rack, Parts_Inventory.Shelf, Parts_Inventory.QNTY, Parts_Inventory.MFG_PN, Parts_Inventory.Manufacturer, Parts_Inventory.Description FROM Parts_Inventory WHERE (((Parts_Inventory.Manufacturer) Like "*" & [?] & "*")); I'm using a text box as my control to the manufacturer field. If it is blank, it will show all my parts. I'm able...

Mutliple Complex Queries
Thank you in advance for your assistance. I have data that I must access on a weekly basis that involves a number of criteria. To date, I have performed each query and then coalesced my findings (by hand) into a table. Something tells me that this would be far easier with better knowledge of the program. I have three major data categories (Poor Performance rating, Location, and Seniority) that are dependent upon sorting the Employees into three different sections (Dismissed, Retained, and Reallocated). For each of the sections, I must calculate the percentage based upon the main data...

date track based on svc cond.
Hello, I'm looking to track material out for repair by the type of service requested. In cell (G:2) will be the type of service: BCK = bench check = this will have a projected return date (I:2)within three days of the repair order date (H:2) REP = repaired = This will have a projected return date (I:2) within 7 days of the repair order date (H:2) OVH = overhaule = this will have a projected return date (I:2) within 14 days of the repair order date. With all this I would also like to include the warranty schedule from the date of the service reurn date(J2) BCK= no warranty REP= 90...

workflow fires twice
I have a workflow associated with quotes that is set to fire when the status changes. The first line of the workflow checks the status. If the status is not won, the workflow cancels, if the status equals won, then the steps continue. The workflow fires twice most of the time. Both of the workflows that fire say they fired because a record attribute changed. I even created a very simple test workflow to rule out an issue with any of the steps in my real workflow as being part of the issue. What people are doing is taking a draft quote and activating it, then turning the draft quote in...

Tracking inventory that is sent back and credits due
I have a liquor store client who needs to track the return of a keg shell (to Budweiser for example) and that they are expecting a credit. How would this be done? Offlien Inventory? Transfer Out? Thanks- Andrea The only way we have been able to come up with for tracking our returns for credit is to standardize the "Remarks" and "Title" fields on the transfers. If you standardized these fields ie "Return to suplier for credit" you can filter them out on reports. Melinda "Andrea" wrote: > I have a liquor store client who needs to track the r...

Change client permission on multiple Public folders
We have an Exchange 2003 Server with many public folders with subfolders (migrated from Lotus Notes). These are MAPI folders an have to be given access rights by using Exchange System Manager and give client permission manually on every single folder. Is there no "apply to all subfolders" add-in that exist? Or maybe a script? It takes some time to change permission on some 1200+ folders. Right-click on the parent public folder and pick "All Tasks". There is a "Propagate Settings" option there. "Bjorn Standal" wrote: > We have an Exchange 200...

How do I change the group heading COLOR of incoming e-mail?
Is it possible to change the COLOR of the HEADING of a group for an incoming e-mail? It's pretty annoying having to search and search for incoming e-mail. Thanks so much. yes, its automatic formatting-and is part of the view settings. you can use Tools, Organize. to access it. -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide) Need Help with Common Tasks? http://www.outlook-tips.net/beginner/ Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slips...