We're still using bear skins and stone knives so there's a lot I don't take for granted prior to 8.x. For all the "bugs" issues there is still a silver lining in the flexability and capabilities in 8.x.
Thanks anyway,
-Todd C.
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Moore, Tom
Sent: Thursday, June 05, 2008 11:30 AM
To: vantage@yahoogroups.com
Subject: RE: RE: [Vantage] [6.1] BAQ Question for 6.1
Sorry I was never on 6.1
________________________________
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Todd Caughey
Sent: Thursday, June 05, 2008 12:27 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: RE: [Vantage] [6.1] BAQ Question for 6.1
Can that be done in 6.1?
-Todd C.
________________________________
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 Moore, Tom
Sent: Thursday, June 05, 2008 11:26 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] [6.1] BAQ Question for 6.1
Setup a quick search for the BAQ this allows for input of start and end
dates
________________________________
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf
Of Todd Caughey
Sent: Thursday, June 05, 2008 10:35 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] [6.1] BAQ Question for 6.1
My boss has gotten deep into BAQs and now wants one he has written to
allow a user to select it from a menu and run it for a specific date
range. In this case dumping out a few fields from CheckHed to a
spreadsheet for checks in a given month. So he came to me to "make it
so".
I can get it on the menus and I can have it run for a date range but
short of revising the query code itself can't get it to prompt for the
date range. Is this even possible? Is there an SQL syntax for prompting
on items in the "where" part?
Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.
[Non-text portions of this message have been removed]
This e-mail transmission and any attachments to it are intended
solely for the use of the individual or entity to whom it is
addressed and may contain confidential and privileged
information. If you are not the intended recipient, your use,
forwarding, printing, storing, disseminating, distribution, or
copying of this communication is prohibited. If you received
this communication in error, please notify the sender
immediately by replying to this message and delete it from your
computer.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
This e-mail transmission and any attachments to it are intended
solely for the use of the individual or entity to whom it is
addressed and may contain confidential and privileged
information. If you are not the intended recipient, your use,
forwarding, printing, storing, disseminating, distribution, or
copying of this communication is prohibited. If you received
this communication in error, please notify the sender
immediately by replying to this message and delete it from your
computer.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Thanks anyway,
-Todd C.
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Moore, Tom
Sent: Thursday, June 05, 2008 11:30 AM
To: vantage@yahoogroups.com
Subject: RE: RE: [Vantage] [6.1] BAQ Question for 6.1
Sorry I was never on 6.1
________________________________
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Todd Caughey
Sent: Thursday, June 05, 2008 12:27 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: RE: [Vantage] [6.1] BAQ Question for 6.1
Can that be done in 6.1?
-Todd C.
________________________________
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 Moore, Tom
Sent: Thursday, June 05, 2008 11:26 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] [6.1] BAQ Question for 6.1
Setup a quick search for the BAQ this allows for input of start and end
dates
________________________________
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf
Of Todd Caughey
Sent: Thursday, June 05, 2008 10:35 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] [6.1] BAQ Question for 6.1
My boss has gotten deep into BAQs and now wants one he has written to
allow a user to select it from a menu and run it for a specific date
range. In this case dumping out a few fields from CheckHed to a
spreadsheet for checks in a given month. So he came to me to "make it
so".
I can get it on the menus and I can have it run for a date range but
short of revising the query code itself can't get it to prompt for the
date range. Is this even possible? Is there an SQL syntax for prompting
on items in the "where" part?
Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.
[Non-text portions of this message have been removed]
This e-mail transmission and any attachments to it are intended
solely for the use of the individual or entity to whom it is
addressed and may contain confidential and privileged
information. If you are not the intended recipient, your use,
forwarding, printing, storing, disseminating, distribution, or
copying of this communication is prohibited. If you received
this communication in error, please notify the sender
immediately by replying to this message and delete it from your
computer.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
This e-mail transmission and any attachments to it are intended
solely for the use of the individual or entity to whom it is
addressed and may contain confidential and privileged
information. If you are not the intended recipient, your use,
forwarding, printing, storing, disseminating, distribution, or
copying of this communication is prohibited. If you received
this communication in error, please notify the sender
immediately by replying to this message and delete it from your
computer.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]