Search results

Actually, the field is not calculated but a normal number field. Another field's on click event would update this field. It used to show the proper result/figures till yesterday but now it only updates after the form restarts.

I have a calculated field on the form, it was working fine till now but since last two days, it shows zero until I close the form and re open it. Shows the correct value only when its restarted. What could be the issue? It was working very well till yesterday and I haven't done anything to the...

Thnaks alot, it worked

in control source it gives #NAME error

It shows #NAME

Where to change the property please?

Where to add this?

Hi all how to remove the minus sign from negative numbers in form. Plz help

How can I change it in form plz?

Hi Friends I have a calculated value on the report and it generally is a positive value but rarely it comes as a negative. I want it to be displayed without the minus sign i.e. the absolute value. How to achieve that. Thanks

Thank you so much CJ, it worked.

Here's is the sample in Excel.

Hi Friends I have a form and nearly 3000 records. I need to generate a certain kind of report grouped on Delivery date arranged in blocks/tables as attached. How can I design this type of structure in access reports. Please help.

Thanks Minty and jdraw wl try to check what you guys have suggested.

Its such an embarrassment but all this is self learning thats why all messed up :(

Its a garments business. Yes, I have Excel background. How to store the data? Minty... the default value is zero thats why it shows zero where there is no value and the total fields are calculated fields so if it appears blank, totals are not showed.

Thats image of the cut form for users to enter data all others are like this

Thats right they are all part of one process. I divided it into 4 different databases because of the amount of fields and data. They are exceeding 250.

Data fields are text, date and numbers and we do entry in the form in different databases. 1: Order 2: Cut 3: Print 4: Pack We have forms for these 4 databases. Now, a final summarized report is needed by taking few fields from all the four databases.

Data layout? I have tables and forms based on those tables for data entry and then I have reports as well.