|
Challenging query
Hi everybody!
I have 2 tables in my database, a table with Buildings and a table with
inspections of those buildings.
One table has buildings with data related to them, and the other one has
inspection dates with inspection-related data.
The below tables resemble my actual tables. These are the rules for both
tables:
-No building can appear twice in the Building Table. H...
|
2 |
12/24/2008 9:58:58 PM |
|
|
Batch Add Records with certain criteria
I am trying to create the queries needed to accomplish appending multiple
records to a table. I am using a form to receive user input.
The purpose of my process is for the user to enter multiple employee
"tickler" records into the system at one time. The form accepts values for
the following:
tickler_owner (combo box)
tickler_code (combo box)
begin_date (text box)
end_date (text box...
|
1 |
12/24/2008 8:25:00 PM |
|
|
Access 2000 Query Question
Hello everyone,
Is it possible to change a record in a select query without having to
use a update query?
Example:
Product Line Testing Code
1 1
1 2
1 3
What I want is if the testing code = 3, can I change the label to a 2
instead of a 1 wirhout using a update query?...
|
2 |
12/24/2008 5:27:48 PM |
|
|
access query
I was working on this before but I lost track of it. On a form I would
like to return a value from a table. The table has 3 columns min amt and
maximum amt and a number that applies if this amount on the form meets the
criteria...between the minimum and maximum amount. I would like to do it
onthe form, but if not, then in a query,
Thanks.
ps dont know SQL, has to be ver...
|
2 |
12/24/2008 5:25:46 PM |
|
|
Enter Parameter Value
I have set up a select query that sums multiple fields. I have entered
criteria that prompts the user to enter beginning and ending dates. After
these prompts I am being asked to enter values for SumofLotSize and Totals.
After pressing enter without entering any values for these two fields the
query runs as it should. I will not be the only user accessing this query.
Is there any way...
|
2 |
12/24/2008 5:23:50 PM |
|
|
reformat data field in a query?
Hello,
Can anyone point me to an example where I can do the following?
I have a date that is not defined as a date but simply a character
field, say 01/24/2008.
How can I reformat this date to be say 2008/01/24 in a query? Is that
possible?
I have a payroll query that I want to extract records that are greater
than say 12/21/2008 and less than 01/05/2009; but obviously, that
query...
|
2 |
12/24/2008 4:32:10 PM |
|
|
Access 2007, Using A Datasheet Column to Query Another Table
Hi
I have two tables that are used as the source for lookups in a third table,
one called Process Group and one that is called Knowledge Area. The third
table, from which lookups are performed is called Metadata.
Each Process Group row has one or more Knowledge Area rows.
Each table has a primary key. The Knowledge Area table has a foreign key to
the primary key in the Process Group Tab...
|
1 |
12/24/2008 7:30:01 AM |
|
|
For Duane Hookom... (concatenate fields)...
Dear Duane,
As you know I am using your function.
aaa: Concatenate("SELECT Time_ranteboy & ' (' & aitia_pros & ')' FROM
RT_AM_ranteboy
WHERE date_ranteboy =#" & [date_ranteboy] & "#")
How is possible to return the concatenated field [Time_ranteboy]in 24hours
time format and not
like e.g. 10:30:00am
many thank's
/kostas
...
|
6 |
12/24/2008 5:36:01 AM |
|
|
Help with attendance query
Hello-
I have been working on an attendance report for my department and have
one final hurdle. My query will show any rep on a write up for
attendance along with the level of the write up (severity) and what
has happened since the last write up took place. There are 5 write up
levels, 1 being the first step, 5 being termination. We track write
ups in 6 month intervals, meaning that if you...
|
1 |
12/24/2008 1:44:37 AM |
|
|
Querying a day of the week
I have a table that has a Time/Date field and I want to query just the info
from Saturdays. The field is formatted in the long date format so it includes
the word "Saturday". How do I write the criteria?
I have tried "Like" and it dosn't work. I have used that before to query
street names that were in the same field with the rest of the billing address
with no problem.
I tried changi...
|
2 |
12/24/2008 1:07:16 AM |
|
|
How To create Dynamic Coloum names?
I am building a query. I takes sales data for the last twelve months
based on now(), totals and manipulates it, and spits it out in 12
monthly intervals.
So, after the breakdown and grouping data, the query returns Month1,
month2, month3...
What I want to do now, is to change it so that instead of Month1.
Month2, I would get 2007-01, 2007-02, etc. I can generate the coloum
labe...
|
2 |
12/24/2008 1:05:21 AM |
|
|
10 digit date
Hello,
I have a query where one of the fields has a 10 digit date. It's some UNIX
format that represents seconds from the year 1970.
Does anyone know of an easy way to convert this to a short date like
1/1/2009?
Thanks for your help.
...
|
3 |
12/24/2008 1:03:56 AM |
|
|
payroll weeks / varying first day and week of the year
I have a somewhat ugly situation. Our year/first day/first week of the year
changes depending on which day of the week January 1st is. My goal is
twofold:
1. To be able to find the first day of the yearly payroll for any given
date (and the corresponding end of that year)
2. To be able to find the payroll week number for any date (ie 12/14/08 is
week 51).
The first week of the ye...
|
3 |
12/23/2008 11:51:49 PM |
|
|
Query for Day of week
I posted this earlier but it never showed up. Sorry if this is a duplicate!
I want to return info from a table using a query that only returns the info
that occured on Saturdays. The date field is formatted as a Date/Time field
formatted for the long date. Example: Saturday November 20 2008"
How do I write the criteria? I have tried "Like" as well as "and". Short of
entering 52 dates i...
|
2 |
12/23/2008 11:48:26 PM |
|
|
Remove duplicate records
I have two tables provided to me. i need to merge the two tables being that
one has the clients name and the other has the clients address. Table 1 with
the clients name is fine but table 2 with the address is duplicated... for
example:
NBR NAME
123 John
123 John
124 Jim
124 Jim
125 Jerry
125 Jerry
And so on and so forth for 376k records, please don't ask me why...
|
2 |
12/23/2008 10:28:22 PM |
|
|
Can only view questions
Why can't I view reply's. It's as if I wasn't logged in but I am logged in.
If this question posts then it's proof I'm logged. FRUSTRATED
wallymeister...
|
2 |
12/23/2008 9:40:16 PM |
|
|
Trouble with the site.
I can't view responses to questions when I do a search. I even tried to post
this question after doing a search and it didn't work. I'm hoping that it
will work now. Does anyone know what the problem might be.
Otherwise I'm trying to find out why my query is not updateable. Any help
is appreciated.
wallymeister...
|
1 |
12/23/2008 9:10:16 PM |
|
|
Unmatched query between three tables
Hello,
I have an MS Access 2003 database that contains employee training records as
follows:
tblEmployees (empID, name)
tblTrainingCourses (courseID, courseName)
tblTrainingIncidents (courseID, empID, dateCompleted)
One employee can take many courses, and one course could be taken by the
same employee many times (but most likely on different dates).
What I want to do now is creat...
|
3 |
12/23/2008 7:20:54 PM |
|
|
Subtraction Query
I am trying to do a simple subtraction between two tables. My SQL is below:
SELECT [Wanda - Current Week].Advertiser AS [Current Week Advertiser],
[Wanda - Current Week].SalesRegion AS [Current Week Sales Region], Sum([Wanda
- Current Week].Q409) AS [Current Week Quarter], "13" AS [Current Week],
[Wanda - Prior Week].Advertiser AS [Prior Week Advertiser], [Wanda - Prior
Week].SalesRegion...
|
3 |
12/23/2008 6:27:01 PM |
|
|
What happened to QueryDef
I am trying to write an sql statement in a form event procedure. The command
"Dim xxx as QueryDef" no longer seems to be exceptable syntax in Access 2007,
despite its appearance in the Northwind examples. How do I define a query to
call, if this doesn't work. BTW I have successfully written the sql to
function as a where command in a report opening DoCmd, but in this case I
want to ope...
|
4 |
12/23/2008 6:26:32 PM |
|
|
Query a field with data 1-20 eg.?
I need to query the field with data like 610-620,650-699 and ask it to return
any record that falls either = to or in between. Is it possible, or do I
need to make low and high field and enter data records in this case two
records?
low high
610 620
650 699
Ask for 655
--
Wayne...
|
2 |
12/23/2008 5:59:26 PM |
|
|
Add criteria to a append query
I am trying to add criteria to a append query, I was able to use Is Not Null
in my queries Criteria under F_Subs Serialnumber so records that have a blank
SN are not appended but i cant figure out how to put =
Me!T_Main.SerialnumberID in the criteria for the T_Sub's ParentSNID
I have a form F_Main that displays info for a assembly The form is Bound to
F_SerialNumbers with PartID, Serial...
|
3 |
12/23/2008 4:41:01 PM |
|
|
Summary Query has Duplicates
Hi,
I need your help. Here is my SQL as I understand that it may be helpful to
you to understand my problem. I have a table and mulitple queries in which I
am trying to create a summary report which lists Vendor and Types on the left
with Volume and Price listing across for each Period. It looks like the data
is a duplicate. How do I resolve this?
SELECT DISTINCTROW [Vendor / Typ...
|
4 |
12/23/2008 4:30:01 PM |
|
|
Trouble with Query doubling values
I have a query from a legacy database that draws out record counts based on
employees over a given date range. But when I run the query some of the
values result in too many records. I am kind of baffled on why this query
doesn't work when it did in an early version of this exact database.
SELECT [All Members/Weeks].Team, [All Members/Weeks].[Last Name], [All
Members/Weeks].[First Name...
|
2 |
12/23/2008 4:10:01 PM |
|
|
Date Part Function?
Hello!
I have a query and a table...
queryONE
FieldYear
2007
2008
2009
tableONE
FieldDate
1/1/2007
5/7/2008
5/9/2009
6/5/2010
I would like a query to only return the "FieldDate" values where the year
matches a value in "qryONE", not sure how to implement the function directly
into my query, hence the final dataset would return....
qryFINAL
FieldDate
1/1/2007
5/7/2...
|
4 |
12/23/2008 3:29:49 PM |