Search results

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

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

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

HI, I'm working on a DB to track customer sales traffic in a motorcycle shop. The success rate of the sales people is based on a 1-10 scale. Basically I wrote queries to tablulate the number of occurrences of each sales step in the DB, then wrote queries to add those totals together and...