|
|
|
|
1 |
538 |
|
|
Update Query by
James Stephens
I have used this similar construction to do update from text boxes to a table but this one doesn't seem to work right and I am not sure what exactly is...
|
|
2 |
333 |
|
|
Update Query by
Leif
I'm trying to move information from a table to a set of
normalized tables. To do this I'm trying to use an
append query.
The destination tables has one main...
|
May 26th, 2004 10:19 PM
by Leif
|
2 |
658 |
|
|
Can't use memo field when using unique by
Peter-Dave
Hi...
I have a multi user database and one report they frequently use is based on a query that returns unique values with on of the fields being a memo...
|
|
3 |
390 |
|
|
Select Latest Records by
dave
Didn't work for me. In addtion to returning the details
for checking out on the latest date, it appears to return
records that have a Checkout date that...
|
May 26th, 2004 09:27 PM
by dave
|
1 |
587 |
|
|
Count Group By by
Patrick
I have a table of transactions for multiple iterations of the same policy number. The Group By function works to LIST the distinct policy numbers, but how do...
|
|
2 |
682 |
|
|
Parameter query question by
Gina
I have a report that is pulling a form, which is pulling
two subforms all attached to two queries with a parameter
to pull employee number. All the parameters...
|
|
1 |
337 |
|
|
GROUP BY/ORDER BY Question by
BobRoyAce
I inherited a database which had the following query:
SELECT MonthData.FiscalMonthNumber, (100*
(SumOfKits/SumOfHours)) AS KitsPerHour
FROM MonthData INNER...
|
May 26th, 2004 08:29 PM
by
|
2 |
536 |
|
|
Showing all subrows in crosstab query by
Ragnar Midtskogen
Calling all query gurus!
I have a crosstab query where I group on two fields, and I can get the query
to show all the first field but not the second.
By...
|
|
3 |
1,116 |
|
|
Return String from Boolean Field by
Dragon
Hi,
I have the following query collecting data from a table where 'Complete'
field is a yes/no field. I am exporting this data for a PDF merge and what I
need...
|
May 26th, 2004 08:08 PM
by Dragon
|
2 |
397 |
|
|
Multiple Append Queries to One Table by
wpshop
I have a table with 5 fields. Each field's value can be calculated by using a Query to run a count on existing information in the main table. I can change...
|
May 26th, 2004 07:51 PM
by wpshop
|
2 |
632 |
|
|
crosstab query not showing all values by
Michel Peeters
I have a crosstabquery.
The 8 column headings are weeknr based on DateDif.
The value is the sum of Kg (double)
The rowheadings are fields from the customer...
|
|
0 |
533 |
|
|
Convert grouped records into a string by
mmattson
I am trying to convert all the names I have listed in a grouped query into one string record. For example, I am 1) grouping my records by date, 2) each date...
|
|
1 |
421 |
|
|
Crosstab Query Help by
Newbie
Hi,
I have the following query
PARAMETERS !frmMetalRequirements! DateTime;
TRANSFORM Sum(tblMatlSchedule.OSQtyReqd) AS SumOfOSQtyReqd
SELECT...
|
|
1 |
291 |
|
|
Please help me!!! by
Ann
Hi to anyone who can help.
I have a table with the following fields:
Last Name
First Name
Course ID 1
Course date req 1
Course ID 2
Course date req 2
|
May 26th, 2004 06:17 PM
by Ann
|
2 |
345 |
|
|
|
May 26th, 2004 05:15 PM
by
|
2 |
463 |
|
|
Crosstab Report and query by
Newbie
Hi,
I have the following query - see below
I want a report that is based on week number - the actual week number needs
to be on the report.
I have written a...
|
May 26th, 2004 05:11 PM
by Newbie
|
4 |
744 |
|
|
|
May 26th, 2004 03:31 PM
by JonR
|
3 |
729 |
|
|
Unmatched Query by
I have created an unmatched query using the wizard.
However I wanted the query to check more than one field
before returning the unmatched records?
Any ideas?
|
|
1 |
1,111 |
|
|
string by
Allouche Patrick
Salut j'aimerai remplacer un carctere present plusieur fois dans une chaine
?
1-2-3-4-5-6 deviendrai 1 2 3 4 5 6 donc '-' par ' '
ou encor inser un espace ce...
|
|
1 |
334 |