OT (MS Access Help)

Yahoo Archive
1
Strange, I sent that message on Friday the 13th and it just now shows up
on 5/9.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Gerard Wadman
Sent: Wednesday, May 09, 2007 2:14 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] OT (MS Access Help)



That's all it was, I was pulling my hair out for an hour before I
realized the problem.

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> on
behalf of lonwiksell@... <mailto:lonwiksell%40romcorp.com>
Sent: Fri 4/13/2007 9:24 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] OT (MS Access Help)

If you cut and pasted this then one of your problems is that you spelled
it "Bewteen" instead of "Between".

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ]
On Behalf
Of Gerard Wadman
Sent: Friday, April 13, 2007 8:09 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] OT (MS Access Help)

Greetings gang,

I'm trying to create some query conditions that will select
transaction quantities from the Vantage PartTran table.

Basically I want transaction quantities from the current month, last
month, and the previous five months.

For the current month I wrote:

Current: IIf(Year([PUB_PartTran]![TranDate])=Year(Date()) And
Month([PUB_PartTran]![TranDate])=Month(Date()),[PUB_PartTran]![TranQty],
0)

It works perfectly.

For the Last month I employed the "DateAdd" function and wrote:

LastMth: IIf(Year([PUB_PartTran]![TranDate])=Year(Date()) And
Month([PUB_PartTran]![TranDate])=Month(DateAdd("m",-1,Date())),[PUB_Part
Tran]![TranQty],0)

This also works perfectly

For the previous 5 months I employed the "DateAdd" function with the
"Between" operator and wrote:

Previous: IIf([PUB_PartTran]![TranDate])Bewteen(DateAdd("m",-6,Date())
And DateAdd("m",-2,Date())),[PUB_PartTran]![TranQty],0)

This condition fails with either "to many arguments" or "invalid syntax"
depending on where I place the parentheses.

Help!!!!

Gerard M Wadman

MCSE, MCP+I, A+, NET+

Sr. Network Systems Engineer

Scandius BioMedical Inc.

11A Beaver Brook Road

Littleton, MA 01460

978/486-4088 x 124

866/486-4108 (fax)

http://www.scandius.com/ <http://www.scandius.com/>
<http://www.scandius.com/ <http://www.scandius.com/> >
<http://www.scandius.com/ <http://www.scandius.com/>
<http://www.scandius.com/ <http://www.scandius.com/> > >

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
2
Greetings gang,

I'm trying to create some query conditions that will select
transaction quantities from the Vantage PartTran table.

Basically I want transaction quantities from the current month, last
month, and the previous five months.



For the current month I wrote:

Current: IIf(Year([PUB_PartTran]![TranDate])=Year(Date()) And
Month([PUB_PartTran]![TranDate])=Month(Date()),[PUB_PartTran]![TranQty],
0)

It works perfectly.



For the Last month I employed the "DateAdd" function and wrote:



LastMth: IIf(Year([PUB_PartTran]![TranDate])=Year(Date()) And
Month([PUB_PartTran]![TranDate])=Month(DateAdd("m",-1,Date())),[PUB_Part
Tran]![TranQty],0)

This also works perfectly



For the previous 5 months I employed the "DateAdd" function with the
"Between" operator and wrote:



Previous: IIf([PUB_PartTran]![TranDate])Bewteen(DateAdd("m",-6,Date())
And DateAdd("m",-2,Date())),[PUB_PartTran]![TranQty],0)



This condition fails with either "to many arguments" or "invalid syntax"
depending on where I place the parentheses.



Help!!!!





Gerard M Wadman

MCSE, MCP+I, A+, NET+

Sr. Network Systems Engineer



Scandius BioMedical Inc.

11A Beaver Brook Road

Littleton, MA 01460



978/486-4088 x 124

866/486-4108 (fax)



http://www.scandius.com/





[Non-text portions of this message have been removed]
3
I don't know if the between function works as a condition for an iif
statement. You could try using nested conditions, one for greater than
6 months ago and then another less than 2 months ago. So...

Previous:
IIf([PUB_PartTran]![TranDate]>=DateAdd("m",-6,Date()),iif(PUB_PartTran]!
[TranDate]<=DateAdd("m",-2,Date()),[PUB_PartTran]![TranQty],0), 0)

I may have missed a parenthesis somewhere but the idea should work.


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Gerard Wadman
Sent: Friday, April 13, 2007 9:09 AM
To: vantage@yahoogroups.com
Subject: [Vantage] OT (MS Access Help)



Greetings gang,

I'm trying to create some query conditions that will select
transaction quantities from the Vantage PartTran table.

Basically I want transaction quantities from the current month, last
month, and the previous five months.

For the current month I wrote:

Current: IIf(Year([PUB_PartTran]![TranDate])=Year(Date()) And
Month([PUB_PartTran]![TranDate])=Month(Date()),[PUB_PartTran]![TranQty],
0)

It works perfectly.

For the Last month I employed the "DateAdd" function and wrote:

LastMth: IIf(Year([PUB_PartTran]![TranDate])=Year(Date()) And
Month([PUB_PartTran]![TranDate])=Month(DateAdd("m",-1,Date())),[PUB_Part
Tran]![TranQty],0)

This also works perfectly

