Recent content by vsimpkins

yes i did and it worked. thanks. Valerie Simpkins www.pacetraining.com

Hi, I received an Excel 2003 with multiple rows and data in a single cell. Each cell row contents as follows: 4835 gnordine@pathwaysgroup.net external_affairs 4570 tvaughn1@Amialhost.tes.tulone.edu NMA News 467 jabberwh@aol.com NMA News JNMA List 90 edbeltonmd@aol.com NMA News JNMA List All...

Hi, I don't know why it's necessary to know why a table has a specific name. At any rate, I've attached an image of a partial view of the Hours table in Access. The Hours.Date field is a date/time field. Valerie Simpkins www.pacetraining.com

Me again...it didn't work The dates in the Hours table are all 3/5/2009. now that the system date is 6/22/09, none of the records should appear...but they do. Valerie Simpkins www.pacetraining.com

I used the suggestion you mentioned in the previous post and adjusted the syntax. It appears to be working. I'll test with more values. Thanx a bunch :) Valerie Simpkins www.pacetraining.com

SELECT `items`.`item`, `items`.`item_state`, `items`.`r_code`, `items`.`quants`, `items`.`it_unlist`, `items`.`discount`, `items`.`it_uncost`, `stock`.`assoc`, `stock`.`desc`, `stock`.`desc2`, `stock`.`uncost`, `stock`.`units`, `stock`.`commited`, `stock`.`bounits`, `stock`.`onorder`...

The values for the filter are passed via parameters at runtime. Here's the selection formula: (If {?GetItem}="ALL ITEMS" then true else {items.item} = {?GetItem}) and (If {?GetAssociation} = "ALL ASSOCIATIONS" then true else {stock.assoc} = {?GetAssociation}) and not ({items.advert} like...

Hi there, I'm using Crystal Reports XI with MOMs 5.4 & 6.0. The report has a parameter for selecting items for the report. The are a ton of items is the list for which to choose. there's also a parameter for selecting an Association code. When the report is run, depending on the # of items...

Hi, Thanks for your help. It worked. The one report I put it in had subreports and I should've put the filter in the subreports. Valerie Simpkins www.pacetraining.com

The previous post shows the entire selection formula as copied and pasted from the formula editor. Valerie Simpkins www.pacetraining.com

That is the entire selection formula. Valerie Simpkins www.pacetraining.com

Hi, I placed the selection formula as follows: ((currentdate in calendar1sthalf and {Hours.DATE} in calendar1sthalf) or (currentdate in calendar2ndhalf and {Hours.DATE} in calendar2ndhalf )) What I'm getting is all the data whether it's in the 1st half or the 2nd half. What it should do is...

Hi, I'm using Crystal Reports XI with an Access database based on employees and hours worked by date. The data pull for the report is based on when the report is run along with the field containing the comparison/qualifying data, the HOURS.DATE field. For example, Today is 5/28/09 so, if the...

Thanks for the info. Quick question, what is the correct data source to use with Timeslips? I had the client install version 8 on her computer, and i don't know what data source should be selected. I've tried several data source connections and it won't work. I've been unable to find any...

hi, i have a client who has just gotten a new computer. she's using Timeslips 10.5 enterprise with crystal reports xi and having trouble connecting to the timeslips data. anyone have any thoughts on this. i should say also that her old machine had Timeslips 10.5 enterprise with crystal reports...