|
|
Need help with account rec aging by
erick-flores
Hello all
I have been searching in different groups to find an answer for these
but no luck.
I have a table that has invoice_num, total (amount), invoice...
|
|
3 |
111 |
|
|
Grouping in Pivot tables by
JoHickey
How do I get the grouping to give me 0 - 30, 31 - 60, 61 - 90, 90
I have done the grouping and come up with 0 - 30, 30 - 60, 60 - 90, 90
I have used interval...
|
|
0 |
135 |
|
|
If, then in a query by
ldimes4
I am trying to build an expression but am having some difficulties. I have a
field in the query that has percent values. I want to build an expression
that...
|
|
3 |
105 |
|
|
Deleting commas in a field query by
GLS
Hi
I have automated the exporting of Access 97 tables to CSV files. The prob
is there is an address field, where some of the data is input as eg: Flat 3,...
|
|
9 |
168 |
|
|
|
|
3 |
132 |
|
|
|
|
4 |
232 |
|
|
Entering a Null in query criteria by
George R
I have a yes/no field and would like to enable reports including records with
"Yes" or "No" or both. I have a form that opens when the report is opened and...
|
|
2 |
158 |
|
|
DLookup Problem by
Col
Hi all,
Probably one of the many having fun with Dlookup!
Wonder if anyone can help.
Trying to produce some data on whether certain members of staff have...
|
|
2 |
151 |
|
|
Odd or even by
Mark G
I have a query that sorts records by month, zone, and shift. I would like to
add another sort criteria to list only the odd numbered records, or even...
|
January 17th, 2007 06:02 PM
by Mark G
|
8 |
100 |
|
|
Requerying underlying make table query by
efandango
I have a ‘make table’ query that creates a ‘top 10’ record list on a form.
How can I allow the user to ‘requery’ the underlying query from within...
( 1 2)
|
|
15 |
168 |
|
|
Fix a value with one decimal place by
Marco
Hi. In a querie I have a column that is a diference between two other
columns. The result have a lot of decimal places. If I make a fix, it
transforms in a...
|
January 17th, 2007 05:46 PM
by Klatuu
|
1 |
110 |
|
|
Help converting text to date! by
Ess
I have two fields in the following format: 2006-06-07 00:00:00.000. I would
like to convert to a date field, preferably mm/dd/yyyy format, so that I can...
|
January 17th, 2007 05:23 PM
by Ess
|
2 |
104 |
|
|
Repeating Query by
[email protected]
I have a table I wnat to insure has consistant data in the "Activity"
field, based on data in the "Code" field. I am using an update query,
but I have 75...
|
|
4 |
109 |
|
|
Sum Text Field Where Sum Cannot Equal Zero by
shorticake
I am trying to get the sum of a text field, and only want data where the sum
is not equal to zero, but I keep getting an error message saying that "the...
|
January 17th, 2007 04:30 PM
by Klatuu
|
6 |
108 |
|
|
Why does this query "work" this way? by
John D
I won't describe the database I'm working with, because I can abstract the
question like this:
Assume you have 2 tables that have these fields:
etc
|
|
4 |
118 |
|
|
|
January 17th, 2007 03:37 PM
by Brent
|
4 |
105 |
|
|
index fields on SQL tables by
Brian
I have 2 tables linked to access from our SQL server via ODBC link
Both tables have a field called "Prod" which contains our product codes.
SQL has both...
|
|
3 |
172 |
|
|
Setting criteria by
DBAmat
Hi
I want to set criteria in a query so that it only shows records the
match befor the month of september 2006
Thanks
|
January 17th, 2007 09:32 AM
by DBAmat
|
2 |
104 |
|
|
Query does not show last date. by
P Mon
I need a Query to show me the last date for receipts on one table from
companies listed on another table. They are linked by a relationship.
Access 2000....
|
January 17th, 2007 07:50 AM
by P Mon
|
4 |
132 |
|
|
|
|
1 |
152 |