Recent content by Pyscho

I have a text box with this formula in (its for the parking fee): =([pToDate]-[pFromDate])*IIf([Sitename]=Orange site,4.5,9) But it keeps returning an error. The pToDate-pFromDate work fine, they just count the number of days, but it should mulitiply this by £4.50 if sitename is Orange site...

I have a field called 'Discount' in my table called 'Bill'. I set the data type of the Discount field to 'Number' along with.. Field size: Long integer Format: currency But my problem is, when i type in, for e.g, £4.50 it changes it to £5.00. It keeps rounding it up to the nearest pound. How...

But not easy for me, as its been years since ive done this kinda stuff. I got a field called 'CreditCard#' in a table called Customer. The data type of this field, i've set to 'Number' but how do i format it so it only allows the user to enter in a 16 digit number? Please help, thanks.

I have these 3 tables. Customer(cust# , fname, surname, tel#, address, ccard#) Car(reg# , make, model, year) Uses( cust# , reg# ) im trying to set a 'Many:Many' relationship between.. Customer and Uses (using cust# in both tables) Uses and Car (using reg# in both tables) (as, many customer...

'Many' customers can make 'many' bookings (Many:Many) (booking for a parking space) Does that sound right? I got so confused thinking about it, i know its a simple answer to it. Does it mean the same person can make more than 1 booking? Im also confused as to whether it indicated that many...

Does any one have any ideas on this question?

I'm just starting the process of constructing a database system in Access, about a parking system. In brief, my database should be able to support the following activites: -to check the availability of parking and be able to quote the parking free -take a booking,alter the booking or delete the...