Recent content by hksahoo
-
H
Syntax Error on Dsum Function with date range
Yes.. Dep is numeric field. There is no space in InterestTable in the expression I used. While posting this thread I made a mistake. Tdate is a date field. It exists in the table. If I do not use "" double quote, it throws syntax error. -
H
Syntax Error on Dsum Function with date range
Tried this too but getting results as "Error" -
H
Syntax Error on Dsum Function with date range
Sir, Tried both the codes as mentioned by you. There is no syntax error. But result showing "Error". Thanks and regards. hksahoo -
H
Syntax Error on Dsum Function with date range
Sir, Date format dd/mm/yyyy Tried Dsum(“[Dep]”,”[ InterestTable]”,”[Tdate]>=#01/04/2021# and [Tdate]<=#31/03/2022#”) but getting same syntax error I have also tried between. Thanks and regards hksahoo -
H
Syntax Error on Dsum Function with date range
I am getting the syntax error in the following expression : Dsum(“[Dep]”,”[ InterestTable]”,”[Tdate]>=#01/04/2021# and <=#31/03/2022#”) Please help. -
H
Displaying all fields of a record in one page
While creating a report , I find that the number of fields are more for a single record, and cannot be accommodated in a single sheet of A4 size paper(Landscape). So what is to be done so that all the fields can be incorporated in the report for a single record on the same page? I don't mind if... -
H
Adding value to a field which is not available in the table while lookin up
I have a field "Sender's Name" with lookup property and the value is usually selected from a Sender table. But I want that if a name is not available in the sender's table, the Data Entry Operator can type and add the same. Pl. advise how to do it. hksahoo -
H
Populating a new record based on search criteria
While adding a new record in a form, I want to search for the existing sender based on the sender's name and PIN or Sender ID from the Sender Table and if (found), then the form should automatically append the values in the corresponding fields in a new record. How do I do it? hksahoo -
H
Enabling and disabling fields based on multiple values from combo box
I have a combo-box with drop-down list to select with check boxes. The options are CASH, CHEQUE, DD, LETTER, PRAYER. One can also select multiple options like CASH and DD, CHEQUE and DD, DD and LETTER etc. I want that if DD is not selected then the DD_NO, DD_DATE, DD_AMT fields should be... -
H
Help Pl.
I am a new and inexperienced programmer in access and created new database(RegLetter-Inward) and am having a few problems as detailed under: 1. While opening the form, I want to search for the existing sender based on the sender's name and PIN or Sender ID from the Sender Table and if (found)...