|
|
Exporting data to txt/csv file - Issue by
RameshV
Hi:
I am trying to export the data to a txt/csv (comma separated) file.
Some of the fields has 0.03 or decimal numbers but its' truncating those...
|
March 18th, 2008 11:52 AM
by RameshV
|
0 |
95 |
|
|
Convert Row to Columns by
Victor Torres
Hi, I'm working on a payroll program for a doctor. My payroll program works
great with my time ticket program. Now, they have a small timecard program...
|
|
6 |
142 |
|
|
summing daily values, Urgent by
mahmad
Hi,
I want to be able to sum by daily amounts and then sum them up so i get a
total for the month gone. So yesterdays figures will be added to the day...
|
March 18th, 2008 09:52 AM
by mahmad
|
4 |
95 |
|
|
Delete Chart by
sq75222
I have the data base as below :
123 BOT 3
123 5
123 Top 2
abcde T1 4
abcde T2 4
abcde 5
Result in query to display 123=...
|
|
7 |
104 |
|
|
Cleaner way to query for negatives? by
Allison
Access 2000, Win XP SP2
Hi all,
I'm looking for a cleaner way to determine whether or not an entry in one
table has a specific field checked yes or no in...
|
|
3 |
148 |
|
|
MTD by
gmenon100 via AccessMonster.com
Dear Friends,
I am having a problem showing the MTD figure on every line item for products.
My table is as below tblTestcount
CodeNo (text), Manager(text),...
|
|
3 |
95 |
|
|
Drop down list for 'days out' to generate report by
ispfemme via AccessMonster.com
I have created a database that pulls a text file into a table, cleans it out,
and then displays in a report with appended comments that my users can alter.
Now...
|
|
1 |
91 |
|
|
Alter query for report? by
ispfemme via AccessMonster.com
I have created a database that pulls a text file into a table, cleans it out,
and then displays in a report with appended comments that my users can alter.
Now...
|
|
1 |
86 |
|
|
Update Records in a Table by
Brig
I have a table with a list of people. Each person have its own Unique ID
and is the primary key - no duplicate records should be created.
The table is...
|
|
1 |
110 |
|
|
Subtracting Holiday Hours by
Qaspec
I'm using the following expressions to calculate the number of hours between
and subtracting the Saturday and Sunday Hours. I
also have a table with a ...
|
|
1 |
95 |
|
|
Information between specific dates by
partner
I have been trying with no luck to pull a query of individuals with a birth
date after 8/1/2003 and before 7/31/2004. i am unable to get any information....
|
|
3 |
84 |
|
|
Table Alias - input table missing by
Casa
Hello everyone;
Here is a simple problem. I want to find duplicates in a particular column
of a query (this query is joining together two tables). So I've...
|
|
3 |
92 |
|
|
Form View by
citloner
How can I get a form, based on a table, to show only certain records (for
example, only paid customers)?
I tried basing the form on a query but it didn't...
|
|
2 |
71 |
|
|
|
|
4 |
128 |
|
|
|
March 17th, 2008 04:35 PM
by DM[_4_]
|
3 |
102 |
|
|
Crosstab ordering string by
Andy
I have a crosstab query where the Column heading is 'Wait: IIf(!0,"0",IIf(!52,"52+",CStr(!)))'
I used CStr so that I could have the '52+' criteria, but now...
|
|
3 |
81 |
|
|
How to merge to tables ( by
Mikael Lindqvist[_2_]
Good morning everyone!
My financial system's database (general ledger) keeps seperate tables for
each year. Each table (GL2007, GL2008 etc) has 14 fields:
*...
|
|
6 |
84 |
|
|
Date Range by
citloner
I have made a basic query which is supposed to allow me to search for all
records in a table in a certain range, for example, May records, using the
syntax...
|
|
1 |
65 |
|
|
Running a query from a form by
Petterq
I have made a command button in a form, that shows a rebort based on a query.
The query asks for a customerID. The customerID is shown in the form window.
How...
|
March 17th, 2008 02:14 PM
by bymarce
|
2 |
68 |
|
|
Run-time error '-2147217900 (80040e14)' by
Kro
I have a tree list control I want to populate with Categories based on a
Client. The client number is input into a text box & then the update event...
|
|
1 |
175 |