Query Problem 03-27-10
I have 2 tables, tbBaby and tbVaccineInjection. tbBaby stores the babies'
personal data like Name, BirthDate etc., tbVaccine stores VaccineName,
DoseNumber (1st, 2nd, 3rd, etc.) and InjectionDate, etc. These 2 tables are
one to many in relation, because each baby may have several vaccinations on
I'd like to build a query to retrieve babies with their most recent
injection date, i.e. only one record for each baby with latest injection date.
my query is as follow
SELECT tbBaby.*, tbVaccine.*
FROM tbBaby INNER JOIN tbVaccine ON tbBaby.ID=tbVaccine.B...Append query bloat
I have an access database where I use an append query quite often. I will
use this same query over and over by changing the table I'm appending from,
then I save the query. During the save process, the database bloats from
~50KB to ~150KB. Our company recently upgraded to 2007 and that is when I
noticed the problem. Is there a way to stop this from happening? I can
manage it by compacting and repairing after each save, but recently I added 4
tables in one day, so this was a pain.
Don't even worry about it. An Access file can be up to 2 GB in size. 150 KB
I tried to put this sign (&) in my custom header. It's there when I type it
but not when I view or print the page. What do I need to do?
Excel 2003 - Windows Professional 2000
If you enter a double ampersand && one will be printed.
> I tried to put this sign (&) in my custom header. It's there when I type it
> but not when I view or print the page. What do I need to do?
> Excel 2003 - Windows Professional 2000
tricky! but thanks sooo much. I'll use it next time - for that report I...Does SQL Run Behind Queries?
When I run a query does Access, "go away" and run the SQL for what I see in
If the answer is, "yes" is there anything that I can switch on to see the
SQL that it is running?
What I would like to do, if it is possible, is to see the query in the GUI
and, at the same time, see the SQL that is being used to select the data from
the database; that way I can understand things (exactly what is happening)
more clearly and more quickly.
TIA for any replies.
> Access 2007
> When I run a query does...Formatting numbers as a percent without the % sign
I'm trying to format a number like .0235 as 2.35. If I use %, thenthe result
is 2.35%. I just do not want to % sign. Does anyone know if that is
possible to do through formatting? Multiplying by a 100 is not an option in
Two steps in XL2003:
1) Select the range you intend to use as your percentage range
2) Format. Cells, Percentage (and set the number of decimal paces).
"Rich Young" <RichYoung@discussions.microsoft.com> wrote in message
> I'm trying to format a nu...Database Query #4
I have created a data table in a worksheet and named it “data”. Then I
created a separate worksheet, in the same workbook, and created a database
query of the data table, by using Data…Import External Data…New Database
Query…Excel Files* and defining the database name by browsing to the same
workbook. The query worked fine. However, when I moved the workbook (which
included the data source) to a different folder and tried to refresh the
database query, I got the following error message:
“[Microsoft] [ODBC Excel Driver] The Microsoft Jet database engine could not
find the object ‘data’...DNS clients Does not query the secondary DNS
I have 2 w2003 Dcs - both DNS servers Primary and secondary.
I have Clients running XP static Ip and in both DNS servers IP is configured
as Primary and Secondary DNS.
My Primary DNS server went down, all clients are not quering the secondary!
using NSLOOKUP it showed that clients are still querying the primary with a
tomeout error !! all name resoultiond stoped in the organization!
NsLookup does not automatically fall through to alternate DNS servers,
it is not a good way to test server redundancy.
If you ping a host, which will use the DNS Cl...Calculate difference in rows in a query
I have a query that calculates how much revenue is claimed by month per job
but then I have to take the new month less the prior month. The problem is
the data is in row format. I don't know how to subtract February from
January, March from but don't know how. I know how to do it in Excel but not
Access. Please help...
Order Month JTD Clm Variance
101026521 January $511,525 $0
101026521 February $511,525 $0
101029438 January $1,238 $0
101029438 February $3,713 $2,475
101033168 January $21,465 $0
101033168 February $51,460 $29,995
101034011 Janu...How to use colmn headings in paramter query
Sorry if this has been asked before, but I am not able to locate it if it
has. But here is my delima:
I need to be able to select the salesperson sales based on the month (1-12)
from table 1. I* can create a parameter query, but am not sure hwo to query
onlya certain month.
ID salesperson 1 2 3 4 5 6 7 8 9 10 11 12
1 joe 12 0 0 2 12 0 1 1 5 7 8 10
2 steve 2 5 6 18 0 0 2 3 4 11 12 1
select * from table1 where salesperson =joe
that is where I get stuck. I need to be able to select a column he...Extracting invoice data from GP 9 using a SQL query (ODBC)
I'm working to extract invoice detail information from a client's GP 9 MSSQL
database, with the goal of being able to mock up their invoices in external
systems. Just to keep things interesting, they aren't using GP to it's
maximum ability - quotes are generated from another software package, and
when converted to a sale, minimal data is entered into GP and processed (such
as shipping address, job name, job number, PO number, and occasionally a line
it of what appears to be free-form text. I have hard copies of several
invoices, various web resources, and access to t...Query Does Not Count "2" Records
Good Evening Everyone...
I have a bit of a logical puzzle that I need to solve. I have various
queries which have various criteria for them. One query involves
retirees or spouses being under the age of 65 and the other involves
retirees or spouses being over the age of 65. Both the retiree and
spouse are listen in the same records and on one line of the master
table and queries. The situation that I am running into is that I can
have a retiree who is over 65 and a spouse under 65 and the record
comes up twice in the two different queries b/c it meets the criteria,
which is perfect. What...Web Query Help...
If I try and use a web query with the following site
I get a message that says the web query returned no data. I click on the
arrow right by player and it highlights all the players names and their
stats. Anyone know why it doesn't import the data into excel? Is there too
much data? Thanks
Works fine for me, although one have to do some editing since it imports
some trash as well (I would import it, then select the table itself from the
import and copy and paste into a new sheet, then import the next 50 and...Fetch XML to Query Expression
I'm trying to convert the following Fetch XML statement to a Query
Expression to post using the RetrieveMultiple webservice:
<attribute name="name" />
<link-entity name="systemuserroles" from="roleid" to="roleid">
<condition attribute="systemuserid" operator="eq-userid" />
I haven't been able to find an documenta...Query Output
I am working with make table queries. I have a A make table query and a B
make table query each with various information that the query has preformed.
I am trying to get the following output into a text file.
A Make Table Information
B Make Table Information
A Make Table Information
B Make Table Information
There are over 300 items in each table. Each A Corresponds with a B. I need
to keep the 2 records separate for where i have to upload them.
I tried having a common identifier for the two tables and creating a big
query with all the information on, but i ...Query-Based E-mail Groups
I have created query-based email group that contains 1,600 users. When I
send an email to that group, about 350 users don't get the message. I as the
owner of the group get an undeliverable stating:
The e-mail system limits the number of recipients that can be
addressed in a single message. Send the message multiple times to fewer
recipients. For all 350 users.
So I check my "Message Delivery Properties" in ESM. I have my "Recipient
Limits" set to 2,000. I double checked the query-based email group to make
sure it was under 2,000 recipients and ...Suggestions for table or query to track movement
I have a table for employees that includes the usual description fields for
employees. This is one of my master tables with the employee ID being the
primary key. Then I have another table that stores all employee hours that I
add on to monthly via an import from Excel (emplID is foreign key). I want
to keep track of all of the employees that are new or terminate. I’d like
Access to recognize if an employee is missing or new and later be able to
create a report for recent new hires or terminations. I may be expecting
too much and if so please give me your opinion on this. ...Calculating the Difference in a Query
I need to calculate the difference between two fields in a query. The query
is called “qryRemote” and within the query are the fields “10-8Time” and “10-
97Time”. The data entered into these fields are in the format “0000” through
to “2400”. I need to subtract the “10-8Time from the “10-97Time” and then sum
the results and display the result in a report.
For example, after the query is run the results are:
First the difference is determined: 10-8Time is subtracted form t...Outlook 2000 Calendar Text Entry query. Help!
Husband and I are both retired and have never used Outlook before, even
though it's installed on our home computer.
Now that we have more time on our hands, we're using the Outlook monthly
calendar: we print out a "blank" month at a time, pop the page into a ring
bind folder, and then write (by hand) notes on the various days.
We would like to be able to do this on-screen though, rather than with a pen!
We're planning a day-by-day schedule for a holiday next February but we
cannot work out how to "write" timetable notes into the squares for each
I need help!
I am trying to copy a long list of queries from one access database to
I tried "get external data", but it brought the actual data from the old
database with the queries. Export will only allow me to move one query at a
How do I move a whole list of queries?
Go to the other database and import them.
"Amanda P" <Amanda P@discussions.microsoft.com> wrote in message
> I need help!
> I am trying to copy a long list of queries from one ac...Offset Formula Query
I am using an offset formula to bring back data.
I am trying to bring back the cell next to the one that has a label that
matches the file name e.g. the file name is Place and then column a contains
a list of places and column b contains text about those places.
I am using the following formula:
Where Data! refers to the sheet which contains the data and t...Query assistance 10-18-07
I have 2 tables and I am looking to create a query that will display the data
only if it exists in both tables. I have been doing this in the past by
running 2 unmatched queries, but I am assuming that there must be a faster,
better way and I am hopeful that someone here could help.
IF the data has to exist in both tables you could just join the tables on
the relevant field(s). With an inner join the data would have to be in both
tables to return any record.
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore...Signs of record corruption?
What are the signs of record corruption in Access 2000? That is, how
can I tell if any of my records are corrupted?
I have one record with Chinese characters - is this a sign? How could
I write a query or VB code to isolate them?
I did have a condition on a form event that I think may have led to
corruption which I think I have now solved. How can I write a check
routine to verify my fix by looking for anymore corrupted records at
the end of each user session?
Cheers for any ideas or pointers,
The "Chinese characters" or weird symbols certainly are likely to be
c...Fail to create IXSSO.Query object
I'm moving classic asp sites from Windows 2000 / IIS 5 to Windows 2008 R2 /
* We have the "Indexing Service" started.
* I have forced IIS to run application pool in 32 bit mode.
* IXSSO.DLL is present in System32 directory. (dated 7/13/2009 it is from
W2k8, I assume it is 64 bits)
* Catalogs were created and looked OK.
However, I am unable to create an ixsso.Query object.
Get the following error message :
Microsoft VBScript runtime error '800a01ad'
ActiveX component can't create object
/HC/ECO/Announcements/Headlines/SearchResul...Update label and record query steps
I have a time consuming import code which has multiple steps. I amend the
label caption to show which step the import is on but would like to show all
steps and if possible place these steps in an archive table as the process is
run by several users.
At the moment I have:
1 - Preparing import......
which is replaced by
2 - Importing cust table 114,240 records (est. dur. 1 min).........
which is replaced by
3 - Importing sales table 842,600 records (est. dur. 4 mins).......
What I would like is:
18/02/2010 23:30:30 - Step 1 - Pre...New column in query
I have the following columns in my query empid, courseA, datecompA, courseB,
datecompB, courseC, datecompC. What I need is an extra column that will have
an indicator Yes if any of the 2 dates(i.e., datecompA, datecompB, datecompC)
have dates, blank if all 3 dates have dates and No if only of the dates has
Based on your description of the fields you have in your query, it sounds
like you are working from ... a spreadsheet!
Is this a query based on a "linked table" (linked to an Excel spreadsheet)?
If not, and if this is an Access table, your database would benefit ...