importing data - driving me mad :(

[joe_stas]

Hi

I am pulling in three fields to my report

reference, transaction date and payment date.

Some payment date fields are blank for some of my entries as they have yet to pay. However, all the blank ones are missed out of my report when I input them. If I delete the 'payment date' column my report returns 10,000 entries. When I put this column back in, it reduces the entries to 3,000.

I'm assuming this must be an easy problem to remedy?

THanks for your time
Joe

[jasonli]

It's not related to your report. Check your SQL query. maybe you inner join tables by that field.

Hope it helps.