If data says this then say this

[srburk]

In a query I have a field that says:
Mon AM
Mon PM
Tue AM
Tue PM
etc....

I would like a new field to look at the cell mentioned above and code it.

If Mon AM then the new field would say S1
If Mon PM then the new field would say S2
If Tue AM then the new field would say S3
If Tue PM then the new field would say S4

How should I format that query?

 

[ReAn]

In you're new feild be like

MyNewField: IIf([otherfield]="Mon AM","S1",IIf([otherfield]="Mon PM", "S2", .... and so on...

Kind of messy though.

 

[ReAn]

Actually this is better....

Make a new table with the conversions... you know

Mon AM,S1
Mon PM,S2
Tue AM,S3
Tue PM,S4
Wed AM,S5

etc...

Then Join the two fields that have the mon am shit in it

then include the field that holds the S# 's

 

[srburk]

I apologize... I have no idea what you are suggesting.

I created a new table with MON AM in the first field and S1 in the second field. Similar data in fields 1 and 2 for the rest of the week.

Then what? I really apologize.

Actually this is better....

Make a new table with the conversions... you know
Mon AM,S1
Mon PM,S2
etc...

Then Join the two fields that have the mon am shit in it
then include the field that holds the S# 's

 

[ReAn]

Try looking @ this:

 

[srburk]

Adding records to your sample DB file

Try looking @ this:

On this database, I would not be able to add records. What must I do to add additional records?

 

[srburk]

I got the last problem fixed... Thanks for all of your help!