For the previous 5 months I employed the "DateAdd" function with the
"Between" operator and wrote:

Previous: IIf([PUB_PartTran]![TranDate])Bewteen(DateAdd("m",-6,Date())
And DateAdd("m",-2,Date())),[PUB_PartTran]![TranQty],0)

This condition fails with either "to many arguments" or "invalid syntax"
depending on where I place the parentheses.

Help!!!!

Gerard M Wadman

MCSE, MCP+I, A+, NET+

Sr. Network Systems Engineer

Scandius BioMedical Inc.

11A Beaver Brook Road

Littleton, MA 01460

978/486-4088 x 124

866/486-4108 (fax)

http://www.scandius.com/ <http://www.scandius.com/>

[Non-text portions of this message have been removed]




This is an e-mail from Saab Barracuda LLC. It is for the intended recipient only and may contain confidential and privileged information. No one else may read, print, store, copy, forward or act in reliance on it or its attachments. If you are not the intended recipient, please return this message to the sender and delete the message and any attachments from your computer. Your cooperation is appreciated.

###########################################

This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
For more information, connect to http://www.f-secure.com/

[Non-text portions of this message have been removed]
4
I tried that earlier and got a return on all rows.



But I'll try it again, thanks



Gerard M Wadman

Sr. Network Systems Engineer



Scandius BioMedical Inc.

11A Beaver Brook Road

Littleton, MA 01460



978/486-4088 x 124

978/486-4108 (fax)



http://www.scandius.com/





This e-mail is for the use of the intended recipient(s) only. If you
have received this e-mail in error, please notify the sender immediately
and then delete it. If you are not the intended recipient, you must not
use, disclose or distribute this e-mail without the author's prior
permission. We have taken precautions to minimize the risk of
transmitting software viruses, but we advise you to carry out your own
virus checks on any attachment to this message. We do not accept
liability for any loss or damage caused by software viruses







________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Chris Clunn
Sent: Friday, April 13, 2007 9:27 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] OT (MS Access Help)



I don't know if the between function works as a condition for an iif
statement. You could try using nested conditions, one for greater than
6 months ago and then another less than 2 months ago. So...

Previous:
IIf([PUB_PartTran]![TranDate]>=DateAdd("m",-6,Date()),iif(PUB_PartTran]!
[TranDate]<=DateAdd("m",-2,Date()),[PUB_PartTran]![TranQty],0), 0)

I may have missed a parenthesis somewhere but the idea should work.

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Gerard Wadman
Sent: Friday, April 13, 2007 9:09 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] OT (MS Access Help)

Greetings gang,

I'm trying to create some query conditions that will select
transaction quantities from the Vantage PartTran table.

Basically I want transaction quantities from the current month, last
month, and the previous five months.

For the current month I wrote:

Current: IIf(Year([PUB_PartTran]![TranDate])=Year(Date()) And
Month([PUB_PartTran]![TranDate])=Month(Date()),[PUB_PartTran]![TranQty],
0)

It works perfectly.

For the Last month I employed the "DateAdd" function and wrote:

LastMth: IIf(Year([PUB_PartTran]![TranDate])=Year(Date()) And
Month([PUB_PartTran]![TranDate])=Month(DateAdd("m",-1,Date())),[PUB_Part
Tran]![TranQty],0)

This also works perfectly

For the previous 5 months I employed the "DateAdd" function with the
"Between" operator and wrote:

Previous: IIf([PUB_PartTran]![TranDate])Bewteen(DateAdd("m",-6,Date())
And DateAdd("m",-2,Date())),[PUB_PartTran]![TranQty],0)

This condition fails with either "to many arguments" or "invalid syntax"
depending on where I place the parentheses.

Help!!!!

Gerard M Wadman

MCSE, MCP+I, A+, NET+

Sr. Network Systems Engineer

Scandius BioMedical Inc.

11A Beaver Brook Road

Littleton, MA 01460

978/486-4088 x 124

866/486-4108 (fax)

http://www.scandius.com/ <http://www.scandius.com/>
<http://www.scandius.com/ <http://www.scandius.com/> >

[Non-text portions of this message have been removed]

This is an e-mail from Saab Barracuda LLC. It is for the intended
recipient only and may contain confidential and privileged information.
No one else may read, print, store, copy, forward or act in reliance on
it or its attachments. If you are not the intended recipient, please
return this message to the sender and delete the message and any
attachments from your computer. Your cooperation is appreciated.

###########################################

This message has been scanned by F-Secure Anti-Virus for Microsoft
Exchange.
For more information, connect to http://www.f-secure.com/
<http://www.f-secure.com/>

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
5
It's working.

Would you believe I had "Between" spelled wrong, I had "Bewteen"



What a maroon I am.





Previous: IIf([PUB_PartTran]![TranDate] Between DateAdd("m",-6,Date())
And DateAdd("m",-2,Date()),[PUB_PartTran]![TranQty],0)











Gerard M Wadman

Sr. Network Systems Engineer



Scandius BioMedical Inc.

11A Beaver Brook Road

Littleton, MA 01460



978/486-4088 x 124

978/486-4108 (fax)



http://www.scandius.com/





