|
Concatenating the same field from multiple records
Hello All
another wierd query question. i have a union query where i get some
duplicated part numbers. there is a field that i would like to show the
actual data for, but i would like to show the quantities as a sum. let say i
have 2 lines where the part number is 321123 and a qty of 5 and the other
line is a qty of 3, for a total of 8. but i also have a field called Ref
which has 110...
|
16 |
11/29/2008 2:22:38 AM |
|
|
CrossTab Query with greater than 3 row headers / Excel Transpose
Hi all, Does anyone know how to build a crosstab query with more than 3
headrer rows. The wizard restricts to 3. I would like to covert large
vertical excel files into horizontal tables using access crosstab or even
transpose function in excel. Does anyone know if either access crostab query
or excel transpose function can be used on large datasets?...
|
3 |
11/29/2008 1:10:00 AM |
|
|
parameter query prompting multiple times
I'm having a problem with subreports based on parameter query, however, I
don't understand about the master child fields.
My report is set up with one subreport (that will only return one value) in
the page footer section, another 2 subreports (returning multiple values) are
setup in the report footer section. All are run off of parameter queries.
They all have the date (warehouse loa...
|
6 |
11/28/2008 11:09:01 PM |
|
|
Max # crosstab query column headers?
Can I increase the maximum number of column headers in crosstab querys? I've
determined the max is 255, I have a dataset w/ 268 column headers...any
suggestions?...
|
4 |
11/28/2008 10:52:24 PM |
|
|
Lowest value of 4 fields in record
Who can give me a hand?
I would like to determine what the lowest value is of four fields in a
query. One or more fields can have a NULL value and if all fields are NULL,
the value zero should be returned. Is this possible and if, how?
Thanks for any help to this question.
Ron
...
|
2 |
11/28/2008 10:24:37 PM |
|
|
How to do Multiple update in one query
I use access 2003. Field [County] has different data, ie. Kings, Queens,
Bronx, Manhattan and Brooklyn. (yes, I'm from Brooklyn). Field [claim no]
has varied data.
In one update query, can I create five update fields, ie.
field [Claim no] [claim No]
[claim no]
update to Bk &" " &[claim No] Qu & " "&[claim no] ...
|
4 |
11/28/2008 10:09:41 PM |
|
|
Limiting YTD totals to date
I have a query that totals lbs and pieces year-to-date (YTD).
However, I need to be able to limit the query to the total up to a user
specified date.
I've tried <[tomorrows date] but it simply returns the daily totals.
Thanks in advance,
Dragon...
|
5 |
11/28/2008 9:43:01 PM |
|
|
convert access date Format() to French date , use of ORDER BY SQL
HELLO
I'm working in Access database .. i'm using this SQL query to extract dates
in English format below :
SELECT DISTINCT Format([Date Commande],"yyyy/mm") AS Expr1
FROM Relevé
GROUP BY Format([Date Commande],"yyyy/mm");
Result:
Expr1
2006/10
2006/11
2008/10
2008/11
2008/12
2009/01
AS YOU see i have the good order of my dates ..But when i m trying to have
the same resul...
|
5 |
11/28/2008 3:23:44 PM |
|
|
SUM FIELDS TOGETHER IN A TOTAL FIELD
Hi,
I want to total the sum of 3 fields as mentioned below but I'm unable
to do so.
SELECT DAT.Activity, DAT.[A Amount], DAT.[D Amount], DAT.[W Amount],
[A AMOUNT]+[D AMOUNT]+[W AMOUNT] AS TOTAL
FROM DAT
GROUP BY DAT.Activity, DAT.[A Amount], DAT.[D Amount], DAT.[W Amount],
[A AMOUNT]+[D AMOUNT]+[W AMOUNT]
HAVING (((DAT.Activity) Like "E-L*"))
Is there something missing....
|
7 |
11/28/2008 5:31:57 AM |
|
|
Multiple Query Critieria with Multiple Combo Boxes
I've searched through many questions already with no luck finding the answer.
I have a Query and Report by the name of Call Types.
I have 2 combo boxes (Replist, Mgrlist) on a form (Helpgate Menu).
I'm trying to get it so that I can load the report from data in the
"replist" or the "mgrlist", but not both, or if left blank it provides
results for all the reps in the replist.
I can ge...
|
7 |
11/28/2008 12:21:00 AM |
|
|
Help with building update query with two tables
Hi,
I have a list of addresses, in five fields each, e.g. street address 1,
street address 2, city, postal code. An address can be repeated. I would like
to group these address and assign each unique address an ID#, which I would
like to link to a new table, containing the new ID#, the address itself, so
if need be, I can remove the address from the original table and just leave
the ID#...
|
3 |
11/27/2008 8:33:02 PM |
|
|
Repost - help to merge 2 queries
Hi all,
I've simplified my original post as very long winded - apologies for that;
it was a busy day at work.
I want to run a single query that has inner joins across 2 tables:2 fields
and a left join on 1 table:1 field. Due to an "ambiguous joins" issue when I
attempt to run as a single query, I have had to split this into 2 queries
i.e. inner joins in 1 query, left join in another....
|
10 |
11/27/2008 6:15:01 PM |
|
|
Parameterized query
Hi,
I have a parameterized query which takes date as an input and gives me the
results of the query.
What I would like to do is multitask this query in such a way that in case I
do not provide any input for a period of 10 seconds (let's assume), then it
automatically gives me the data for the previous day.
Is this possible?
Thank you in advance.
--
Regards,
Duncan
Message ...
|
3 |
11/27/2008 3:11:06 PM |
|
|
decimal day to standard hours, help please
Hi i have a column which displays a defined time period in decimal days, and
was wanting to change the format into hours, the problem being that some
periods are longer than 24 hours.. What do i need to put in the format
section of the queries properties?
i've tried [h]:nn as excel, but no joy!
--
steve adlam...
|
4 |
11/27/2008 3:03:01 PM |
|
|
Make query to calculate two dates
Hii
i have employees Table including general information of employees and one of
fields is [hire date]
i need to make a query to calculate between current date and hire date and
calculate the experience of employees
for example
current date is 27/11/2008
hire date is 20/10/2000
the experience is 07 days - 01 month - 08 years
how i do it?
please he...
|
3 |
11/27/2008 2:18:54 PM |
|
|
How i can search, personnel record by grades or by name on databas
I have problems with Microsoft Access Query?????
I have designed a database in MS access for a company personnel record, now
I want categorizes the database by grads" ranks" or by ID numbers( when I
type the name of a person it should show me the data of that specific person
among 1000 personnel on the form?
2nd. if I want to see one rank people among many for example" colonels,
Maj...
|
2 |
11/27/2008 2:15:49 PM |
|
|
calculate two dates
Good morning
I have a Employees Table containing generel information about Employees one
field for hire date.
and i want make a query calculate between current date and hire date to
display the experience for each Employees How do I make this query ?
for example
current date 27/11/2008
hire date 01/10/2000
experience 26 days - 01 month - 08 years
Thanks for any ass...
|
2 |
11/27/2008 2:11:45 PM |
|
|
Query Know Thyself?
Hi everyone,
I have a series of queries that append data from a number of source tables
into one destination table. I would like to add two fields to the
destination table e.g.
WhereDataCameFrom Text 50
WhenDidItGetHere Date/Time
and have the source queries populate these fields whenever they are run.
The Date/Time is no problem: I'l just use DataGotHere:Now...
|
9 |
11/27/2008 6:41:00 AM |
|
|
current month
I have a query that has the date and time as 11/26/2008 12:42:33pm, what I
want to do is pull the current months data using the system date/time. I've
tried a few different things and I only get partial data, but if I put in
>#11/1/2008# and <#12/1/2008# I get the correct records. I don't want to
have to put in the date range but use the systems date to determine the month.
Than...
|
10 |
11/27/2008 8:35:01 AM |
|
|
Sum in Querydef
I have a form that gets its data dynamicly with this code,
Private Sub Form_Load()
Dim rst As DAO.Recordset
Dim db As DAO.Database
Dim q As QueryDef
Dim i As Integer
Dim j As Integer
Set db = CurrentDb
Set qdf = db.QueryDefs("AllBalancesByFCandDB")
For Each prm In qdf.Parameters
prm.Value = Eval(prm.Name)
Next prm
Set rst = qdf.OpenRecordset()
rst.MoveFirst
j ...
|
11 |
11/27/2008 6:08:55 PM |
|
|
Courses not yet attended
I thought in my ignorance this would be fairly straight forward. I have a
query which shows the mandatory courses employees have attended and I have
another query which shows the courses they should have attended. I need to
know which ones they have not yet attended and no matter which way I
manipulate the tables I've got nowhere so any help would be appreciated.
The query which shows w...
|
3 |
11/28/2008 10:41:00 AM |
|
|
Open report from Query
Hi,
I am using Access 2003 and I am hoping you guys/gals out there can help me
with a little problem. I am trying my hardest to open a report, based on a
query using data from the current record via a command button. I'm sure this
is achieveable, i just don't know how.
At the moment I run the query via a command button, which will ask for 3
pieces of criteria for the report to be ...
|
4 |
11/28/2008 4:46:42 PM |
|
|
Filling fields in Access with a repeating character
Dear all,
I am working with a particular dataset at the moment that requires any
unanswered fields to be filled with an 'X'. Is there a way by using an update
query that I can tell Access to put in the correct number of Xs required for
each field (e.g. if a field is 50 characters long, it fills it with 50 Xs, if
it's 2 characters long it fills it with 2 and so on)?
Thanks for your he...
|
4 |
11/28/2008 11:00:09 PM |
|
|
How do i make a query with fields taken from a form?
Can a query be made with the field names chosen in a dropdown box in a form?
I want to be able to run the same query over multiple different tables with
different names, but i cannot change the tables. So i want to be able to
choose the columns in a form, to be used in a query.
Thanks
Tom...
|
3 |
11/28/2008 11:01:44 PM |
|
|
Parametric queries
So I have three sequentialqueries: A, B, and C.
'A' queries a table, 'B' queries the results of 'A's queries, and 'C'
queries the results of 'B's queries.
'A' uses a WHERE condition that uses a parametric query
(i.e. WHERE thedate = [Parametric query])
My question is that when I run a report that uses the data from 'C', I have
to input the date 3 times. How can I stop this?
Al...
|
10 |
11/27/2008 4:53:18 AM |