Find quantity and seqnumber

[mathanraj76]

Hi ..
I have problem with my ms access
I'm still learning and new to ms access

question 1
How to add seqnumber into my tbldata field name "seqnum"
for an example it must start from "AS-00001" and so on by contentiously


question 2
Q stand for "Quantity"
M stand for "Magazine"

In my tbldata in have fields name "Qfft","MFFT","Qstyle","Mstyle","QFhm","MFhm","Qca r","Mcar","QMen'sUno","Mmen'suno","QIfeel","MIfeel ","QIntrend","MIntrend"

let sat if i want find those quantity > 2 for all the fields it must shows all the quantity which start from 2 with magazine name with all the information which have in tbldata.
if the fields which i mentions on question2 is empty then it must show "X" in the fields "M(X)Nomag" with QNomag "Nil"


I have attached sample database

Thanks
Mathanraj

[June7]

1. Generating custom unique identifier is common topic in forum. Search forum or Google. For a start review:

https://www.accessforums.net/access/...ers-21361.html

http://forums.aspfree.com/microsoft-...ta-403208.html

2. Apply the same criteria under each 'Q' field using OR operator. Saving calculated data (data dependent on other data) is usually a bad idea. Calculate the value when needed. Also, requires code to save calculated data. I counted 8 'Q' fields - that means a long expression to test each field for the parameter and return appropriate value. This does not appear to be a normalized data structure.

[mathanraj76]

can u give me some solution on question no.2
I really need help on it

Thanks
Mathanraj

[June7]

Which part? The filter criteria using OR operator or the calculation for the Nomag values?

Filter with OR: Under each quantity field use >2 as criteria but each will be on a separate line to apply OR operator, will look like stair steps.

Nomag calculation maybe like: IIf(IsNull([Qfft]) AND IsNull([Qstyle]) AND IsNull([QFhm]) AND IsNull([Qcar]) AND IsNull([QMen'sUno]) AND IsNull([QIfeel]) AND IsNull([QIntrend]), Null, "something else")

[mathanraj76]

Thanks
For solved my problem..