|
cant edit records when 3rd table is added
I have a query with two tables T_PartNumbers and T_Life the two tables are
joined on a One to One here is a copy of the query
SELECT T_PartNumbers.PartNumber, T_PartNumbers.Description, T_Life.LifeID,
T_Life.OHLife, T_Life.RTLife FROM T_Life RIGHT JOIN T_PartNumbers ON
T_Life.PartNumberID=T_PartNumbers.PartNumberID;
Everything works as expected, when i add info to my OHLife field a ...
|
2 |
12/30/2008 9:13:44 PM |
|
|
Query help - Records don't exist
I need help creating a query based on 2 tables. One table (tblEmployee)
contains all Employees, their EmployeeID, and BucketEarned (the amount of
expense money they have earned). The second table (tblBucketRequests)
contains expense reimbursement requests from those employees. I need the
query to calculate the amount of money available for each employee based on
what they've earned v...
|
2 |
12/30/2008 8:27:06 PM |
|
|
Calculate Totals From Parameter Query in A Report
I would like to calculate the totals from a parameter query in a report but
keep getting an error message using the following:
=DCount("*","[Query_Name]")
How does one do this? Still fairly new to Access...
Thank you....
|
5 |
12/30/2008 8:01:15 PM |
|
|
dates in table 2 fields need to be one field I can sort by date on
aHere's the problem data is coming from a very old legacy system! The date in
the import table is actually 2 fields one storing month/day no leading zero
example: january 15 = 115, one storing the 4 pos year example='2007' I need
to combine these in do a field a can sort by date on and display as a date.
I've tried format not sure I had the string correct, I can combine them, and
display...
|
6 |
12/30/2008 4:56:09 PM |
|
|
Multiple paramerter values in one text box
I need to input multiple parameter values in one text box. For example if i
need to list the details for ProductID's 1, 2, 33,48 then these values should
accepted in the Parameter box separated by commas and details should be
listed when i run the query. I tried the Instr function. i.e Param:
Instr([Enter Product ID's seperated by commas],[ProductID]). It works fine
for single digit prod...
|
5 |
12/30/2008 4:04:02 PM |
|
|
Select data and sum by weeks in a month
I have a table with multiple columns. But I want to select data from column 1
and Column 4 using date(column 5) as criteria.
My dates are listed daily, how do I sum up the activities of each day into
weeks and have just 4 weekly summed up data. E.g If I want to retrieve for
the month of November...
E.g Column 1 Column 2 Column 3 Column 4 Column 5 (Date)
1. 20 ...
|
4 |
12/30/2008 3:27:53 PM |
|
|
Comparing multi select list box criteria against two fields
Hello again,
I'm trying to create a query that uses a multi select list box to set the
criteria which is then used to look up values from a table. I have written
VBA code (with lots of appreciated help from this discussion group) for
comparing the selected criteria to one field however I want it to compare the
selection to two fields. To make things clearer, I want to compare selected
...
|
2 |
12/30/2008 2:49:39 PM |
|
|
Finding the Date nearest a given date
Hello All
i am trying to find a way of narrowing down to a record where the date is
just one record that nearest matches the date from another table.
this is the scenario, i have products which go under a warranty for a
certain number of running hours. these hours are recorded at specific dates.
these products also have warranty claims against them. i need to make sure
that the amoun...
|
2 |
12/30/2008 2:37:20 PM |
|
|
Trying to resolve with an IF Statement
I have a table that is an auto-number field that creates sequential ticket #'s.
During testing I created several records in my table that were not real so I
deleted from the table.
The result is gaps between #'s.
I want to query on specific ticket #'s and if they do not exist, return a
[Not Found] dialogue box that allows you to enter another ticket #. It's
possible that the 2nd ti...
|
2 |
12/30/2008 2:21:46 PM |
|
|
Formula Problem
I have a table with 4 columns:
Review Date
STDID
File #
Answers
I want to run a query to calculate the % of Y/ Y+N for all the answers of a
specific standard (STDID) for a specific review date. Ignore N/A in the
denominator if the answer is N/A. If all answers for STD 2 is N/A then
return N/A.
For example:
I want a query to calculate the percent Y/Y+N of all the answers of the...
|
2 |
12/30/2008 2:15:40 PM |
|
|
Query By Month and Year - Access 2007
I have a table with contribution information, with a date field for posting
the date of the contribution. I would like to query this information by
month and year.
I first used the following:
>=[Start Date] And <=[End Date]
which works pretty well, but I would like to make it easier for the user so
the only have to input a month and year. So, I further refinded this by
u...
|
3 |
12/30/2008 1:35:57 PM |
|
|
Having trouble with pivot charts code
I'm used to the old Microsoft Graph ocx.
The beauty of this is that you could throw any cross tab query at it and it
would automatically set up all the appropriate series with a legend.
I'm trying to use the new pivot chart and I'm attempting to drive it with a
variety of cross tabs (one moment on the option form to drive the graph -
the user could choose faults by equipment category, anoth...
|
1 |
12/30/2008 12:18:52 PM |
|
|
dlookup
I don't know what my problem is. I post and then I can't find my answers.
Anyhow, can someone please help.
I have two tables.1 - Salaries Register witha field named Gross. Table
2..Income Tax with fields named PayRangeLow, PayRangeHigh. Tax payable.
I want to run a query to have the Tax payable is the gross falls between the
PayRangeLow and PayRangeHigh.
I need detail help with th...
|
4 |
12/30/2008 3:22:26 AM |
|
|
Filter Question
I have a report we review on a monthly basis. However, we do not review the
entire report only a certain portion. Is there a way to have Access
automatically cut down the report to the required percentage? So for instance:
50% of AB items
25% of BC items
etc...........
|
2 |
12/30/2008 1:03:58 AM |
|
|
Format Field
I am trying to format a field in the query panel... but can not seem to get
this to work...
I am using :
DOB: Format("DOB","dd, mmm yyyy")
can anyone let me know what is wrong with this...
Regards - Paul
...
|
4 |
12/30/2008 12:51:19 AM |
|
|
Query/Date Question
I posted this once but for some reason can not open it... trying agin:
I have a table, tbltests that has the following fields: testnumber and
rulename. It is a storage type table where I list all of the tests we
perform on our employees.
I have a form, fmTOs, that we use to input all the tests we perform on our
employees it includes the date and time the test was performed, the test
...
|
6 |
12/29/2008 10:14:02 PM |
|
|
Between 2 Dates in Data Field
Hello,
I have a table that has the following fields:
ItemID
MinimumAge
Cost
The data would look like this:
1234 25 $100
1235 30 $200
1236 35 $300
1237 40 $400
I have another table with the following:
PersonID
LastName
Age
The data would look like this:
1234 Jones 26
1235 Smith 42
What I need is a query that returns ...
|
6 |
12/29/2008 9:20:44 PM |
|
|
Query by Month and Year (Repost)
I am reposting this question because I cannot access the original question
nor the reply.
I have a table with contribution information, with a date field for posting
the date of the contribution. I would like to query this information by
month and year.
I first used the following:
>=[Start Date] And <=[End Date]
which works pretty well, but I would like to make it easi...
|
3 |
12/29/2008 8:59:03 PM |
|
|
Pick Year and Pick Quarter
Is it possible to create a query to run behind the scenes and do this?
I have a form and I would like the user to pick the year, and then
they have a drop down that contains the quarters (Q1, Q2, Q3, or Q4).
Based on the year they pick and the quarter, it puts the correct dates
in the box.
Example, I choose 2008 and Q2 - it auto populates April 1, 2008 into
one box and June 30, 2008 into...
|
2 |
12/29/2008 8:27:10 PM |
|
|
Something missing in my query?
I have created a query that will randomly select a "quote" from a table. I
also made it appear in a startup form.My problem is that whenever I open the
form the same message appears. I want a different message whenever I open the
form. Please help me do this. I know I'm missing just one thing here and I
can't figure it out.
I entered the following SQL in my table:
SELECT TOP 1 [tblQuo...
|
2 |
12/29/2008 7:34:23 PM |
|
|
Date Parameter
I have a union query shown below. I would like to add a where condition but
am having a very difficult time getting the the whole date/time to work out.
tblDelivery.TrimStart and tblDelivery.TrimFinal are Date/Time fields
formatted as "m/d/yyyy" i dont care at all about the time.
SELECT tblDelivery.UnitID, tblJobInfo.JobID, tblJobInfo.JobNumber, [Address]
& " " & [UnitNumber] & " " & [C...
|
6 |
12/29/2008 6:56:23 PM |
|
|
Access query
I am creating a database to input hours worked, and calculating pay. I want
to create a field which will calculate the income tax and social security
payable. Eg if earns between 150 to 180 a person pays $10. etc. Pleas e
help. I am basic in my knowledge of access. no SQL knowledge.
Thanks...
|
16 |
12/29/2008 5:08:26 PM |
|
|
DLOOKUP
Please help. I hae two tables. Field GROSS in Salaries Register. Nother
table with PayRangeLow, PayRangeHigh, Tax Amount.
I need a query to return the tax amount if the gross falls between the
PayRangeLow and PayRangeHigh.
Please however give me all details that should occur on every line of the
query, eg field, table, criteria etc. Thanks
...
|
4 |
12/29/2008 5:02:01 PM |
|
|
query using more than one equation for a field calc
I've asked this before but need additional help. In general terms I need to
build queries to address conditions for different values in the same field
of a table. For example, If I have a table with fields [Xx] and [Yy], and
field [Xx] has values A,B or C, can I write a query to use an Equation 1 for
values A, Equation 2 for values B and Equation 3 for values C all in the same
result...
|
2 |
12/29/2008 4:26:02 PM |
|
|
Appending records based on a query and user data from a form
[I'm reposting this message because it seems that there was a problem with
the previous post making it inaccessible.]
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 v...
|
1 |
12/29/2008 4:11:01 PM |