Google Search Results

Clear Results

WebCOBRA.com Community Message Boards

Access Data Loader

JudyTatton
Posts: 6
Since: 12/20/2007

QBs table date end's on May 31, 2007
02/06/2009 09:27 AMReply

I'm trying to view terminations as an event type with a date range from 9/1/08 to current and the data stops on 5/31/07. I'm using Access to the the QB table. Any idea what I'm missing?



jwolgamott
Posts: 257
Since: 09/26/2005

RE: QBs table date end's on May 31, 2007
02/06/2009 11:21 AMReply

Judy --

Are you using the RelationalAPI or the WebAPI? also, could you post in your login code?

We can take a look and see what's what.



Systems should be free (to interact with others)

JudyTatton
Posts: 6
Since: 12/20/2007

RE: QBs table date end's on May 31, 2007
02/06/2009 11:29 AMReply

WebAPI

JudyTatton
******



jwolgamott
Posts: 257
Since: 09/26/2005

RE: QBs table date end's on May 31, 2007
02/06/2009 03:14 PMReply

Judy --

Sorry I wasn't clearer -- I just needed your login code, not your username/password.

I edited your post to remove the password, but you should reset your password in webcobra since this is a public forum



Systems should be free (to interact with others)

JudyTatton
Posts: 6
Since: 12/20/2007

RE: QBs table date end's on May 31, 2007
02/06/2009 03:22 PMReply

gbsb



jwolgamott
Posts: 257
Since: 09/26/2005

RE: QBs table date end's on May 31, 2007
02/06/2009 03:39 PMReply

Judy --

How many total records are in the QB table?



Systems should be free (to interact with others)

JudyTatton
Posts: 6
Since: 12/20/2007

RE: QBs table date end's on May 31, 2007
02/06/2009 04:06 PMReply

6606 in QB table

But if I create a report in access by going:

Reports -> Create report by using wizard -> I'm using QBs (terminated employees names and event type)and ClientEmployers (to get the company names).

It's not pulling all of the most recent terminations.

I could sort from the QB table if it had the client name added.



JudyTatton
Posts: 6
Since: 12/20/2007

RE: QBs table date end's on May 31, 2007
02/13/2009 12:07 PMReply

Hate to be a pain, but I'm still not seeing any recently terminated employees showing up on any of the reports.

Any idea, what I might be doing wrong?



jwolgamott
Posts: 257
Since: 09/26/2005

RE: QBs table date end's on May 31, 2007
02/13/2009 02:31 PMReply

@Judy -- I think you were getting an error about a duplicate key... please try it again



Systems should be free (to interact with others)
Return to Forum