Recent content by aztrix

ok solved it, my union query reset my date field to text. worked that out by creating a 'create table' query from the union query and checking the field formats.

im having a problem with pulling data from a union query from an access database. the field i am looking at is a Date field (Short Date) and im trying to get all records with dates between date one and date two (date picker control in vb6) im using kan ADO connection as follows If...

im wondering if you are looking at my database and just laughing in disgust :) ha ha

how did you go PBaldy?

ok the queries you want to look at are: qryPersonnelAttachedRules_2 qryPersonnelAttachedRules_3 qryPersonnelAttachedRules_AllCals or AllAlerts you should also check out the daisy chain of queries to get to these ones above if you have time, its quite amusing and could possibly hold the key...

ok maybe you can do a check on all the queries and let me know where im going wrong anyways :) that would be fantastic mate.

yup done that, the maths are done in query1 then i try to criteria the Query1 RuleExpired field in Query2 but i still get the error :( sorry bob

ok so how do i query this using it as criteria, as i still get the data type mismatch when i place -1 in the query criteria.

is your way (the correct way) returning a string or integer?

ok, the date fields are just Date not time. ok thanks for your help, ill give it a shot.

then.... RuleExpired: [ExpiryDate]<Now()

ExpiryDate: DateAdd("m",(qryPersonnelAttachedRules_1!Validforperiod),tblRuleAttached!DateCompleted)

ok im having problems with the data type mismatch error. this is giving me some grief but simply i am comparing the two fields ExpiryDate (Date)> CurrentDate (Now()) in a query expression to return a '0' or '-1' if the ExpiryDate is larger than the CurrentDate. this works fine. however when i...

ok so you will have to look at the results from the 1st query and then look how it excludes data in the 2nd. thanks

ok, ill do it in 5 mins. thanks baldy