|
|
Front End and Back End by
Ashley
What are best pratices to set up FE so I can make design
changes to FE anytime I need?
How about BE?
Thanks
|
|
1 |
315 |
|
|
Delete Query by
JeffH13
This is posting I have posted in many new newsgroups. And after many
responses saying I can't do it. I would like a way around what I'm trying to
do...
|
August 24th, 2004 02:29 PM
by JeffH13
|
6 |
387 |
|
|
HEX2DEC Update query by
Skip
I have a table that contains a field for the RAM of a given machine and it is
stored in HEX. I have created a new column and want to use an update query...
|
August 24th, 2004 03:45 PM
by Skip
|
3 |
164 |
|
|
Comparing Dates by
Martin
Hi,
I want to make a query that compares a date field I have
in my records with today's date and then pull out all the
records that are 2 or more weeks old. I...
|
|
1 |
154 |
|
|
DSum Funktion isn`t working by
Benjamin
Hi,
i have a little problem with the dsum function in an query.
I have the field Datum with dates in it. Also i got Summe=20
von St=FCck as an quantity and...
|
|
1 |
104 |
|
|
|
August 24th, 2004 04:05 PM
by Pike
|
13 |
202 |
|
|
|
August 24th, 2004 04:19 PM
by Mark
|
0 |
93 |
|
|
Select TOP n * From table1 by
Saber
I'm using "Select TOP 10 * From tblPost" to show my first 10 posts in a
weblog.
to create "next 10 posts" button, how can I change my command text?
I need...
( 1 2)
|
August 24th, 2004 05:08 PM
by Saber
|
15 |
356 |
|
|
Minimum quanity Query question by
James Mckillop
I am trying to write a Query that looks at two fields and
then then reports when field 1 is less then field 2. It
is a report that tells when to order parts. ...
|
|
1 |
121 |
|
|
Appending multiple tables by
Indu Aronson
I have 35 tables that are named File1 to File35 that I
have to append to a table called tblUnivData.
Is doing them one by one the only option? I know how...
|
August 24th, 2004 06:25 PM
by LGC
|
4 |
115 |
|
|
subtract dates by
a
table 1
ID BeginDate EndDate
1 1/1/2004 5/1/2004
2 10/1/2004 20/1/2004
3 10/2/2004 ...
|
|
1 |
132 |
|
|
Count in Query by
Kris
How can I write a query that will count the following
three fields?
Thanks,
Kris
Field: 133
Table: 2004_April
Total: Count
Criteria: .05
|
|
1 |
328 |
|
|
How to populate gaps in my table by
fdsa
Hello,
I have a problem which is baffling me. I have found very
tedious ways of resolving it, but was wondering if there
was an eaiser way.
I have a table...
|
|
3 |
119 |
|
|
|
|
2 |
106 |
|
|
If query by
Faio
I have created a query based on a crosstab query. Its
something like this.
PF, SickTot, SickBalance, CompTot, CompBalance, Status.
The SickBalance and...
|
|
1 |
109 |
|
|
Any Values in Query Results by
Lamar
Hello,
In my query results I want to show only 5% of the
results. I know about the TopValue which will show only
the top percentage of the query...
|
|
1 |
329 |
|
|
DataTyp Problem by
Benjamin
Hi,
I have an string expression as an number,
(out of an DSum function)
for example 19000 and i want to convert this
string in an expression of type...
|
|
2 |
122 |
|
|
'On The Fly' Queries by
Martin
Hi
I am trying to create a query that can be updated 'on the
fly'. What I want to happen is for the user to select an
option from a pop-up box and then the...
( 1 2)
|
August 25th, 2004 09:35 AM
by Martin
|
10 |
223 |
|
|
Finding Data path in MS Query by
Peter
Dear All,
How can I find out which data path my MS Query is using? I guess there's a
really simple way but I cant find it!
Thanks
Peter
|
August 25th, 2004 11:25 AM
by Peter
|
2 |
123 |
|
|
Couting several columns with parameter by
Alex
Is there a way to create a query where I can count the
following:
988 where 988 is .05
110 where 110 is .03
330 where 330 is .04
I've tried the...
|
|
1 |
290 |