I want to be able to export a query, in which a folder s created and the file is named based on two fileds of the query. I found the MAcro Outputto, but in order to use it you need to say exactly the path and name of the file.
I need for example: export query which has as parameters the variable names AMP_ID and Start Date with values 10111 and 1/1/2008, respectivley to be saved in C:\Myfiles\2008-01\10111\AMP_20 0801_10111.xls...
EORTIZ
Last Activity: Jul 14 '08, 01:42 PM
Joined: Sep 24 '07
Location:
-
Access 2007: create a report per group
I have a report that is grouped by a field. I have looked for ways in which it would be possible to obtain an individual report for each group to export to PDF. Since if I have all groups in the same report, it is saved in only one PDF file when I exported. So right now, I modify manually the query from the report is based on to select only one group every time and obtain each PDF as a separate file for each group.
I want to know... -
Thanks a LOTTTTTTTT !!!! I could make it work!! Excellent Thanks thanks -
Thanks a lot, kind response.
I am not experiences with MS ACCESS codes, so... simple question How I define the global variable? :-PLeave a comment:
-
What happened is that there were null values in the fields. I created a variable that replace the Null for a zero. However, doing that, made the variable as text.
To correct it, I first created a table from the query, then run an UPDATE query to put zero where the value was NULL, and then create a query based on the table to create the variable that sums the fields as total:[field1]+[field2]+[field3]Leave a comment:
-
sum two or more felds in a query
I need help in two things:
1. How can I sum the results of two or more fields in a query. I tried creating a variable like this: total: [field1] + [field2] + [field3] but i just get the concatenation of the three fields values.
2.In a report, include the page number by group, so it resets when a new group starts. -
How to assign page numbers per group in a report
I have a report in which is grouped by a variable. The number of pages per group varies. I need to include the page number for each group, so it resets after each group. -
Well, how could I combine the two conditions to be able to obtain a Plan Id for each claim? If the service falls in the plan date range, or if it is outside to the range. The objective is to assign only one Plan ID to each claim.
P.S. Maybe it is of nature to complicate things more than they are :-) Nos ahogamos en un vaso de agua....Leave a comment:
-
It does not work completely, buy partially. Ideally, none of the claim service_date, should be outside the range. However, it happens. So in the case that the service_date falls outside the Plan's coverage periods and because the member can change Plan_ID from time to time, I need to assign to the claim the Plan_ID that was just before the service_date. See example I presented above.Leave a comment:
-
Additional explanation of question:
If service date is between the plan period the statement would be:
if service_from_da te>=plan_from_d ate and service_from_da te<=plan_end_da te
But, if the service date is not in the range of the plan dates,
for example: Service_from_da te=1/15/2008,and let's say that the member has
Plan_ID=1 for Plan_from_date= 12/1/2007 to Plan_end_date=1 2/31/2007...Leave a comment:
-
Additional explanation of question:
If service date is between the plan period the statement would be:
if service_from_da te>=plan_from_d ate and service_from_da te<=plan_end_da te
But, if the service date is not in the range of the plan dates,
for example: Service_from_da te=1/15/2008,and let's say that the member has
Plan_ID=1 for Plan_from_date= 12/1/2007 to Plan_end_date=1 2/31/2007...Leave a comment:
-
Assign value based on criteria in anothe table
I have 2 tables:
Claims table- claim ID, Member_ID, service_from_da te, service_end_dat e.
Plan table- Member_ID, Plan_ID, Plan_from_date, Plan_end_date. The same member_id can have multiple Plan_ID with different dates.
I need to assign the Plan_ID to each claim ID. The criteria is that the service_from_da te has to be greater than or equal the Plan_start_date and equal or lower than the Plan_end_date. For... -
Assign field value based on date range of another variable in another table
I have 2 tables:
Claims table- claim ID, Member_ID, service_from_da te, service_end_dat e.
Plan table- Member_ID, Plan_ID, Plan_from_date, Plan_end_date. The same member_id can have multiple Plan_ID with different dates.
I need to assign the Plan_ID to each claim ID. The criteria is that the service_from_da te has to be greater than or equal the Plan_start_date and equal or lower than the Plan_end_date. For... -
NEVER MIND, HERE IS THE ANSWER. MAYBE SOMEONE IS INTERESTED
[CODE=oracle]
select units, total_paid, adjunits1,
CASE WHEN total_paid<0 AND ADJUNITS1>0 THEN -(ADJUNITS1) ELSE ADJUNITS1 END AS ADJUNITS2 from
(SELECT
CSV_MSTR.CSV_SR V_QTY as units,
CSV_MSTR.NET_PA ID as total_paid,
case when NET_PAID=0 THEN 0 ELSE CSV_SRV_QTY END AS ADJUNITS1
FROM
CSV_MSTR...Leave a comment:
-
Dependent CASE function of another CASE function in a SELECT statement
I would like to know the way that I can write a CASE function in a select statement that uses another variable that is created in the same SELECT statement using another CASE function. This is exacly what I am trying to do but obviusly gives me an error because is incorrect:
SELECT
CSV_SRV_QTY,
NET_PAID,
case when NET_PAID=0 THEN 0 ELSE CSV_SRV_QTY END AS ADJUNITS1,
CASE WHEN NET_PAID<0... -
Thanks for your response, I appreciate the timeliness of it.
It is possible than the person doing data entry by mistake select an option and there was not a response for a particular question, so need to uncheck the control. If selecting option1 from the control, the second control will be enabled, and if it is changed to option2 in the first control, the second control need to be cleared and disabled.
I...Leave a comment:
-
I found the answer!
In the "Dobule Click" event write this line of code:
Me.optGroupname = NullLeave a comment:
-
MS ACCESS: How to delete value from an option group control
I need to be able to delete a selection from an option group control in a form. In other words, if I selected value 1 from the option group control and I should have left blank this control. -
Hi Stewart, thanks a lot for the reply.
I am in the very beginner stage of using programming so I need a little moe help. Let's say that I have an option group control called Q1, and a second option group control called Q2. I need that Q2 be disabled until selected in Q1 the value of 1. Otherwise need to be disabled.
Another thing that I need to do is to be able to clear the option group controlQ1 for the case...Leave a comment:
-
MS ACCESS: How to enable control in a form based on another control
I want to know how I can enable (activate) a control in a form if another control is filled. For example, I have a questionnaire and I want to skip questions depending on the answer of a previous question.
No activity results to display
Leave a comment: