InfoPath Dev

Hi all

Have written access queries to pull of all results falling between two dates using the dateadd function. When i connect these queries to my infopath form i want it to reutrn all results like it does in the select query, but it only returns the first result.

I feel so close but so far and cannot get this to work. Anyone got any ideas?

Cheers Adam

Anyone hepl on this at all, please?

I'm from WALES
[email protected]

Hi Adam,
Can you paste your query here please?
Are you able to getting all of the results when you run this query on the Database side?


Agni
INFOPATHdev India

Hi Agni

Sorted it through a suggestion from Ms SYM Wong-A-Ton

Use my query to assign a record in one date range to have an identifyer 1, second date range 2, 3rd date range 4 and so on.

Then use DDList box to select the date range from text descriptions that links to either 1 2 3 or 4 Job done.

I'm from WALES
[email protected]

Can you post your example? I am trying to query between two dates and having trouble.