Search results

It is set as a number. I have just checked and the test one I did was set as text. Perhaps changing it would sort it out. Before I do that I'll try what you pasted and post back.

Hey, So I'm basically creating a query that I want to do a Date Add function in. I'm trying to calculate a date based on a field in the query, while using another field that contains the amount of years that I want to increase it by. Brief description being: Warranty: e.g. 4 InstallDate: e.g...

I had tried that and just did again to double check, it's not returning anything. EDIT: Scrap that, actually it's working now - I had missed something on my end. Many thanks. EDIT2: Actually it works kind of... While it now displays Tuesday as I would expect. When I add other criteria to the...

So I'm trying to compare some days of the week. Basically I have a table that has a field called "DayRan" and this contains a day of the week monday, tuesday etc. Then what I'm trying to do is compare it in a query against todays date using Date() formatted as "dddd" so that I can see what runs...

Asset ID is an autonumber and as such Allow Zero Length cannot be set with it. Any other suggestions? Many thanks. EDIT: I seem to have achieved my goal with use of a 'few' find unmatched queries and a Union query.

Hi Guys, So basically I'm trying to create an update query and for the life of me can't workout why it's not working. Basically I have two tables Asset and IP. Asset uses a lookup to lookup the values from the IP table for IPs. Now in the IP table I have a yes/no field named "In Use". What I...