Argh.. I just can't get this.

  • Thread starter Thread starter strafe
  • Start date Start date
S

strafe

I'm currently working on a school project for a tyre management syste
(yeah i know, boring but i didn't choose it). I have a report showin
details of cars belonging to seperate companies, each of which may o
may not be entitled to a 5% discount BEFORE VAT. As far as i can see
the only way i can do this is to use an if statement either inside th
report to decide if the discount exists and THEN perform the resultin
calculation, or to do it in a form and import that data into a report
Both of these ideas have so far been unsuccessful, and i'm desperat
need of help. I either need a way of importing a form as a data sourc
for a report, or a way of performing a VBA if statement inside th
report. :( Any help appreciated
 
How do you check to see if they are entitled to a discount or not? I
you use a flag then you could use something like this in a query an
set that as your record source.

In design view of a query add your table and all your fields, in a
empty field type this


Code
 
How do you check to see if they are entitled to a discount or not? I
you use a flag then you could use something like this in a query an
set that as your record source.

In design view of a query add your table and all your fields, in a
empty field type this


Code
 
Back
Top