This e-mail is for the use of the intended recipient(s) only. If you
have received this e-mail in error, please notify the sender immediately
and then delete it. If you are not the intended recipient, you must not
use, disclose or distribute this e-mail without the author's prior
permission. We have taken precautions to minimize the risk of
transmitting software viruses, but we advise you to carry out your own
virus checks on any attachment to this message. We do not accept
liability for any loss or damage caused by software viruses







________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Chris Clunn
Sent: Friday, April 13, 2007 9:27 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] OT (MS Access Help)



I don't know if the between function works as a condition for an iif
statement. You could try using nested conditions, one for greater than
6 months ago and then another less than 2 months ago. So...

Previous:
IIf([PUB_PartTran]![TranDate]>=DateAdd("m",-6,Date()),iif(PUB_PartTran]!
[TranDate]<=DateAdd("m",-2,Date()),[PUB_PartTran]![TranQty],0), 0)

I may have missed a parenthesis somewhere but the idea should work.

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Gerard Wadman
Sent: Friday, April 13, 2007 9:09 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] OT (MS Access Help)

Greetings gang,

I'm trying to create some query conditions that will select
transaction quantities from the Vantage PartTran table.

Basically I want transaction quantities from the current month, last
month, and the previous five months.

For the current month I wrote:

Current: IIf(Year([PUB_PartTran]![TranDate])=Year(Date()) And
Month([PUB_PartTran]![TranDate])=Month(Date()),[PUB_PartTran]![TranQty],
0)

It works perfectly.

For the Last month I employed the "DateAdd" function and wrote:

LastMth: IIf(Year([PUB_PartTran]![TranDate])=Year(Date()) And
Month([PUB_PartTran]![TranDate])=Month(DateAdd("m",-1,Date())),[PUB_Part
Tran]![TranQty],0)

This also works perfectly

For the previous 5 months I employed the "DateAdd" function with the
"Between" operator and wrote:

Previous: IIf([PUB_PartTran]![TranDate])Bewteen(DateAdd("m",-6,Date())
And DateAdd("m",-2,Date())),[PUB_PartTran]![TranQty],0)

This condition fails with either "to many arguments" or "invalid syntax"
depending on where I place the parentheses.

Help!!!!

Gerard M Wadman

MCSE, MCP+I, A+, NET+

Sr. Network Systems Engineer

Scandius BioMedical Inc.

11A Beaver Brook Road

Littleton, MA 01460

978/486-4088 x 124

866/486-4108 (fax)

http://www.scandius.com/ <http://www.scandius.com/>
<http://www.scandius.com/ <http://www.scandius.com/> >

[Non-text portions of this message have been removed]

This is an e-mail from Saab Barracuda LLC. It is for the intended
recipient only and may contain confidential and privileged information.
No one else may read, print, store, copy, forward or act in reliance on
it or its attachments. If you are not the intended recipient, please
return this message to the sender and delete the message and any
attachments from your computer. Your cooperation is appreciated.

###########################################

This message has been scanned by F-Secure Anti-Virus for Microsoft
Exchange.
For more information, connect to http://www.f-secure.com/
<http://www.f-secure.com/>

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
6
> Previous:

> IIf ( [PUB_PartTran]![TranDate]) Bewteen(DateAdd("m",-6,Date())
^
It looks like this is closing your IIF too soon
7
I had a 24-port 3Com superstack switch give out after lots of years of
service. Network speed has been somewhat slow since our traffic has
grown. I've been advised that a Cisco 10/100 switch will outrun other
10/100/1000 switches in an engineering environment where we have lots of
big files going back and forth. Cisco isn't as confident in that
assessment. Any ideas on this and/or general opinions why some switches
would work better than others in our scenerio?

Gary Polvinale
Denton ATD


[Non-text portions of this message have been removed]
8
Depending on how your storage for engineering is setup if they are pretty segregated from other departments (and Vantage traffic) you might want to look at putting a storage server directly on the switch they are on. Some switches are smart enough to do a local VLAN, never passing the local traffic beyond the switch. This has worked well for our CAD/Engineering dept. It may be the traffic pattern more than the type of switch.
-Todd C.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Garyphold
Sent: Tuesday, April 17, 2007 10:16 AM
To: vantage@yahoogroups.com
Subject: [Vantage] OT Network Switches



I had a 24-port 3Com superstack switch give out after lots of years of
service. Network speed has been somewhat slow since our traffic has
grown. I've been advised that a Cisco 10/100 switch will outrun other
10/100/1000 switches in an engineering environment where we have lots of
big files going back and forth. Cisco isn't as confident in that
assessment. Any ideas on this and/or general opinions why some switches
would work better than others in our scenerio?

Gary Polvinale
Denton ATD

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]
9
That may have been the case at one time. In most modern switches the
backplane (bandwidth for all ports) is big enough to handle the maximum
speed for every port. I am extremely doubtful that a 10/100 switch
could ever outperform even a cheap 10/100/1000 switch (if your clients
support gigabit Ethernet).



-----Original Message-----
From: Garyphold [mailto:garyphold@...]
Sent: Tuesday, April 17, 2007 10:16 AM
To: vantage@yahoogroups.com
Subject: [Vantage] OT Network Switches



