I was using VB6 and ms access to write an inventory system.
I discovered that while displaying selective inventory info my customer needs the serial number of each entry that is being displayed.
These serial numbers can not be stored in the database.
How do Idisplay such serial numbers in the data form?
I read your question several times but didn't manage to figure what the problem is about.
I understand that there are products which are stored in Access database, and to each product there is assigned one serial number. That SN is not stored in any of the table, but is computed based on other data, that is stored in the DB?
If the above is correct, you can simply create a raport with one field displaying SN calculation results (=output of a function that calculates serial number given some product data)
see this is the table invoice
c1 | c2 | c3
1.3 | abc | 5
2.6 | efg | 6
5. 9| yyy| 5
A user gives query: "Select * from invoice where c3=5"
so I want results to be displayed as
1) 1.3 abc 5
2) 5.9 yyy 5
Noticed 1) and 2)? How do I make them get displayed? If I store them in databse they get displayed as