Calling all Access experts....

[StewartKnight]

Hi,

 

I'm doing a database to loan out IT equipment using Micro$haft access.

Are there any experts available to help if I get stuck....

 

Oh BTW did I mention this is urgent!!!!!

[Gatt]

I can try and help you - what version of access u got?

[kmount]

Hi Stewart,

 

Sure between the lot of us we can help get you moving if you have any problems!

[powdarrmonkey]

Yeh, I used to write a lot of access professionally, can't promise about being awake though...

[StewartKnight]

the database is in Access 2003 format.

 

So far I'm doing ok, does anyone know how to query on dates?

I want to produce a list of items due back that day, and those that are late back as well

[HMCTech]

the database is in Access 2003 format.

 

So far I'm doing ok, does anyone know how to query on dates?

I want to produce a list of items due back that day, and those that are late back as well

 

Urm might not ne right but first thing that popped into my head was

 

SELECT items

FROM yourtable

WHERE duedate => #01-01-2008#

ORDER BY items;

[featured_spectre]

that looks pretty much right, although I am basing my SQL expertise on Oracle SQL.

[StewartKnight]

actually, I've never used Access or SQL before, but it's a doddle!

 

He says till he gets stuck!!!!

 

I have a working database with the forms doing what I want, and the reports working too. I'm just smartening it up.

 

I've found that once you've got the queries working, the rest just follows naturally.

 

Mind you, I'm probably doing it wrong!

[StewartKnight]

however......

 

what is bugging me is, the stuff can be loaned for 5 days maximum

How do I set the parameter date() + 5 to stop hires of longer than 5 days?

[featured_spectre]

if you upload a copy i will take a look for you and will see what i can do.

 

Carl

[StewartKnight]

sorted it all now, thanks anyway.