I had a 24-port 3Com superstack switch give out after lots of years of
service. Network speed has been somewhat slow since our traffic has
grown. I've been advised that a Cisco 10/100 switch will outrun other
10/100/1000 switches in an engineering environment where we have lots of
big files going back and forth. Cisco isn't as confident in that
assessment. Any ideas on this and/or general opinions why some switches
would work better than others in our scenerio?

Gary Polvinale
Denton ATD

[Non-text portions of this message have been removed]








[Non-text portions of this message have been removed]
10
Switches work on Layer 3 of the OSI model meaning that a switch will create
a point to point connection to and from the hosts that are communicating.
Meaning that the other ports of a switch do not see the traffic of those two
ports that are being used. A VLAN is really used to segment different
logical networks, meaning broadcast traffic is not being transmitted across
different VLANs.

The backplane of a switch is really where the contention if going to occur
on a Layer 3 Switch. If the backplane can not handle the traffic volume that
it will cause more latency than normal.

A cheap Gigabit switch should out perform a any 100Mbps switch just due to
the available bandwidth it can pass. Unless the backplane is so slow that it
causes speeds to decrease to below a Good 100Mbps switch.

Scott Litzau

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Todd Caughey
Sent: Tuesday, April 17, 2007 10:30 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] OT Network Switches


Depending on how your storage for engineering is setup if they are pretty
segregated from other departments (and Vantage traffic) you might want to
look at putting a storage server directly on the switch they are on. Some
switches are smart enough to do a local VLAN, never passing the local
traffic beyond the switch. This has worked well for our CAD/Engineering
dept. It may be the traffic pattern more than the type of switch.
-Todd C.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
Garyphold
Sent: Tuesday, April 17, 2007 10:16 AM
To: vantage@yahoogroups.com
Subject: [Vantage] OT Network Switches



I had a 24-port 3Com superstack switch give out after lots of years of
service. Network speed has been somewhat slow since our traffic has
grown. I've been advised that a Cisco 10/100 switch will outrun other
10/100/1000 switches in an engineering environment where we have lots of
big files going back and forth. Cisco isn't as confident in that
assessment. Any ideas on this and/or general opinions why some switches
would work better than others in our scenerio?

Gary Polvinale
Denton ATD

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
11
Thanks all for the replies. Does anyone with reasonable amount of
network traffic have a favorite brand and type of switch? -Gary

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Scott Litzau
Sent: Tuesday, April 17, 2007 2:22 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] OT Network Switches

Switches work on Layer 3 of the OSI model meaning that a switch will
create
a point to point connection to and from the hosts that are
communicating.
Meaning that the other ports of a switch do not see the traffic of those
two
ports that are being used. A VLAN is really used to segment different
logical networks, meaning broadcast traffic is not being transmitted
across
different VLANs.

The backplane of a switch is really where the contention if going to
occur
on a Layer 3 Switch. If the backplane can not handle the traffic volume
that
it will cause more latency than normal.

A cheap Gigabit switch should out perform a any 100Mbps switch just due
to
the available bandwidth it can pass. Unless the backplane is so slow
that it
causes speeds to decrease to below a Good 100Mbps switch.

Scott Litzau

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Todd Caughey
Sent: Tuesday, April 17, 2007 10:30 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] OT Network Switches

Depending on how your storage for engineering is setup if they are
pretty
segregated from other departments (and Vantage traffic) you might want
to
look at putting a storage server directly on the switch they are on.
Some
switches are smart enough to do a local VLAN, never passing the local
traffic beyond the switch. This has worked well for our CAD/Engineering
dept. It may be the traffic pattern more than the type of switch.
-Todd C.


-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com]On
Behalf Of
Garyphold
Sent: Tuesday, April 17, 2007 10:16 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] OT Network Switches

I had a 24-port 3Com superstack switch give out after lots of years of
service. Network speed has been somewhat slow since our traffic has
grown. I've been advised that a Cisco 10/100 switch will outrun other
10/100/1000 switches in an engineering environment where we have lots of
big files going back and forth. Cisco isn't as confident in that
assessment. Any ideas on this and/or general opinions why some switches
would work better than others in our scenerio?

Gary Polvinale
Denton ATD

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and
Crystal Reports and other 'goodies', please goto:
http://groups. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.yahoo.com/group/vantage/links>
yahoo.com/group/vantage/links
Yahoo! Groups Links



[Non-text portions of this message have been removed]
12
Scott - Actually, switching happens at layer 2 of the OSI model. Layer 3
is routing. Layer 1 is your hubs and basic CSMA/CD devices (NICs,
Cabling, Hubs).



A Cisco 10/100 switch probably won't outperform a newer model 3COM
10/100/1000.



Gary - As another poster has alluded to, the backplane of the switch
will determine your overall performance. Also, environment will need to
be looked at closely. How is your network currently setup? Do you have
multiple VLANs for different departments or are all your nodes on
multiple switches?



If you have many large files, you may consider a switch that can do
VLANs - yes it will cost you more, but you will segregate your
engineering traffic to one segment of your network and the other users
will thank you. Do you have a separate server for the engineering folks?
If so, you could put them all on the same VLAN and make life much
easier.



A VLAN basically allows you to take a modern switch and divide it up
into different network segments - this en lieu of putting a separate
router in each department which is the other way of accomplishing the
same thing.



