finds and concatenate
I have a situation where in cell A1 , there is a date .
what i want is that a macro which upon finding a date format in colum
A,picks up cells below that date column and which would be A2 and als
picks B2 and combines them (like concatenate) and inserts a colum
before column B and puts them adjacent to the date column.
like if we have a date column as cell A1, what this macro shud do is i
cell B1 there shud be a concatenate of A2 & B2.
can u guys help
thank u so muc
Message posted from http://www.ExcelForum.com
why not use a formula. e.g. the following in C1:
=IF(ISNUM...How to insert and query nodes?
I need to use XML to store some log data and then query that data. I'm
struggling with the right terminology, which is hindering my ability to
successfully search for a solution. Thanks in advance for your help!
1. In VB.NET, how can I append new "Log" record to a "Site" record?
2. How can I query all of "Log" records in a single "Site" for an average
<?xml version="1.0" standalone="yes" ?>
<Site Host="www.mysi...Query with IIF Expression Need Help
I have a query which has the following fields:
I have added another field in my query named ROOMS IN as an expression where
I want it to return TODAY by looking at another table which has only one
record which is the running date table name:RUNDATE and field DATE and then
looking at the arrival date and adding two days if applicable to return to
the expression field LINEN "TODAY"
LINEN: IIf([ARRIVAL]="([RUNDATE]![DATE]+2)";"TODAY";"2 DAYS")
it returns 2 days to the other records which is fin...Query: date is null
I am trying to write a query to call up records where no date is
entered (i.e. null). However, when I go to run the query it gives an
error of data type mismatch.
What have you tried?
Criteria: Is Null
IF the above doesn't help, please copy and post the SQL of your query.
(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Paste it into the message
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
...number query results
Hopefully I can explain this well enough, I have a database set up to track
product key attributes. Works great. I have a query that will pull the last
9 records where the line and product code match. This also works great. I
need to graph the last 8 hours of lets say "moisture" with the difference
between each hour also graphed (i.e. 8:00 = 4.5 and 9:00 = 5.0 I need to
graph a .5). I have a form to show the query results. My goal is to have an
unbound field that will "number" the query results in the form so that I can
return the value of "query record #8...SQL vendor query
Hi Guys -
I need to write a query that will show all new vendors added each day. This
idea is to write the query and shoot it off via email every day using sql
reporting services. I am having problems writing the query. Any suggestions.
There is a field in Vendor Master table (PM00200) called "CREATDDT". This
field will be filled with the date in which the vendors are created.
Now your query can rely on this field to list out the vendors on a
particular day. For instance, if I want the Vendors who are created on 21st
Aug 2009, I would write my query like this:
S...External web query
I am not a programmer and a new excel user. I have an external web query
that I am using tracking external links from a web site. I need to create
an additional column with the web page info that relates to where the link
is coming from. I tried but when I refresh the data it inserts cells with
the any new links listed but then that throws off my additional column
info. I looked in Data Range Properties and checked the middle option but
that doesn't work the way I thought it would. Suggestions?
Message posted via http://www.officekb.com
...Web Query #4
I'm not really sure if this an Excel issue but here goes. I have a file set
up that gathers data from a web page. It updates web hits and other data
from the page on a daily basis, the only problem I have is that I either
have to leave the file open 24/7 or manually open it each day.
I've no problem using code to place the updated data into the appropriate
date columns and saving, it does that already, but is there any way of
getting an Excel file to open automatically at a specified time, update
itself via the code and then save and close?
Vi...Drop downs to select queries
I have a very large database (by my standards) that holds details of
35,000 products that I need to produce price lists for. It relies on
information produced by others that I have no control over and is
frankly a dogs breakfast as far as standardisation goes. However I am
stuck with it.
Products fall into Groups and Categories within Groups then sizes and
prices within Categories.
I have laborishly marked each product as to the Group and Category
with Yes/No fields for the Groups and a combo box drop down for the
Category so I end up with each product having a tick in one of 10 Yes/
No fi...Microsoft query criteria help
I am using microsoft query to get external data into excel and would like to
filter info for forecast date greater than todays date i can type in todays
date but would like to use formula =now() so can save query and use whenever
required is this possible?
...How to accept input and then populate/concatenate this with other
I need assistance with integrating the following within a macro I have.
Ask the user to enter a 4 digit YEAR.
Cell AM1 should be populated with the word Start.
Cell AN1 should be populated with the word End.
Cell AM2 should be populated with 01/01and the 4 digit year entered above.
Cell AN2 should be populated with 01/03 and the 4 digit year entered above.
Cell AM3 should be populated with 01/04and the 4 digit year entered above.
Cell AN3 should be populated with 31/08 and the 4 digit year entered above.
Cell AM4 should be populated with 01/09and the 4 digit year entered above.
Cell AN4 shou...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?
...Having Trouble With Query Criteria
I have a query where I want to select records based on a name in the
"Assigned To" field. The user selects a name from a list on a criteria form
and the query takes the name and selects records with that name in that
field. This part is easy.
However, if the user does not select a name on the criteria form, I want the
query to return ALL records.
I don't know how to choose between these two possibilities. I can set up the
query to run one or the other, but I don't know how to conditionally choose
Does anybody know how to do this?
in that case...MRP Query question
Feel free to point me to a better forum as this is really a SQL question.
When MRP is regenerated info on each regeneration is stored in MPPS0130. I'm
trying to construct a query against the MRP months table (MP010330) that will
return details on each row where the date value is greater than or equal to
the highest run date value from MPPS0130.
I'm using the MAX function to find the highest date from MPPS0130 but when I
try and compare that against the dates from MP010330 the query errors out.
Any guidance would be appreciated.
Nevermind - got it to work us...ldap query for address list
my organization is now migrating from exchange 5.5 to exchange 2003. after
migration, i just couldn't find a way to get that sorting of address book
view like in exchange 5.5 that sort the gal by grouping (e.g, sort by company
will it is possible that the custom ldap query will do sorting like sql
statement (group by) or (order by)?
...ddv custom Query
I try to write to write a custome validation which is quite similar to
It checks if the values grater zero:
void DDV_ValidateInput(CDataExchange* dx, double value)
if (value <= 0.0)
AfxMessageBox("value should greater than 0 ");
I place it under do_dataExcahnge.
It will pop up a message box with the warning if the user enter an
However once I close the message box, the process will continue
It is unlike with ddv_minmaxDouble(). The user is not allow to do
anything other things before changi...Grouping dates in Microsoft Query
is it possible to aggregate lots of daily billing dates to 12 months in
Microsoft Query, before returning the data to Excel?
Thank you in advance.
Can you give an example of what the output would look like?
On Feb 2, 7:00=A0am, "H.G. Lamy" <Enterp...@web.de> wrote:
> is it possible to aggregate lots of daily billing dates to 12 months in
> Microsoft Query, before returning the data to Excel?
> Thank you in advance.
> Kind regards,
> H.G. Lamy
J...Execute query from textbox input
I have a form which has a query made up of a few other queries (this may be
an incorrect thing to do) as the Record Source.
It has a three textboxes on the form in which I need each one to perform a
specific query associated with that textbox. In other words, the user types
in a number, presses 'Enter' or 'Tab' key, then the query (maybe needs
another mechanism) associated with that entered number will execute, and it
will display the relevant results in the form. This is the reason I used a
query containing the need queries as the form Record Source, so I could bind ...Query Personal Address book -v- Contact list
If I have understood what others are saying about Outlook 2000, Personal
Addresses are .pab files and Contacts are .pst. I was not aware of the .pab
files. I have recently changed from Outlook Express to MS Outlook (2000) I
am running XP Pro and Office 2000. When I upgraded from OE I seem to have
the majority of my previously used contacts (some are missing for some
reason - especially the group contacts). I though I should be using
Personal Address so followed the following MS instructions:-
1.On the Tools menu, click Address Book.
2.Click New Entry .
3.Under Put this entry, click Pe...Microsoft Query is changing a negative number into a date
I am using Microsoft Query to pull a subset of a large excel file however two
of my columns which are suppose to be numbers are not pulling in the negative
numbers. If I look at the query in microsoft database the number shows up as
a date/time string. I've tried formatting the original number as a number
but the query still won't read the negative number. How do I get the query
to read a negative number as a number and not a date.
Highlight the columns and format as a date
> I am using Microsoft Query to pull a subset of a large ex...Read Excel, CSV and Tab delimited text files with an SQL query for Customer and Item imports to RMS
On May 13, 6:35 am, convoluted <convolu...@discussions.microsoft.com>
> I don't know how to have your update or insert query read an excel
> spreadsheet, maybe someone more experienced with SQL will reply........
How to link sql server to an excel spreadsheet
1. Create a folder that SQL server has rights to access, EG: C:\Data
2. Place your spreadsheet in the folder EG: ConvolutedSomething.xls
with a worksheet called MySheet
3. Create a linked server to tell sql server about your folder
3.a You can do this with a script but I prefer...Update Query
I have two tables, Employee and Gaptable. In the employee table I have a SSN
field (social security number) a UPI field (unique personal Id numer) I want
to update the UPI field in the Gaptable where the SNN field matchs from both
tablle. How would I write the query for this? I hope it is clear enough.
if i am understanding you, it should be a basic Update query. Here is
UPDATE Employee INNER JOIN Gaptable ON Employee.SSN = Gaptable.SSN SET
Gaptable.UPI = Employee.UPI;
Note I assumed the field names were SSN and UPI in both tables. you
may need to modify accordi...Max Date Query w/ Nulls
I've got a situation where I need to run a query that pulls data from
two different (but related) tables, and then lists the most recent
date for each entry in the second table.
The two tables and fields are
Each Property can have multiple inspection dates.
My goal is to have a report that provides the PropSiteName, PropStreet
and InspDate, with the information sorted by the InspDate that also
shows the null records (properties that have never been inspected).
Is there a way to do this wi...Update query with date criteria
Hi all. I have an update query that should only update a record if today
falls between the 1st of it's month and the 7th of the following month. For
instance, if the record date is 11/15/2009, it should only update if today is
between 11/1/2009 and 12/7/2009, or if the record date is 10/6/2009 is should
only update if today is between 10/1/2009 and 11/7/2009. Here's the criteria
I was trying to use, and I was using this criteria in the field that I want
to update if the criteria is true:
I have a spreadsheet that is querying the same database 25
times with 25 seperate worksheets. I get the following
message when I automatically run the query at file open
[SSDB] Too many tasks in use in the current app in FA_Task
I click OK and then get the following message.
[Microsoft] [ODBC Driver Manager] Driver's SQL Set Connect
Am I running too many queries in 1 spreadsheet?
Thanks for any suggestions.