MS Access Question

Marky · 28 Aug 2009 at 11:48

Hey all,

Currently making a database - and have run into a problem...

I have a query with multiple fields - however, I have two fields of information and I need a new field to display the two together...

I.e.

Field 1 = 1
Field 2 = 5

Field 3 = 6

So basically, I need to know the expression for this (I'm imagining it to be =SUM(Field 1+Field2))

If anyone could help, I'd be very grateful

Thanks,
Marky

Marky · 28 Aug 2009 at 17:40

Hmm you would have thought - but it continues to come back with a syntax error...

However - no worries, I've made a work around - but in that I've created another problem for myself...

Is there anyway to display the results of a query in a form? I don't really want it to be displayed in editable fields... If I could just put a report into a form that would be great - but I don't think that's possible.

But if there is a way to produce a neat list of a query (Like the report) but in a form - could anyone help me out with it?

Thanks,

Marky

Marky · 30 Aug 2009 at 17:43

Bump - Still need help with this

Marky · 1 Sep 2009 at 10:02

Thanks for the help guys - I've managed to sort it now.

What I wanted was to place a report (I.e. A printable non-editable report) into a form. Turns out it's completely impossible to display it any way other than through a print preview

Therefore - I just put a sub-form into a form and run a query to display the relevant data on the screen

Thanks again