|
Sort The Address
I have mailing list that have names and addreses with Apt #'s How i can sort
in the access i know very little about the SQL Please help me
Thanks
...
|
3 |
11/27/2008 4:51:28 AM |
|
|
Trouble with Lookup - need something similar to VLookup
Background:
(I've been using Access for a few years and know enough advanced techniques
to get myself into trouble, but not out of it!) I have a table (tblSurveys)
that tracks survey results for several projects (tblProjects). I need to
create a report that shows various statistics (Count, Average, etc.) based on:
1) the current week (I can get these just fine),
2) the fiscal month-...
|
4 |
11/27/2008 12:38:29 AM |
|
|
Query Help
Good Afternoon!
I am in need of some help with a query i am doing. i cannot get what i am
looking for.
there is a table, sort of a transaction table, that i am working with. it has
a key field, which in this case pertains to the weeknumber of any given week.
then there are some job id's and then some numerical data, and i need to
track differences from week to week. i will explain furt...
|
2 |
11/27/2008 12:14:00 AM |
|
|
Set Warnings in MS Access 2007
Hi,
I just migrated from MS Access 2003 to Ms Access 2007.
No matter what changes I make in a table, query, report or macro there are
no set warnings asking the obvious: Do you want to save?, Yes, No, Cancel, etc
How do I set these warnings back?
Thank you,
...
|
4 |
11/26/2008 10:18:00 PM |
|
|
Convert today's date -7 days to week YYYYWW (last week)
Is there a more efficient syntax to convert today's date -7 days to week
YYYYWW (last week), then the SQL below? Result = 200847
WHERE (((a11.week_id)=Format(Date()-7,"yyyy") &
Format(Format(Date()-7,"ww"),"00"))) This took 16 mins.
Replaced hardcode: WHERE (((a11.week_id) In (200847))) This took only 5 secs.
SELECT DISTINCT a12.department_id, a13.department_desc,
(0.001+Nz(Sum(a11...
|
5 |
11/26/2008 9:09:03 PM |
|
|
Unattended Append Query
I am running Access 2002. I have an Append Query that I want to run every
morning at 12.01 AM. Is is possible to have this query run every day at the
time specified without being logged on. If not possible being logged off,
then I can work out being logged on.
Any help in this area would be greatly appreciated.
--
Bruce...
|
6 |
11/26/2008 6:40:01 PM |
|
|
Query Equation
I am creating a database that tracks the movement of all animals and keeps
the inventory of animals at three separate units. When animals move are sold
or die they receive a record number called a "disposition number", these
records go into tblDispositionRecords. tblDispositionRecords has several
fields, two are "Unit" and "NewUnit", this two fields track the animal's
physical location...
|
3 |
11/26/2008 6:20:01 PM |
|
|
Update Query for only a certain number of records
I have a table that I am trying to assign employee names to certain number of
records. I understand how to use an update query. But I can't figure out
how to do this.
This is what I'm trying to do. I have a table with 20 "Atlanta" records. I
want to assign anything with a criteria of "Atlanta" to "Bob Smith" but I
only want to assign 10 of those "Atlanta" records to "Bob Smith" and ...
|
2 |
11/26/2008 5:32:01 PM |
|
|
How to use WHERE NOT EXISTS
Hello All
i have need to make this SQL work. i have 3 sets of data, 2 sets will never
have the same data, the 3rd can duplicate things that are in the other 2
sets. i need to combine all 3 sets into one set that has no duplicates from
the 3rd set.
additionally after combining the 3 sets i need to add some additional
related fields based on the part numbers in the resulting set of da...
|
3 |
11/26/2008 5:29:02 PM |
|
|
do not show duplicates
ok in my inventory we have a bunch of product made from the same batch and i
might have 20 total of one item, and all the information is the same. is
there a way to remove duplicates. so instead of 20 total i will show 1 of
each batch?
is there something easy i can put in the Criteria of the query to eliminate
duplicates
...
|
5 |
11/26/2008 5:21:00 PM |
|
|
Trim Last Name
How can I retrieve the last name only from a field formatted like First Name,
Space, Last Name (John Smith)? TIA
Bill B....
|
2 |
11/26/2008 5:14:51 PM |
|
|
Criteria Coding in queries
There is a code in the Criteria field and I am trying to figure out what it
is doing. Could you help me? The criteria is under the SPID field
[Forms]![frm Service Purchase]![subfrmServicePurchase]![SPID]
Thanks...
|
2 |
11/26/2008 5:08:35 PM |
|
|
Parameters Question
I have a query with two parameters. One is a date range and the other is the
region (Region 1 through Region5). They trigger this query in a param form.
In the drop down they use to choose what region they want to search by, I
want a option of all regions. I don't know how to give them that option in
the drop down or in the SQL of the query.
The current SQL language follows:
SELE...
|
3 |
11/26/2008 5:01:01 PM |
|
|
subfrm/query
I have a form that has a subform which is based off of a query.
I have a button on the form that pulls master data values such as unit cost.
When the record is first created and everything works the way it is supposed
to.
However, when I go back into the record adn click the button I get the value
you entered is not valid for this field which I am assuming that the sub form
controls hav...
|
1 |
11/26/2008 4:21:02 PM |
|
|
Query(s) to return training hierarchy
I posted this question before but didn't get anywhere with it.
I'm an Access beginner, relatively speaking. I've created a query (and
report) which returns a list of employees, grouped by each
training/certification, with the date the training was completed and a
calculated field that returns when the training expires. (Trainings are taken
individually or by small groups) I was then infor...
|
1 |
11/26/2008 4:18:20 PM |
|
|
Many to Many Relationship
Thank you in advance for your help. I would like to create a form that
captures laboratory reference ranges from many different labs. Each lab has
a unique lab code assigned and I have a table for LabID which include Name
and address.
Each lab collects the same test results (i.e. glucose, calcium, potassium
etc..). They may have different units as well as Male and Female ranges.
I...
|
1 |
11/26/2008 4:03:00 PM |
|
|
Remove leading spaces
Sometimes when importing a table from Excel, a leading space gets inserted in
the field, which messes up queries. I tried to remove this space with a find
and replace (this column shouldn't have had any spaces), but to no avail. I
wound up removing them by hand.
Is there an easy way to remove leading spaces in a field?
Thanks in advance,
Ellen...
|
5 |
11/26/2008 3:14:04 PM |
|
|
Please help with this line?
GROUPNAME: DLookUp('" & Left([JOBNUMBER],1 )"' &
"00","tblPROJECTGROUPS","[GYEAR]='" & [Job List].[YEAR] & "'")
This works
","tblPROJECTGROUPS","[GYEAR]='" & [Job List].[YEAR] & "'")
This doesent
DLookUp('" & Left([JOBNUMBER],1 )"' & "00","
...
|
2 |
11/26/2008 2:46:23 PM |
|
|
Select Limited records for a number of criteria
Hi all wonder if you can help. I would like to run a query that would enalbe
me to extract a limited number of records for multiple criteria. For example
have a table that has 36,000 postcodes, for each area I want to extract a
certain number of records i.e.
AB = 200 records
AL = 69 records
B = 500 records
I understand how to do this using a single query for each crtieria, but could
r...
|
2 |
11/26/2008 2:45:00 PM |
|
|
> and <
Hi Anyone
I am trying to build an IIf formulain access with a true if a number is more
than 99 but less than 200. Everytime it comes back that I am missing details
Coomma or closing Par. Could anyone please help me with this
--
Kind Regards
Paul Smith...
|
6 |
11/26/2008 2:16:30 PM |
|
|
>Greater than and >less than
Hi. What should seem like a simple thing is baffling me. I want to build an
iif query that requires a greater and less than paramiter and I am struggling.
Can anyone offer help please
...
|
2 |
11/26/2008 1:51:06 PM |
|
|
PUT TOTAL AT THE END OF A COUNT QUERY
Hi,
I have a table with items & their quantities.
I have a count query
field1 are items.
field2 is quantity.
When i count(i.e.query) I get items & total of quantities against them
in adjacent column.
In count query, how do I put the word "Total:" at the end of item list
& sum(quantityfield) under the quantity field.
Example:
Query should look like below.
field1 field2
a...
|
4 |
11/26/2008 12:37:32 PM |
|
|
Lost in SQL statement world.
Hello,
I can’t wrap my head around what I thought would be a simple query.
I have 4 tables
tbl_clients
clientid
firstname
lastname
…
tbl_instl
intlid
clientid
simple
…
tbl_servicing
servid
clientid
servtype
…
tbl_comp
compid
clientid
comptype
…
All the tables are on a 1-many relationship to the tbl_clients table.
Now I have a form where the user ca...
|
2 |
11/26/2008 12:06:34 PM |
|
|
joining crosstab queries
I read in one post that joining crosstab queries using UNION may be a
redundant idea- but I'm afraid it was a little above my level!
If anyone can offer help here, i'd be most grateful.
I have two crosstab queries extracting different scores from patients across
time. As there are more than one type of score I am assuming I need a query
for each. I would like to combine these so that i can...
|
2 |
11/26/2008 3:46:01 AM |
|
|
Saved query doesn't select all info in Memo field.
I have several saved queries many which pull information from Memo field.
However, only the first 255 character are being retreived, but need them all.
Is there away to specify the field data type for a query field in the
QueryDef?...
|
8 |
11/26/2008 3:41:41 AM |