Auto Calculate a Log Number

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I want to calculate a log number in a table based on
inputs to two other fields in the table. For example: the
first field is a group drop down list: ex.. abc, def,
hij. The second is another drop down list: ex. ab, cd
etc. I want to calculate a log number that will combine
the first two fields with a sequential number. Example -
select abc from first dropdown and cd from second
dropdown. The log number would be abc-cd-1, subsequent
numbers would be def-ab-2, hij-ab-3 etc....
Any Ideas on how I can do this?
 
Scott,

The essential answer to your question is... Don't! There is no reason
to duplicate the data like this. Whenever you need the "combined"
value for your purposes on forms or reports, you can generate it "on
the fly", either in the form's/report's underlying query, or in the
controlsource of a textbox on the form/report, using syntax equivalent
to...
=[FirstField] & "-" & [SecondField] & "-" & [NumberField]

- Steve Schapel, Microsoft Access MVP
 
Back
Top