Search results

Hi, im quite new to access and have little/no skill in using VB. I am designing a classifieds car site I want to make a cheackout process, where in the user is taken through lienar forms.. Each form represents a table (e.g User, AdCarDetails, AdType and Payment). I want each table to link to a...

I was able to simplify the SQL into an expression that unexpectedly ran without any sort of error.. however the result was empty regardless if i changed the false value .. IIf([AdCarDetails]![Type]=[CarValuation]![Type] And [AdCarDetails]![Make]=[CarValuation]![Make] And...

Additionally, if i were to create a table with just that: Make Model Type YearOfProduction, then the calculation will be limited as i will need to create a record for every Make, mode and type - for every possible year of production i.e. a bmw in 2006 and 2010.. the way i hope to achieve it is...

i purposely separated these fields as whilst yes there may be repetition, the user has the right to ender any model make or type, but the other table (car valuation) directly exists for the singular purpose of matching the entered make model and type with the make model and type in the car...

Hi, I am new to this forum an quite new microsoft access ! It may sound confusing but here we go: Basically i have two tables (part of my car ad database) in which am utilising to perform a query/calculation/lookup - i don't know what to call it The first table is called "car valuation" - and...