Search results

Re: optimize performance for recurring query - solved I figured out where my problem was. As was pointed out, the query was using more clock cycles than necessary. I created my own problem by linking a local table with the week number to a network table with the data I wanted. Rather than...

We operate on a Monday-Sunday week, so in autoexec i have the following: set warnings no run sql (as transaction) UPDATE ACCRUAL SET ACCRUAL.ACCRUED = "X" WHERE ((Now()>=[ACCRUAL].[FINISH])); run sql (as transaction) SELECT Max(ACCRUAL.WEEK) AS MaxOfWEEK INTO accrualstore FROM ACCRUAL HAVING...

Thanks for the feedback. Yeah, I know the query is convoluted, but it is pulling data from multiple tables. m_m_trx would be considered the "main" table because that's where the activity on each client's account is recorded. The data is deliberately *not* summarized because the client imports...

I'm posting two versions of my query. Table names were compacted for privacy. The first is the one that works quickly but has to be set manually each time. SELECT M_RPT_STAGE_NAT_CLIENT.NAT_CLIENT_ID, M_RPT_STAGE_NAT_CLIENT.NAME, M_CLIENT.CLIENT_ID, M_CLIENT.NAME, M_S.DLR_ID...

I have spreadsheet reports I generate for some clients on a weekly basis. Each report shows the activity for the previous week. I've built VBA that can run the query and send the report, but I'm hitting a major performance problem with regards to the query itself. If I manually enter the week...

Hi David, Unfortunately no, the sickvacuse.event_ID is not related to the cycle numbers. Employees take time as they need it, so if they wanted to, they could take 1 vacation day in 10 different payroll cycles so there'd be 10 records in the sickvacuse table. But I can create a cycle field...

I've been assigned the task of tracking vacation hours for a small group of employees out in California. California has some interesting rules about employee vacation, among which is that once time has been earned, it stays available to that employee until they use it or are no longer employed...