Search results

I stillcan't seem to get this to work. I've created a basic database with the same general fields.

Ok, the omission bit works fine, but I don't know how to go about the second bit? I've added the week and year fields, but now I'm a little stuck!

Hi all I'm a little lost on where I even begin on this one. I have list of vehicles that need to get checked every week, which gets added to a database. The table the vehicles gets added to is called TblCheck. This has the reg, week, year and a couple of yes/no fields called check and...

PARAMETERS StartDate Text ( 255 ), EndDate Text ( 255 ); SELECT Vehicles.Registration, Vehicles.Type, Vehicles.Make, Vehicles.Descripton, Vehicles.Depot, Vehicles.Leased, Vehicles.Termination, Vehicles.Service, Vehicles.Total, Vehicles.Lease, Vehicles.CC, Vehicles.Term, Vehicles.[Personal Use]...

Hi I've got a query that lists leased items with a start and end date. I'm trying to produce a result where I can type in the start date and end date to find out when the lease is up, but I'm having a few errors coming up. I'm trying to use the field 'Expected Termination' and search for a...

Ah, success! It appears I hadn't set the date format! Thanks for the help!

Between [Start] And [End] This is exactly as written. I've also tried the start and end method, but this didn't work either (that was the original way I thought of doing it before coming on here). This should work but doesn't, so I don't understand what else could possibly affect it?

I added the 'betwee' bit but it still didn't appear to work. I'm using access 2007 if that helps?

All this appears to do is to display today's date?

Hi all I'm trying to write a query based on today's date and whether it sits between a start and end date. I have a table with plenty of fields, two of which are a start date and end date. I want the query to display data if today's date is equal to or between those two dates. I hope this is...

I have a form that I want to use to update two tables with the same information. I have a vehicle and driver table, that are linked by the registration, which is the primary key on the vehicle table. When a new record is entered, I want it to add the new registration to the vehicle table and...

Good news, figured it out! Thanks for your help!

Interesting, but I stripped out the third table, and it's still not allowing me to update anything, or add a record?

Hi I've created a form which runs from a query (which in turn uses three tables to create data). I've opened up the form, and although it pulls through all of the current data I can't modify the data, or add a new record to the form. I've set the properties in the form as edit > Yes, but I...

Ok, stripped out most things and left some data, the query and the report I've created

Just realised that whenever I go to run the query, it comes up with a box asking me to enter a paramet value for exposure, but only when I put criteria in the wanted column. If I use the >creditlimit in the exposure field, then it just produces nothing in the query.

erm, I guess so. How do I go about doing that?

Ok, entered that, but it didn't seem to work. I trie using true or false, and 1 and 0, but neither worked. When I entered either true or 1 into the criteria, nothing comes up I also ran it without the criteria, and it displayed the 1 and 0 correctly.

Hi I have a simple question, but I hardly use access so don't know how to resolve it. I have a column with an expression which adds three columns together to give me exposure. I then need a third column to compare it to credit, so that the query only displays records where the exposure is...

I figured this out about three seconds after I posted (and noticed the arrearsdays appeared where the value should have). I've also replaced the or with an and to get the figures I wanted (I didn't explain what I was trying to do too well earlier) so all is working as it should, and I can...