Search results

Thank you so much dear but actually 11.1 and 11.0001 are different if I am not wrong. After concatenation the 1 and 0001 will be 11.10 and 11.0001.

Thank you dear. I got my desired output.

Thank you CJ, Yes actually I want to use this code to sort my accounts by their groups. Can you please explain if you have better Idea to do this?

Thank you arnelgp Can we change 11.001 to 11.0010 and 11.002 to 11.0020?

Hi, I want to Concatenate 2 fields to make a separate Code for each account in chart of account. I have a fields: 1) ID containing numbers 0001, 0002, 0003 etc 2) AGCode (AccountGroup Code) containing 11, 12, 13, 21, 22 etc this is a code to Identify each Account Group such as Current Asset...

Thank you

Thank you but I could not understand properly. I am beginner. Can you please guide me about this?

Thank you for your response, Yes its lookup field.

Hi, I am trying to use Left Function in Calculated column to get starting 3 characters of a specific field. Expression I am writing is: Left([AccountGroupID],3) OUTPUT 1) In "1.1 Current Asset" starting 3 characters are 1.1 so I want output in Code column 1.1 but its giving 1. 2) In "1.2...

Hi, I have a VBA Code for converting currency to words. this code is working fine in Microsoft Excel. But I want to use this code in Microsoft Access Module to use in my report. The code is: 'Main Function Function SpellNumber(ByVal MyNumber) Dim Rupees, Cents, Temp Dim DecimalPlace...

Hi I want One Hundred Thousand instead of Lakh. I want to use Place(2) = "Thousand " Place(3) = "Million " Place(4) = "Billion " Place(5) = "Trillion " But not Rupees instead of Doler and Paisas instead of Cents. I have this VB code but its working on excel but I want to use this code in my Ms...

My issue is solved. I first copied the data from Excel to Notepad. And then Re-copy it from Notepad and paste it into my your query. Thank you very much all of you.

Thank you, GP for your response. Actually, in my query, there are more hidden fields also calculated fields. This query is based on the date parameter. Will it work in this case?

Can you please explain how to link to the spreadsheet?

Hi, I am trying to copy attendance from excel to my Microsoft access query. There are 3 columns that I want to copy 1) Attendance Status: this is a lookup datatype including Present, Absent. 2) Time_In: this is a date/time datatype with a general format. 3) Time_Out: this is a date/time datatype...

Thank you so much arnelgp. Solved

Thank you for reply I've tried it. An errer is apparing

Hi, I am using the calculation data type field in my table to make a field that can calculate grace time for employee attendance. There are 2 different fields Time_In and Time_Out. I want to use time from the Time_In field while both time and date are written in this field. Is there a way I can...

Can you guide how to remove this error?

Hi, Thank you for your response. I've deleted 1 unnecessary table and now I have 8 tables. But still, |9 error is appearing.