Need helping adding tax field to Access app

[shahid Elahi]

shahid: I'm not sure whether you mean both values such as 1795 and text such as A or B in separate records; or a combination of both, such as A1795. However, a text field allows both numerals and letters. The problem comes when you wish to either sort or search within those records. Thus, A1795, A1796, and A1797 can be sorted alphabetically--but one record of 1798 added without the letter would be sorted ahead of the A1795. Conversely, A200 would be sorted to follow A1797.
Was that your question?

Sir! I think I could not explain my question clearly. In my question numbers and Text are different values but in the same field suck as A, 1796,1797,B etc. I want to calculate these values in a Form. Sample Table is given below.
--------------------------------------------------------
Sr#--Stud_Name---Marks
--------------------------------------------------------
1 ---Ahsan---------50
2 ---Umair---------25
3 ---Rehan-------- 20
4 ---Zubair---------A
5 ---Sultan--------30
6 ---Akram-------- A
7 ---Aleem-------- 30
---------------------------------------------------------
In the above sample table I want to calculate Marks, where "A" for absent student.(The table field "Marks" property is "Text")

Thanks
Shahid

 

[georgedwilkinson]

Dude, open a new thread. This is totally unrelated to the tax issue James needed help with.

 

[wilpeter]

Could you add another field called Absent (a Yes/No) field. The Mark presumably would be Zero. The Criteria of Yes in the Absent field can be used to force a text entry to replace the value. This way, your Marks can be a Number field.

 

[Simon_MT]

The Tax being applied is the current prevailing rate on the transaction and applied on the "Tax Date" I would have table for solely for taxes as it embraces differing tax regimes.

Sofaras GST / PST and HST, I would in the UK combine the taxes as Customers only get to see the Tax amount and second table with the composition of the sales tax.

The Products sales Tax is valued at the prevailing sales tax rate. It is on the expenses that there maybe variability.

I manage system that use international taxes and the only one to stump me is Florida with its bands of Sales Tax.

Simon