Search results

Thanks for your help, Unfortunately I'm still getting a "This expression is typed incorrectly or is to complex to be evaluated..." error message when I run the query. I'll keep playin with it. -shane.

Howdy. I'm trying to set date criteria in a query based on the day of the week. On wed-fri I only need one date value in the criteria, which works fine. On tuesdays, however I need the previous thursday and friday to be criteria. I'm currently calling a function in the criteria box on the...

Hi Pat, thanks for your help. I tried to find a way around using the DLookups, because as i've read in your posts before, they're slow, but in this application they seemed like the only route. Basically for each record I need to calculate based on totals from other records, for example if joe...

Dlookup in function, is there a way around? Hiya. First off i'm in access02, I have a big nasty query that pulls data from local tables as well as a remote table elsewhere on the lan. The remote table is in access97 and is generated by our phone system reporting software and can't be...

ok, figgered it out what with the single quotes and the double quotes and the whatnot. I did find a somewhat useful reference here for folks coming in from different languages http://pixelloom.com/resources/table.htm pretty basic, but maybe helpful. heres how it worked Private Function...

I'm having a bit of trouble with the syntax on a function i'm working on. It basically needs to calculate the criteria value for a DLookup. I'm coming from a perl background, so the ins and outs of vba elude me. Here's the code I have Private Function gprank() If Me.gpranknum = 1 Then...

Hello all. I have a strange problem with one of my reports. It is fed by a query which draws data from numerous other queries drawing data from multiple computers on the network. The purpose of this report is to tabulate sales statistics, phone followup statistics and employee ranking for...

This is a really old thread, but it took some serious digging for me to figure this out, so i figured I'd post what I did. I had 2 tables, one i'd created, storing customer information including phone number, one that was imported from our phone system via an app called callanalyst. For the...

I don't think its possible as a pdf file is basically a postscript image in a proprietary adobe format. You would need an intermediate step involving acrobat or illustrator I'd imagine. Distill out the text and export it into a format access could import. There may be other ways around, but...

yep, got it working. now about my lawn...

Thanks Mile. I haven't quite got the fancy calendar form up and running yet, but the Between function is doing the trick. Thanks a bundle for your help. -shane.

Thanks Harry, you rule. That simplifies things a great deal and gives me a good place to start with future queries. for the more pointed ones I found a workaround thats less elegant than yours, but i suppose the end of the line is all that matters. SELECT DISTINCT dupestest.salesperson...

I just realized that I spelled that out backwards, its not 5 thru 1 that needs to be tabulated, its 5 thru 10

Those are good ideas. I've incorporated logic like that in the grand totals queries, which are quite a bit less complicated than the more salesperson, and sales step specific ones. Unfortunately a true average, i.e. 4.5 doesn't provide useful data, as the sales staff is compensated on whole...

In response to Harry, If a customer comes in multiple times, there will need to be new entries for each visit. Salespeople are compensated based on the sales step they are able to take a customer to, so if a customer comes in multiple times and gets a little farther down the process each time...

I'm sorry, I exported the file incorrectly. I was unfamiliar with access's file export conventions, Thats how green I am. Here is a file that should work, and again I appreciate your taking the time to look at it.

here it is. Thanks for your help.

Well one query actually feeds the report, but there are numerous that feed that one query. For the 10 sales steps, there are basically 3 queries for each step, one to figure the occurrences of that step, one to tally the occurrences of that step with those higher, and one to figure the...

actually I have one main table for the collected data. the columns are ID(autonumber), salesperson, date, customer_name, phone_home, phone_cell, phone_work, email, source, new_used, unit_class, unit_make, manual_model, unit_model, unit_price, time_spent, sales_steps, comments. I have several...

its more like 60, but yeah its rediculous. It works, but I KNOW it can be done much much better. Like I said, i'm calculating percentages of a certain field in the database per another field. So say for example I wanted to know the percentage of salespeople that hit sales step 5, I...