|
|
|
Query Design
Mon, 5 Jan 2009 08:57:01 -0800
I created a query using the Design and Wizard functionalities. However, my
returned results show less records than what actually in the data base.
Would someone please tell me what I might be doing wrong in my parameter
setup. All parameters are from only two tables that has one common field.
Thanks. ...
|
Extract info from Multiple Tables & combine into 1
Mon, 5 Jan 2009 08:09:01 -0800
I have 3 Tables titled [liquidated], [lossAmt] and [EFD]. These tables were
created using selection queries. They all contain identical fields but they
all contain different data within the fields
I need to combine these tables into 1 table titled [COMPLETED]
However, I need to extract only the informati ...
|
Selecting a range between 2 filters
Mon, 05 Jan 2009 13:47:31 GMT
Hi,
Am not an access guru, so please bear with me.....
I have a report, which runs on the value from a filter, ([PSGC]=Forms!
[FormFrontEnd].Combo18)
In this instance, the PSGC code is selected from the value found in Combo Box
18. (it works fine)
However......
As the PSGC codes can cover a range, say ...
|
Update query with if else condition (need to refer to cell indexes
Mon, 5 Jan 2009 05:32:03 -0800
Hi All,
I am trying to write an update query on a table with if-else condition. I
have the following scenario:
Column A is completely blank. Column B has some entries. What I want is
whenever there is an entry in column B set column A value as "1" and
increment each cell of column A by 1 until you hit ...
|
Trying to convert a short time field from hours to minutes
Mon, 5 Jan 2009 05:21:01 -0800
I need to convert a field that is in short time from hours and minutes to
minutes. I found this answer before but since redoing my database I have not
been able to find the answer back. Any help would be appreciated.
Thanks,
~Kelly ...
|
CurrentDb.Execute can't run SELECT Statement
Mon, 05 Jan 2009 09:24:11 GMT
Edison: Help! Help!
1. I had a leave applicantion where Manager able to view their Department
Leave status (Eg: Summay, History Transactions etc)
2. I had achieve it via Queries.
3. Now another issue is I need to PROGRAMATICALLY insert SQL statement to
allow HR View All,
I copied the statement from p ...
|
Display ID & Designator
Sun, 4 Jan 2009 23:56:12 -0500
I have a table that stores a Handling Team ID based upon a Cascading Combo
Box based upon a qry:
SELECT tblHandlingTeam.HandlingTeam, tblHandlingTeam.IDTeam,
tblHandlingTeam.IDHandlingCtr, tblHandlingTeam.TmDesig
FROM tblHandlingTeam
WHERE (((tblHandlingTeam.IDHandlingCtr)=[Forms]![LNA
Record]![HandlingCe ...
|
|
|
Error when Date/Time is a criteria
Sun, 4 Jan 2009 17:03:01 -0800
Hello.
When i have this query, there is an error.
(You tried to execute a query that does not include the specified expression
SalesTransaction.[stDate/Time])>=Query1.lDate_TImeOfMax as part of an
aggregate function.)
SELECT SalesTransaction.stPaymentMode, Query1.lStaffID,
SalesTransaction.stTotalAmount ...
|
Query with MAX function on more than one field
Sun, 4 Jan 2009 14:58:23 -0800 (PST)
Hi! I am trying to figure out how to build a query on how to obtain
the following based on the data below for the following fileds.
ITM
SHP
LINE
I want to have the line where it's the max and after that the max
SHIPMENT_NUM.
PO | ITM | SHP | LINE
67 | 1 | 1 | 2
78 | 1 | 2 | 5
78 | ...
|
Find misspelled city, invalid state/zipcode
Sun, 4 Jan 2009 07:03:20 -0800
I downloaded good tblZipcode:
zipID (primary key, autonumber), city, state, zipcode
If any zipcode covers several cities, it will listed several times.
I have tblStudent:
SID (primary key, student ID), lastname, firstname, city, state, zipcode
There are some typos in 'city' and some invalid state/zipcode
H ...
|
|
|
