Recent content by 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

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...

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

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

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...

Thanks, that fixed the problem. I knew that it had to be something easy. I thought that when writing code you were supposed to represent spaces as underscores. Thanks Again Ron

Hi All, I am having a similar problem with my DB. I have attached a copy of my DB for reference. On the Daily Report Form I would like to enter a date that will filter the Daily Report Query and in turn via the Preview Daily Report cmd button. When I enter the date on my form then press the...

Similar problem Hi All, I am having a similar problem with my DB. I have attached a copy of my DB for reference. On the Daily Report Form I would like to enter a date that will filter the Daily Report Query and in turn via the Preview Daily Report cmd button. When I enter the date on my form...