Select a query showing only selective post codes relating a relevant postal area
please could you help as i would like to run a query only selecting relevant
post codes from my database. The post codes i would like to select are from
ST1 to ST4, ST6 to ST7.
Thank you spending time to help this issue
Message posted via AccessMonster.com
I assume that those are the starting three characters of the post code and
that the next character is a space. You could try a query using the criteria
Between "ST1" and "ST4 zzzzzz" OR Between "ST6" and ...CRM query a view
Ill explain it, you tell me what im doing wring....
I want to write a custom page for crm that loads up in an IFrame. Its in a
tab on the CASE window. it is SAPOSE to query the "FilteredTask" view and
return all the tasks for that case. I pass it the case ID(guid) no problem
there.. I can query tables no problem there either, but when it comes to
querying the view (filteredTask) if returns empty.
The WHOLE point of this is to have a page that i can print out with a
signature line on the bottom that conatins account information (account name
address, etc), case (incident) inf...Error Exporting Access Query Results to Excel
I'm having 2 different problems exporting query results from Access to Excel
I do what I've always done, in Access VBA get ADO recordset from query
results, instantiate Excel, get a range object, use the range object's
CopyFromRecordset method. This has always worked in the (pre-Office 2007)
past for me. It is much easier than iterating records and columns and
assigning values to cells. Now, I get an error -2147467259 Automation Error
Unspecified Error. I'm guessing this is because 2 of my recordset fields are
pictures in Attach...Append Query Re-run
I'm not sure if I'm on the right track. I have a MainForm and SubForm.
When tab to end of MainForm, SubForm is populated through an append query.
Works very well.
Here is my problem.
Let's say I have 5 questions and possible answers. When the append query
runs, I see the 5 questions and possible answers, I select the participant's
response and all is fine.
If I add other question(s) to the questions/answers table and scroll to an
existing ppt's data, I only see the initial 5 questions, answers, responses.
(New ppts are no problem, the append query run...Percentage query
tblid name ordered_bit
1 A 1
2 A 0
3 A 1
4 A 0
/*50 is the percentage (2/4)*/
, sum (cast (ordered_bit as float)) / cast (count (*) as float) * 100.0
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
i have just started working on this one, i need to find the smallest
out of a selected number of numbers, i cant use if forever, and i need,
a way to compare numbers as they are entered, and, the problem i ahve
been having is that the number hm to signify how many input's will be
taken keeps getting off track, and tips.
int total, a, i;
float average = 0.0f;
a = 1;
total = 0;
counter = 0;
/*numbers smallest out of all of them */
while (a == 1)
printf("enter how man...XPath help #2
I'm trying to use the XMLDataSource and DataList controls in Visual Web
Developer Express (VB.Net) to present the following rss file in a web
application. The problem lies in that I want to just select items (title,
description and link) that are in the 'april' category. Can anyone help me
with an XPath expression (or another way) of achieving this?
<rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"
I have set auto reply for a user, username is test (outlook rule – have
server reply using), gave the user “test” send on behalf “user1.”
In the From filed for the auto reply I am entering “user1”, but exchange is
not accepting this rule and disabling it.
I want the autoreply to be set on “test” user mailbox but going out from
Any ideas ??
MCSE NT/2000/2003,MCSA 2003 +M,CCNA
On Tue, 9 Aug 2005 17:37:27 -0700, "Nawar75"
>I have set auto reply for a user, username is test (outloo...Query Expression !
have a column EmailAlert that contain 0 & -1
can I have an expression if EmailAlert = -1 "e" otherwise Nothing
Thanks for any help..Bob
On Thu, 10 Jan 2008 12:31:24 +1300, Bob V wrote:
> have a column EmailAlert that contain 0 & -1
> can I have an expression if EmailAlert = -1 "e" otherwise Nothing
> Thanks for any help..Bob
Yes.In a query?
Please respond only to this newsgroup.
I do not reply to personal e-mail
...Query wizard problem...
I can't get the query wizard to show the columns from an Access database. I
get as far as showing the tree view of all the tables, but the tables won't
expand to pick columns. I've reinstalled Excel, and I've checked google and
the knowledge base...
Anyone have any ideas?
...excel: tricky formula/function question
howdy, all :) maybe someone can help me.
i have an interesting "problem" and maybe someone has the answer. i am using
i am trying to figure out a formula/function which can convert a small set
of numbers into a different set of numbers without manually using the "sort"
function. here is an example:
i have one column of seven rows with the following values:
i want to convert that into a different column, using formulas/functions so
that the new column reads:
basically, i want to take one colu...Refreshable web query problem
I have copied some stock info from the web and pasted it into Excel 2003.
According to the help, when I click on the paste options, I should have 3
options, one of which is to create a refreshable web query. I only get 2:
keep souce formatting or match destination formatting. There is nothing
about the refreshable web query! Why? What's going wrong?!
...tricky formatting Q (perhaps not so tricky)
.......this has been driving my wife and i crazy......but it's probably easy
stuff for some of you.
we have a list of currency amounts....$23.61, $54.67, $110.00, $54.30
in place of those numbers, what we would like are:
00002361, 00005467, 00011000, 00005430
so basically wanting to have an eight digit number, with zeros preceeding
the point that the number is displayed such that it is the last X number of
places to complete the 8 digit requirement)
is there a way to first do a check for the length of the currency
number....length as in number of places......and then return the ze...Query Refresh
I have a worksheet that has an external data source that refreshes
automatically. Each time a user opens this workbook, they receive a dialog
prompting whether or not they trust the source of the workbook. Their
option is to Enable automatic refresh or disable automatic refresh
I dont want this to appear. The worksheet should automatically, without
user intevention, enable auto refresh. How do I do this?
...Unwanted info in query
I have a Personnel database that I have created queries from, so as to show
relevant information for certain data I need to collect and show. However
there seems to be a problem, for example I would like to base a query on
staff type (we have paid, volunteer and placement), I need to be able to show
only paid, only volunteer etc. However even if I only select Volunteer for
the tables I want included in my query - it shows all the names.
What am I doing wrong!?
Please copy and post the SQL of your query.
(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the M...This is a tricky one #4
Does anybody else have any ideas for this problem
gymbag's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1622
View this thread: http://www.excelforum.com/showthread.php?threadid=27636
let'ssay you want to display the cell value of D28 on sheet2 in the cell A26
of this sheet:
1-click the cell A26
2-give the formula like this : =sheet2!D28
1-click the cell A26
2-type = and then activate sheet2 and click on cell D28
just like that!
Is there a way to enter 2 pieces of data in one cell. Such as .......
Cell 1 Cell 2 3 4 Cell 5
John Smith Address City State (123) 456-7890
I'd like to enter two phone numbers into one cell.
Type in the first phone number, hold down alt and press enter, type in the
second phone number
"Bill Fitzgerald" <firstname.lastname@example.org> wrote in message
> H...Combining Query Results
I am using an Access table to track sports schedules and games results. I
have created queries that total the wins for each team, another that totals
the losses and another for ties. I would like to bring these queries together
to get what amounts to the league standings. Really I just need to add the
losses count and the ties count to the wins query. Each of these values
(wins, losses and ties) is based on a Count field in the respective query.
Any help would be appreciated.
Thanks in advance.
Care to share your table structure. Or at least the three queries.
If your s...Passing Query Prompt to Report
I am using Access 2007 and need some assistance with a report. The report
is based on a select query that prompts for a date range. In the report is a
graph that is also associated with the same query. The graph changes based
on the dates selected. When the report is run the user is prompted to enter
the date ranges twice. I think I understand why....because the query is
called once for the main report and once for the graph. What do I need to do
to avoid being prompted twice. SIDE NOTE: I can avoid the duplicate prompts
by removing the Record Source for the main report ...Append Query
I am trying to append data from tblitemline to tblitemlist. I only want to
append new records. The unique field is ListID. I want to append 4 fields
total. I can't get it to limit it to new records. Any help would be
Show us the SQL. Open the query in design view. Next go to View, SQL View
and copy and past it here. Information on primary keys and relationships
would be a nice touch too.
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
> I am trying to append data from tblit...Running Sum in Union Query?
I have created a Union Query to consolidate results from separate queries,
each one of which represents results for a single month:
SELECT ReportMonth, MonthlyRev, MonthlyCost
SELECT ReportMonth, MonthlyRev, MonthlyCost
SELECT ReportMonth, MonthlyRev, MonthlyCost
This works very well for showing me monthly revenues vs. costs. However, I
would also like to be able to create a similar Union Query that shows a
running sum of the monthly revenue and costs. (Note: for reasons I won't get
into here, I h...Need help with Tricky SQL statement.
Give the business rules below. How can I obtain the desire results.
Thank you so much in advance. SQL 2005
IF OBJECT_ID('Tempdb.dbo.#t', 'u') IS NOT NULL
DROP TABLE #t
CREATE TABLE #t
LoanId INT NULL,
Reviewedby VARCHAR(10) NULL,
TaxesDueby1 VARCHAR(10) NULL,
TaxesDueby2 VARCHAR(10) NULL,
TaxesDueby3 VARCHAR(10) NULL,
TaxesDueby4 VARCHAR(10) NULL
INSERT #t VALUES (100003, 'John', 'John', 'Lisa', '', '')
LoanId ...Namespaces & .NET XPaths
Just out of interest - is there an easier/quicker way to retrieve values via
Xpath when namespaces are used?
At the moment I seem to need a lot more lines of code to do something I
thought was fairly standard? Of course I can just wrap the calls up into a
helper function but was wondering if there was an easier way...
XmlNamespaceManager nsmgr = new XmlNamespaceManager(doc.NameTable);
node = doc.SelectSingleNode("//xs:person",nsmgr);
... pluck from node...
XmlNamespaceManager nsmgr = new XmlNam...Queries-Based Distribution group
Is it possible to use Queries-Based Distribution group functionnality in
environment builded from Windows 2000 Activer Director and MS Exchange 2003 ?
If nof, how I can deny users from my exchange organization send emails to
all users in me organization ? Please, advice me
I have never tried this combination to get QB distribution groups to
work, but I think you can. Here is a really good article that explains
You can always restrict the maximum number...Combining query and table
Well, I have a table with fields like Quantity Borrowed and Quantity Returned.
I have a query with a field QuantityAvailable which is calculated based on
So, problem is I want to build a subform consists of this table and query
together yet user can enter themselves the QuantityReturned and next field is
the QuantityAvailable showed...
Message posted via http://www.accessmonster.com
Hey! Thanks for the idea...
But, I have created the query and appended it in my form. It can works but it
cannot automatically update as I enter the value in other fields.Any solution