|
|
|
|
8 |
155 |
|
|
|
|
7 |
89 |
|
|
See all records by
LED
Hi,
Was wondering if someone could help me out.
I have two tables.
The first one is Customers (500 records)
The second one is Gift Cards (125 records)
The...
|
October 16th, 2008 08:19 PM
by LED
|
4 |
93 |
|
|
|
|
5 |
94 |
|
|
Running total between two dates by
Noreen
I have a query in which I need to calculate running totals on a no. of
fields, mainly Year To Date figures. The problem is my year includes the
31/12/07. My...
|
|
1 |
78 |
|
|
Query with conditional statement by
gremillion1
I am an access novice. . . .
I have a query with an expression to find the average of two grades per
subject (5 subjects). That works fine. However, what I...
|
|
8 |
138 |
|
|
Date range queries by
Pat Hughes[_2_]
I'm having problems with date range queries. Can I make these queries when
the person who built the database used "Text" as the "data type" for the date...
|
|
2 |
105 |
|
|
|
|
2 |
83 |
|
|
|
|
0 |
78 |
|
|
Iif Statement by
D
Hi:
I have a query, and I need to calculate the varaince (pecentage) between two
fields:
(-);
my iif is: July%$:
IIf(.="FY09F",(-)/IIf(=0,,))
I have...
|
|
5 |
126 |
|
|
IIF Statement #Error by
rml
I have a query with three fields. ID, Standard, Report
I'm trying to use the following code in the field line:
Report:...
|
|
5 |
140 |
|
|
|
October 16th, 2008 03:21 PM
by RickSF
|
2 |
106 |
|
|
Set Query Criteria to upcoming Saturday by
twalsh
Designing a Query in Design Mode
Field is called 'SCH_WK' or Schedule Week, which we identify as the Saturday
for each week.
I need to run the query each...
|
October 16th, 2008 03:20 PM
by twalsh
|
2 |
89 |
|
|
Field allowing entry Pls HELP!! by
JB
Hi, I've now got myself in a total muddle.
I've created a database that worked very well.
The usual client and contacts etc. the main form had fields for the...
|
October 16th, 2008 11:12 AM
by JB
|
0 |
82 |
|
|
query value by
rml
How can I make a query do the following:
If the value in column A = "123" then value of column B = "tree"
If the value in column A = "456" then value of...
|
|
4 |
91 |
|
|
Update query trouble by
bhammer
I want to copy the CodeID value from one record to another, in the same
table, to a certain record where a part of the Doc_Number (for the record
with the...
|
|
1 |
84 |
|
|
Output Query to Text File by
golfdog via AccessMonster.com
Looking to extract records from a query line by line ouputted to a single
text file in a prescribed format. The formatted lines can be one of 6
different...
|
|
0 |
174 |
|
|
|
|
3 |
92 |
|
|
Automated Delete Query by
Syed Rizvi[_2_]
I have a database which needs to be clean up on a periodic basis using a
Delete query. All query is going to do is to delete some records from number
of...
|
|
1 |
117 |
|
|
|
|
10 |
117 |