Search results

The data will be eventually be displayed on a report and in a form. How can I create this in a form / report ? Thanks

This database is in it's early stages so I'm thinking of just scrapping it and starting again. If I were to start again what would be the best way to have 3 columns 1. Date Checked 2. VIP Pass or fail 3. VIP Fail date. What I need is for the 'VIP Fail date' field to be populated with a...

It just keeps coming up with 'Data Type Mismatch' when ever I try and run it

SELECT [Standards Check record].[Date Checked], [Standards Check record].[VIP PASS 1], [Standards Check record].[VIP Fail date] FROM [Standards Check record] WHERE ((([Standards Check record].[VIP Fail date])=IIf([VIP PASS 1]=False,DateAdd("d",90,[Date Checked]),"")));

Hi, Still no joy

Thanks for the reply. It still doesn't populate the VIP fail date field

Hi, I've tried it with 0 aswell but still no joy.

Thanks for getting back to me again Paul, What I need to happen is that when we check one of the vehicles in our fleet we enter the date it was checked into the 'Date Checked field'. If we then decide it is not fit for VIP work we will select 'No' in the 'VIP Pass' field which will then...

SELECT [Standards Check record].[Date Checked], [Standards Check record].[VIP PASS 1], [Standards Check record].[VIP Fail date] FROM [Standards Check record] WHERE ((([Standards Check record].[VIP Fail date])=IIf([VIP PASS 1]=No,DateAdd("d",90,[Date Checked]),"")));

How do I do that ??

Hi Paul, its stays blank when the Vip pass is false aswell. Vip pass is linked to another table which gives it it's 'yes' or 'no' values

Thanks again Paul, sorry about the delay in replying. I've tried the IIF statement you gave me but when I run the query the VIP Fail date is blank Any ideas ???

Thanks for the response Paul. I have used a Query and attempted to create this myself using the 'build' function but I'm not getting very far. The field I mentioned are all from the same table I'm just struggling to create the correct IIF statement in my query.

Thanks pr2-eugin

Hi, I am new to access and I'm having a little trouble using IIF statements. I have a field in my Access table named 'Date Checked' a one named 'VIP Pass' and a one named 'VIP Fail date'. What I am trying to do . . . If the answer in the 'VIP Pass' field is NO I need the 'VIP Fail Date'...

Hello, just joined today hope I can get some much needed help !!!