|
|
function to return a portion of a cell by
carrie
I have a field that I need to trim off the beginning of the text. The piece
to be trimmed is not always the same length but is always followed by a dash.
...
|
|
4 |
124 |
|
|
querry sql problem for previous month by
reportyemi
I have a 2 querries totaldeliverytype and totalcondition. and wanted to find
out the previous months result of deliveries and condition of baby. I am able...
|
|
4 |
129 |
|
|
Is field between date range on form by
consjoe
I have a form with a start date and an end date field. I want a user to
either put dates in these fields or leave blank for all. I can't get the
query to...
|
|
2 |
103 |
|
|
Sort by text field in crosstab query by
JMalecha
Here is a copy of a piece of my table. I need to be able to sort the Monitor
Wells in order (i.e., MW-1B, MW-2, MW-3, MW-12A) Ascending order produces
the...
|
|
4 |
122 |
|
|
Report Gets #Name? on database launch by
FlBrent via AccessMonster.com
I have a weird situation that I can't figure out. I have built a report that
has many text box
controls that do calculations based on the detail fields coming...
|
|
3 |
129 |
|
|
Update Query Question by
Carl
I have a table with three fields:
CustNo SubDate DelayDays
There are currently 895 records, and growing
CustNo is a text field, SubDate is a date field...
|
July 8th, 2009 06:01 PM
by Carl
|
2 |
83 |
|
|
Iif Statment by
Thorson
I have written several iif statements, but I am not sure how to write one to
fit this problem. I have two fields in my query: EntryDateMonth and Month. I...
|
|
7 |
138 |
|
|
|
|
2 |
103 |
|
|
|
|
8 |
106 |
|
|
|
|
0 |
73 |
|
|
|
July 8th, 2009 10:53 AM
by MSC
|
0 |
107 |
|
|
Data Fur Report by
Steve[_72_]
The following data needs to be placed in a preprinted report:
AssemblyID Assembly ComponentID Component
1 A ...
( 1 2)
|
|
10 |
133 |
|
|
Print sub form only by
Leo
How do you write the code so that only the subform will be printed when you
do not want to go through report format? The sub form displays the seleted...
|
July 8th, 2009 05:55 AM
by Leo
|
0 |
140 |
|
|
|
|
14 |
208 |
|
|
Fixed Numbers by
Melissa
I have a table that is imported from Excel with percentages and numbers. This
table changes weekly and is used in conjunction with existing tables to
create...
|
|
4 |
109 |
|
|
Queries by
gr8_access
Hi,
I am having issues with access sql. I have data for example: 123456789. I
would like to break this into two lines and I don't know how to do...
|
|
0 |
93 |
|
|
Date Subtraction in MSAccess by
Laura1 via AccessMonster.com
I have two date fields. The underlying data has them stored as the following:
Sales Event date: 1/6/2009
Created date:1/6/2009 5:09:23 PM
I have converted...
|
|
6 |
167 |
|
|
Querying across Multiple Databases by
Brad Autry
I'll try to keep this as brief as possible.
I am working with "one" massive database that, due to size, has been broken
down into 37 separate databases. I...
|
|
5 |
103 |
|
|
|
|
4 |
112 |
|
|
Updatw table with a given criteria by
rasheedvtk
dear all ,
i have one single tablewhere i used to keep all my purchases, i want all the
the invoices on a specific date to be marked as paid , i want to it...
|
|
1 |
101 |