|
|
Make Table - Number Data Type by
TimT
Happy New Year all!
here's my first question of '07.....
I'm trying to run a make table query whereas it should create the following
fldJuridiction
text data...
|
|
3 |
76 |
|
|
Table Update by
shannyshan
Hi, I was wondering if someone could help me. I'm designing a database. I
have 2 fields in my table. 1 is for intermediate products and one is for...
|
|
1 |
73 |
|
|
|
|
1 |
78 |
|
|
Build a table depending on a date range. by
CD Tom
I have this working by using the parameter settings in the build table query.
What I'm wondering about is there a way to use a form to select the dates
and...
|
|
1 |
91 |
|
|
zero's in a query by
Melinda
In a query I am calculating dates, in five different intervals, Expr1:
-NZ(,Date())+1, i have 5 different expressions and then I am
adding and subtracting...
|
January 2nd, 2007 07:29 PM
by Melinda
|
5 |
73 |
|
|
|
|
3 |
103 |
|
|
DatePart qn by
Monish
The code below was working until this week (i.e. 2007)...hoping someone has a
suggestion on what might need to be different:
Week Tracker:...
|
January 2nd, 2007 08:59 PM
by Monish
|
2 |
92 |
|
|
Missing Date due to no data in crosstab query by
DMUM via AccessMonster.com
hello i have a client who wants a report that shows all hours worked for each
employee for the period of 7 days. They only want to put in the end date...
|
|
7 |
132 |
|
|
Number of columns error by
John
Hi All,
First Happy New Year to all,
Second: I have a query that was working fine. The database admin
changed one of the fields in a linked table from number...
|
January 2nd, 2007 09:17 PM
by John
|
3 |
85 |
|
|
Using AS in JOIN's by
John T Ingato
Scenario:
Table1 Stores: StoreNumber, Address, SKUNumber, InventoryLevel
Table2 Products: ItemNumber, Description, Size, ect.
Table3 Stores_Products:...
|
|
2 |
73 |
|
|
Getting Around Nesting by
Nanette
I've created the below query that calls another query. The first query
(qryPartChanges) produces 1302 records and the below query produces 4032
records. I've...
|
January 2nd, 2007 10:41 PM
by Nanette
|
2 |
77 |
|
|
Query in two different tables for the same data. by
E-mail report using Lotus Notes rather t
Hi,
I have 3 tables: Canada, US, Europen Registration and each table have their
own unique column headings but they all share the same heading for part...
|
|
1 |
59 |
|
|
DateDiff by
Joanne
Hello,
I have set up a query that runs against a table where I've listed vacation
time for each employee. The query contains a new field with the following...
|
January 2nd, 2007 11:02 PM
by Joanne
|
4 |
89 |
|
|
Saving formats in SQL view. by
John T Ingato
Is there any way to save SQL formatting with a saved query, Instead of the
SQL all being bunched together? It is easier for me to visualize what is
going on...
( 1 2)
|
|
12 |
180 |
|
|
Pass-through returns bogus data by
Carol Grismore
I have a pass-through query ( execute pass_through, 1, 2, 3 where 1, 2, 3 are
parameters) that works very well when executed directly in our Sybase
database....
|
|
1 |
123 |
|
|
Remove first number... by
GGill
In my query i will need to remove first number, if it's a first number
showing '1', then remove '1', if not then do nothing.
for example i have this data in...
|
|
5 |
79 |
|
|
Switchboard Access to Query by
Django
I am trying to create a switchboard that would provide a forms view only to a
query named "Monthly Ranges" that can be accessed from the desktop. Also I...
|
January 3rd, 2007 05:39 AM
by Django
|
0 |
70 |
|
|
|
|
1 |
83 |
|
|
How do I exclude data by
sadinak
I'm trying to build a query that looks at records with activity type,
"submitted", "reviewed" and "forwarded" for job requisitions. A new activity
record is...
|
|
2 |
81 |
|
|
Queries - combining fields by
Chigger Hill
Do you know of any method of combining three fields into a new field and
cutting out the blank spaces with a trim statement?
--
Chigger Hill
|
|
1 |
86 |