Although my Cisco certification is not current, I am still a proud
holder of the CCNP/CCDP certifications.



Thanks,



Jason Claggett

Microsoft Small Business Specialist

MCP #3856159

2W Technologies, LLC

317.578.2393

jason@...





[Non-text portions of this message have been removed]
13
To add to these considerations, if VOIP is in your future(life of the
switch you are buying) you will want to purchase a layer 3 switch that
supports VLAN's as it is preferred to separate voice and data onto their
own VLAN.



Todd



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jason Claggett
Sent: Wednesday, April 18, 2007 9:15 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: OT Network Switches



Scott - Actually, switching happens at layer 2 of the OSI model. Layer 3
is routing. Layer 1 is your hubs and basic CSMA/CD devices (NICs,
Cabling, Hubs).

A Cisco 10/100 switch probably won't outperform a newer model 3COM
10/100/1000.

Gary - As another poster has alluded to, the backplane of the switch
will determine your overall performance. Also, environment will need to
be looked at closely. How is your network currently setup? Do you have
multiple VLANs for different departments or are all your nodes on
multiple switches?

If you have many large files, you may consider a switch that can do
VLANs - yes it will cost you more, but you will segregate your
engineering traffic to one segment of your network and the other users
will thank you. Do you have a separate server for the engineering folks?
If so, you could put them all on the same VLAN and make life much
easier.

A VLAN basically allows you to take a modern switch and divide it up
into different network segments - this en lieu of putting a separate
router in each department which is the other way of accomplishing the
same thing.

Although my Cisco certification is not current, I am still a proud
holder of the CCNP/CCDP certifications.

Thanks,

Jason Claggett

Microsoft Small Business Specialist

MCP #3856159

2W Technologies, LLC

317.578.2393

jason@... <mailto:jason%402wtech.com>

[Non-text portions of this message have been removed]





This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.

[Non-text portions of this message have been removed]
14
If you are looking for a way to justify the Managed switches...The Virtual
LAN will give you the ability to setup one for VoIP traffic, so you can
migrate to Phones that run over your network. This enables you to give a
user a phone without the added cost of running separate copper for the phone
system.

Paul L.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
Jason Claggett
Sent: Wednesday, April 18, 2007 8:15 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: OT Network Switches



Scott - Actually, switching happens at layer 2 of the OSI model. Layer 3
is routing. Layer 1 is your hubs and basic CSMA/CD devices (NICs,
Cabling, Hubs).

A Cisco 10/100 switch probably won't outperform a newer model 3COM
10/100/1000.

Gary - As another poster has alluded to, the backplane of the switch
will determine your overall performance. Also, environment will need to
be looked at closely. How is your network currently setup? Do you have
multiple VLANs for different departments or are all your nodes on
multiple switches?

If you have many large files, you may consider a switch that can do
VLANs - yes it will cost you more, but you will segregate your
engineering traffic to one segment of your network and the other users
will thank you. Do you have a separate server for the engineering folks?
If so, you could put them all on the same VLAN and make life much
easier.

A VLAN basically allows you to take a modern switch and divide it up
into different network segments - this en lieu of putting a separate
router in each department which is the other way of accomplishing the
same thing.

Although my Cisco certification is not current, I am still a proud
holder of the CCNP/CCDP certifications.

Thanks,

Jason Claggett

Microsoft Small Business Specialist

MCP #3856159

2W Technologies, LLC

317.578.2393

jason@2wtech. <mailto:jason%402wtech.com> com

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]
15
We have been longtime users of HP Advancestack switches and now are
using the next line HP ProCurve. Never been disappointed, excellent
support and lifetime warranty included in price. I'd definitely
recommend.



John A. Hatcher

Manager of IS

Versa Products Co., Inc.

(201) 518-5948

(201) 843-2400 x4148

(201) 843-2931 (fax)





[Non-text portions of this message have been removed]
16
True, Switching does happen at Layer 2. But a Switch that can do VLAN is a
Layer 3 switch.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jason Claggett
Sent: Wednesday, April 18, 2007 8:15 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: OT Network Switches


Scott - Actually, switching happens at layer 2 of the OSI model. Layer 3
is routing. Layer 1 is your hubs and basic CSMA/CD devices (NICs,
Cabling, Hubs).



A Cisco 10/100 switch probably won't outperform a newer model 3COM
10/100/1000.



Gary - As another poster has alluded to, the backplane of the switch
will determine your overall performance. Also, environment will need to
be looked at closely. How is your network currently setup? Do you have
multiple VLANs for different departments or are all your nodes on
multiple switches?



If you have many large files, you may consider a switch that can do
VLANs - yes it will cost you more, but you will segregate your
engineering traffic to one segment of your network and the other users
will thank you. Do you have a separate server for the engineering folks?
If so, you could put them all on the same VLAN and make life much
easier.



A VLAN basically allows you to take a modern switch and divide it up
into different network segments - this en lieu of putting a separate
router in each department which is the other way of accomplishing the
same thing.



Although my Cisco certification is not current, I am still a proud
holder of the CCNP/CCDP certifications.



Thanks,



Jason Claggett

Microsoft Small Business Specialist

MCP #3856159

2W Technologies, LLC

