Search results

Here is a sample page of the report... as you can see the top part presents the data for a year, but the chart below presents the data for all the money collected during all the years... i just want to see the data for that particular year. The report has various pages, first it presents the...

I'm trying to chart a report but separated by year... I have the report and its perfect but when I try to chart it it presents me the chart for all the years, I want a chart per year. I know the problem has to be with the query but how I manage to present the correct data in every chart? It is...

Thanks... but it has to be triggered from the subform... I'll try to adapt this to my needs.. thanks for your help.

I have a text (amount) in a subform that must be updated in two ways it checks for the type of service (this text is in the same subform) and the position of the employee (this text is in the form) Example if the service is A it doesn't matter the position the amount will be $65, but if the...

I have a report that summarizes the sales for a week... on a table I have all the cash reported by date and on other queries I have the details for the sales. The problem is that the form that calls the report and pass the arguments to the cash total query is not passing the arguments to the...

I have a report that consists of various subreports. It consists of Sales, Charges, Expenses and Reimbursements in the report footer I want the sum of the Sales & Charges that were made Cash, another line for Credit Cards Totals and the other Checks total.... how do I limit the sum for each one...

thanks... greaaaaaaaaaaat

I created a report which consists of multiple subreports... the problem is that the headers' subreports are not appearing on the report... how do I make them visible?

the problem with this is that he can get the words and make all the installations he wants on other computers and worst of all... resell the db.

Thanks, almost what I want... but not to look for a specific word.. I want it to be a random word so the client call me and tell me what is the word or characters that appear in the screen so I can run a program that generates the unlocking code.

Ok this is my question. I want to sell a DB and there's been a contract with the client. He wants to make 3 payments for the db. Those are monthly payments. I want to create a module that locks the db three days after the date of the payment requesting a code to unlock it. That way I make sure I...

thanks.. that's it!

I have a field which holds a date(FieldDate) and I have another field that calculates a field depending that date I am using an IIF statement that go like this IIF(FieldDate<= 08/20/07,1.5,1) how do I write that field value (date) so the iif works, I guess thats the error that i can not use the...

I removed it, now I have an unbound field in the products form that will be used to show the quantity on hand.. at first I thought about storing it, but as you said it is better to have a calculation for that... I tried the Dsum but Im getting a syntax error.. how do I read the received and...

I'm not storing it.. it is calculated but it is giving me the error message thank you for your time

THANK YOU!! now the second issue... I want to update the quantity on hand based on the transactions.. I tried Sum(received) - Sum(dispatched) from the transaction but it keeps saying !Error

Here is the DB DB sample, take a look.

Here are the screenshots (Spanish DB using an English System)

I have a form that contains the employee Info and a subform that has the transaction info... why it is not recognizing the employee id in the transaction... the EmployeeID I'm using as an example is 2 but the subform is using 0... why? I relate them the right way... it is supposed to see that id

I just created a db to manage an office supply. I created 3 tables (tblSupplies, tblEmployees and tblTransaction) it is not for selling supplies it is just a control system to know who get things from the office (warehouse) and to know when to order more supplies. I related them like this from...