Seperating a Field by another fields value

[rsaepa1]

Hi All,
I am a novice at MS Access but I am learing new things every day.
I am using MS Access 2000 for this DB.
If you need to see the DB let me know and I will strip the sensative data out of it and post or send a copy. The DB is for a small retail sales store.

What I want to do is something like this::
If [Tables]![Sales Entry]![Item Tax] [= $0.00] Then copy [Tables]![Sales Entry]![Item Price] to [Queries]![Taxable and Non]![Non-Taxable] [Else[If [Tables]![Sales Entry]![Item Tax] [> $0.00] Then copy [Tables]![Sales Entry]![Item Price] to [Queries]![Taxable and Non]![Taxable]]] End If

I want to split up the Item Price field by checking to see if Tax was applied or not and copy the Item Price to the proper new fields in the query called "Taxable" and "Non-Taxable". Then in my Report I can sum each of the new fields by date.

Thanks
Ron

 

[Rich]

Just put <=0 in the criteria section for non taxable and >0 for the taxable items, or just use the Where clause of the OpenReport method to filter for either option

 

[rsaepa1]

Hi,
I am not sure where you would have me put the expression to obtain the reuired result. I am also unfamiliar with the Where clause in the Report.

Any additional information would be greatly appreciated.

Thanks
Ron

 

[rsaepa1]

Hi All,
I am wondering if anyone could provide additional information on how to handle this issue. I am trying to split one table field into 2 fields by referencing a second table field.


Thanks
Ron

 

[rsaepa1]

A copy of the db in question

Hi All,
I have attached a copy of the database for you to review. I am trying to build Query like I stated before to split the Item Price field into two seperate fields. The field would be split into Item Prices for taxable items and Item Prices for non taxable items.


Thanks
Ron

 

[rsaepa1]

Hi All,
No one has any ideas about how to make this work? The Item Price field will be seperated if the value in the Item tax field is > or = to $0.00.


Thanks
Ron