317.578.2393

jason@...





[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
17
Thanks Jason. We don't have VLANs yet - we plan to in the future. VOIP
we haven't scoped out yet - sounds like it might pay for itself though.

We have three 3Com 3300 Superstack 10/100 24-port switches for users in
main building, one D-link 10/100/1000 8-port switch the servers plug
into, and fibre connecting to one 12-port 3Com 3300 switch in second
building. Engineering has its own server for engineering files; Vantage
has own server; My Documents folders and IT stuff share a server;
Internet on separate proxy server (old ws); backup hard-disk based
storage on separate server. All users and servers share the switches.

I looked at the Cisco 10/100/1000 Catalyst WSC2960G24TCL - but that
hovers around $2000 - a lot of money for 24 ports. Our 3Coms were only
around $800 I think back in 2001 or 2002. I see 3Com, HP and Dell
switches out there. And D-Link.

The 3Com 4200G 24-port 10/100/1000 3CR17661-91 managed switch looks
comparable to the Cisco in features and costs around $1100. I wonder
how Cisco and 3Com compare in performance. Is there some place to get
truly meaningful comparison information? The pre-sales support person
at 3Com that I talked to today said that meaningful comparisons should
be based on throughput of the switch - and that the results may be
slanted in favor of the company commissioning the test. So he said it's
hard to do a straight comparison that will tell you anything.

John Hatcher from this list likes HP. We've used the 3Coms all this
time and they seemed ok, except for the slowness now that we've got more
going on with our network. Nowadays, most gigabit switches would
probably do what we need right now - the difference in performance would
likely show up later when we implement a VPN and other demands on the
network. It would be nice if they carried through our future needs for
awhile.

I'll do some more looking around. Meanwhile anybody who can fill in
some of the gaps, your opinions will be appreciated.

Gary


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jason Claggett
Sent: Wednesday, April 18, 2007 9:15 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: OT Network Switches
Scott - Actually, switching happens at layer 2 of the OSI model. Layer 3
is routing. Layer 1 is your hubs and basic CSMA/CD devices (NICs,
Cabling, Hubs).

A Cisco 10/100 switch probably won't outperform a newer model 3COM
10/100/1000.

Gary - As another poster has alluded to, the backplane of the switch
will determine your overall performance. Also, environment will need to
be looked at closely. How is your network currently setup? Do you have
multiple VLANs for different departments or are all your nodes on
multiple switches?

If you have many large files, you may consider a switch that can do
VLANs - yes it will cost you more, but you will segregate your
engineering traffic to one segment of your network and the other users
will thank you. Do you have a separate server for the engineering folks?
If so, you could put them all on the same VLAN and make life much
easier.

A VLAN basically allows you to take a modern switch and divide it up
into different network segments - this en lieu of putting a separate
router in each department which is the other way of accomplishing the
same thing.

Although my Cisco certification is not current, I am still a proud
holder of the CCNP/CCDP certifications.

Thanks,
Jason Claggett
Microsoft Small Business Specialist
MCP #3856159
2W Technologies, LLC
317.578.2393




[Non-text portions of this message have been removed]
18
I use HP 10/100/1000 ProCurve Switches also. Not as expensive as Cisco (I
feel your paying some just for the name Cisco) and they a have all the
features that I need; Managed, VLAN, Spanning Tree, SNMP, mostly copper
ports but also has some fiber ports and like John stated lifetime warranty,
which I never had to use. I have switches that have been running for 4 years
without a problem. Not even a port going bad. You can manage them either by
command line or with HPs management software.

Scott Litzau

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Garyphold
Sent: Wednesday, April 18, 2007 11:16 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: OT Network Switches


Thanks Jason. We don't have VLANs yet - we plan to in the future. VOIP
we haven't scoped out yet - sounds like it might pay for itself though.

We have three 3Com 3300 Superstack 10/100 24-port switches for users in
main building, one D-link 10/100/1000 8-port switch the servers plug
into, and fibre connecting to one 12-port 3Com 3300 switch in second
building. Engineering has its own server for engineering files; Vantage
has own server; My Documents folders and IT stuff share a server;
Internet on separate proxy server (old ws); backup hard-disk based
storage on separate server. All users and servers share the switches.

I looked at the Cisco 10/100/1000 Catalyst WSC2960G24TCL - but that
hovers around $2000 - a lot of money for 24 ports. Our 3Coms were only
around $800 I think back in 2001 or 2002. I see 3Com, HP and Dell
switches out there. And D-Link.

The 3Com 4200G 24-port 10/100/1000 3CR17661-91 managed switch looks
comparable to the Cisco in features and costs around $1100. I wonder
how Cisco and 3Com compare in performance. Is there some place to get
truly meaningful comparison information? The pre-sales support person
at 3Com that I talked to today said that meaningful comparisons should
be based on throughput of the switch - and that the results may be
slanted in favor of the company commissioning the test. So he said it's
hard to do a straight comparison that will tell you anything.

John Hatcher from this list likes HP. We've used the 3Coms all this
time and they seemed ok, except for the slowness now that we've got more
going on with our network. Nowadays, most gigabit switches would
probably do what we need right now - the difference in performance would
likely show up later when we implement a VPN and other demands on the
network. It would be nice if they carried through our future needs for
awhile.

I'll do some more looking around. Meanwhile anybody who can fill in
some of the gaps, your opinions will be appreciated.

Gary


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jason Claggett
Sent: Wednesday, April 18, 2007 9:15 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: OT Network Switches
Scott - Actually, switching happens at layer 2 of the OSI model. Layer 3
is routing. Layer 1 is your hubs and basic CSMA/CD devices (NICs,
Cabling, Hubs).

A Cisco 10/100 switch probably won't outperform a newer model 3COM
10/100/1000.

Gary - As another poster has alluded to, the backplane of the switch
will determine your overall performance. Also, environment will need to
be looked at closely. How is your network currently setup? Do you have
multiple VLANs for different departments or are all your nodes on
multiple switches?

If you have many large files, you may consider a switch that can do
VLANs - yes it will cost you more, but you will segregate your
engineering traffic to one segment of your network and the other users
will thank you. Do you have a separate server for the engineering folks?
If so, you could put them all on the same VLAN and make life much
easier.

A VLAN basically allows you to take a modern switch and divide it up
into different network segments - this en lieu of putting a separate
router in each department which is the other way of accomplishing the
same thing.

Although my Cisco certification is not current, I am still a proud
holder of the CCNP/CCDP certifications.

Thanks,
Jason Claggett
Microsoft Small Business Specialist
MCP #3856159
2W Technologies, LLC
317.578.2393




[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
19
We also use the HP's. In my opinion, just as good as Cisco but not as expensive.

-----Original Message-----
From: Scott Litzau [mailto:scott.litzau@...]
Sent: Wednesday, April 18, 2007 12:51 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: OT Network Switches



I use HP 10/100/1000 ProCurve Switches also. Not as expensive as Cisco (I
feel your paying some just for the name Cisco) and they a have all the
features that I need; Managed, VLAN, Spanning Tree, SNMP, mostly copper
ports but also has some fiber ports and like John stated lifetime warranty,
which I never had to use. I have switches that have been running for 4 years
without a problem. Not even a port going bad. You can manage them either by
command line or with HPs management software.

Scott Litzau

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com [mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On Behalf Of
Garyphold
Sent: Wednesday, April 18, 2007 11:16 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Re: OT Network Switches

Thanks Jason. We don't have VLANs yet - we plan to in the future. VOIP
we haven't scoped out yet - sounds like it might pay for itself though.

We have three 3Com 3300 Superstack 10/100 24-port switches for users in
main building, one D-link 10/100/1000 8-port switch the servers plug
into, and fibre connecting to one 12-port 3Com 3300 switch in second
building. Engineering has its own server for engineering files; Vantage
has own server; My Documents folders and IT stuff share a server;
Internet on separate proxy server (old ws); backup hard-disk based
storage on separate server. All users and servers share the switches.

I looked at the Cisco 10/100/1000 Catalyst WSC2960G24TCL - but that
hovers around $2000 - a lot of money for 24 ports. Our 3Coms were only
around $800 I think back in 2001 or 2002. I see 3Com, HP and Dell
switches out there. And D-Link.

The 3Com 4200G 24-port 10/100/1000 3CR17661-91 managed switch looks
comparable to the Cisco in features and costs around $1100. I wonder
how Cisco and 3Com compare in performance. Is there some place to get
truly meaningful comparison information? The pre-sales support person
at 3Com that I talked to today said that meaningful comparisons should
be based on throughput of the switch - and that the results may be
slanted in favor of the company commissioning the test. So he said it's
hard to do a straight comparison that will tell you anything.

John Hatcher from this list likes HP. We've used the 3Coms all this
time and they seemed ok, except for the slowness now that we've got more
going on with our network. Nowadays, most gigabit switches would
probably do what we need right now - the difference in performance would
likely show up later when we implement a VPN and other demands on the
network. It would be nice if they carried through our future needs for
awhile.

I'll do some more looking around. Meanwhile anybody who can fill in
some of the gaps, your opinions will be appreciated.

Gary


-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com [mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On Behalf
Of Jason Claggett
Sent: Wednesday, April 18, 2007 9:15 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Re: OT Network Switches
Scott - Actually, switching happens at layer 2 of the OSI model. Layer 3
is routing. Layer 1 is your hubs and basic CSMA/CD devices (NICs,
Cabling, Hubs).

A Cisco 10/100 switch probably won't outperform a newer model 3COM
10/100/1000.

Gary - As another poster has alluded to, the backplane of the switch
will determine your overall performance. Also, environment will need to
be looked at closely. How is your network currently setup? Do you have
multiple VLANs for different departments or are all your nodes on
multiple switches?

If you have many large files, you may consider a switch that can do
VLANs - yes it will cost you more, but you will segregate your
engineering traffic to one segment of your network and the other users
will thank you. Do you have a separate server for the engineering folks?
If so, you could put them all on the same VLAN and make life much
easier.

A VLAN basically allows you to take a modern switch and divide it up
into different network segments - this en lieu of putting a separate
router in each department which is the other way of accomplishing the
same thing.

Although my Cisco certification is not current, I am still a proud
holder of the CCNP/CCDP certifications.

Thanks,
Jason Claggett
Microsoft Small Business Specialist
MCP #3856159
2W Technologies, LLC
317.578.2393

[Non-text portions of this message have been removed]

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups. <http://groups.yahoo.com/group/vantage/files/.> yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups. <http://groups.yahoo.com/group/vantage/messages> yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.yahoo.com/group/vantage/links> yahoo.com/group/vantage/links
Yahoo! Groups Links







[Non-text portions of this message have been removed]
20
Sorry for not mentioning this sooner, but I was out of the office
and am just catching up. Also sorry if someone else mentioned this
already. But your code will not work after the end of the year.
When it is January 2008 and you apply your code to pull up the
previous month's records, your code will look for records with a
year of 2008 and a month of 0. You need to add quite a bit of math
to get it to work, but it is definitely possible.

-Peter Volkert
Symetrics Industries




--- In vantage@yahoogroups.com, "Gerard Wadman" <gwadman@...> wrote:
>
> It's working.
>
> Would you believe I had "Between" spelled wrong, I had "Bewteen"
>
>
>
> What a maroon I am.
>
>
>
>
>
> Previous: IIf([PUB_PartTran]![TranDate] Between DateAdd("m",-6,Date
())
> And DateAdd("m",-2,Date()),[PUB_PartTran]![TranQty],0)
>
>
>
>
>
>
>
>
>
>
>
> Gerard M Wadman
>
> Sr. Network Systems Engineer
>
>
>
> Scandius BioMedical Inc.
>
> 11A Beaver Brook Road
>
> Littleton, MA 01460
>
>
>
> 978/486-4088 x 124
>
> 978/486-4108 (fax)
>
>
>
> http://www.scandius.com/
>
>
>
>
>
> This e-mail is for the use of the intended recipient(s) only. If
you
> have received this e-mail in error, please notify the sender
immediately
> and then delete it. If you are not the intended recipient, you
must not
> use, disclose or distribute this e-mail without the author's prior
> permission. We have taken precautions to minimize the risk of
> transmitting software viruses, but we advise you to carry out your
own
> virus checks on any attachment to this message. We do not accept
> liability for any loss or damage caused by software viruses
>
>
>
>
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Chris Clunn
> Sent: Friday, April 13, 2007 9:27 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] OT (MS Access Help)
>
>
>
> I don't know if the between function works as a condition for an
iif
> statement. You could try using nested conditions, one for greater
than
> 6 months ago and then another less than 2 months ago. So...
>
> Previous:
> IIf([PUB_PartTran]![TranDate]>=DateAdd("m",-6,Date()),iif
(PUB_PartTran]!
> [TranDate]<=DateAdd("m",-2,Date()),[PUB_PartTran]![TranQty],0), 0)
>
> I may have missed a parenthesis somewhere but the idea should work.
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com> ] On
> Behalf
> Of Gerard Wadman
> Sent: Friday, April 13, 2007 9:09 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] OT (MS Access Help)
>
> Greetings gang,
>
> I'm trying to create some query conditions that will select
> transaction quantities from the Vantage PartTran table.
>
> Basically I want transaction quantities from the current month,
last
> month, and the previous five months.
>
> For the current month I wrote:
>
> Current: IIf(Year([PUB_PartTran]![TranDate])=Year(Date()) And
> Month([PUB_PartTran]![TranDate])=Month(Date()),[PUB_PartTran]!
[TranQty],
> 0)
>
> It works perfectly.
>
> For the Last month I employed the "DateAdd" function and wrote:
>
> LastMth: IIf(Year([PUB_PartTran]![TranDate])=Year(Date()) And
> Month([PUB_PartTran]![TranDate])=Month(DateAdd("m",-1,Date())),
[PUB_Part
> Tran]![TranQty],0)
>
> This also works perfectly
>
> For the previous 5 months I employed the "DateAdd" function with
the
> "Between" operator and wrote:
>
> Previous: IIf([PUB_PartTran]![TranDate])Bewteen(DateAdd("m",-6,Date
())
> And DateAdd("m",-2,Date())),[PUB_PartTran]![TranQty],0)
>
> This condition fails with either "to many arguments" or "invalid
syntax"
> depending on where I place the parentheses.
>
> Help!!!!
>
> Gerard M Wadman
>
> MCSE, MCP+I, A+, NET+
>
> Sr. Network Systems Engineer
>
> Scandius BioMedical Inc.
>
> 11A Beaver Brook Road
>
> Littleton, MA 01460
>
> 978/486-4088 x 124
>
> 866/486-4108 (fax)
>
> http://www.scandius.com/ <http://www.scandius.com/>
> <http://www.scandius.com/ <http://www.scandius.com/> >
>
> [Non-text portions of this message have been removed]
>
> This is an e-mail from Saab Barracuda LLC. It is for the intended
> recipient only and may contain confidential and privileged
information.
> No one else may read, print, store, copy, forward or act in
reliance on
> it or its attachments. If you are not the intended recipient,
please
> return this message to the sender and delete the message and any
> attachments from your computer. Your cooperation is appreciated.
>
> ###########################################
>
> This message has been scanned by F-Secure Anti-Virus for Microsoft
> Exchange.
> For more information, connect to http://www.f-secure.com/
> <http://www.f-secure.com/>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>