MS Access Question

Marky

Marky

Marky

Soldato
Joined
16 Apr 2007
Posts
23,428
Location
UK
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
 
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
 
Sorry but i'm not really clear on what it is your trying to do?

Show the table view of a query, rows of records etc but in a non editable way? if thats the case why use a form. Try using the report wizard I think that will give you what you want. You can then export it in .snp format from access or use bullzip or something similar to export it to a pdf.

The report wizard is quite good and you can just display your query in there.

Rereading your post actually i think you may have users in the database but dont want them to be able to edit the data that comes from the query? I'm not sure what you mean by put a report into a form but try the report wizard and see if that produces what you need.

edit: Oh and when writing your query did you use brackets ( ) around your field names? you should use [ ] square brackets for field names and the others to enclose the query if needed.
 
Last edited:
If you want to set up a form with non-editable data, it's just a case of changing the properties of the text boxes on the form that should be uneditable, or alternatively basing the form on a query that cannot update data.

However, unless you're doing something with part of a form, and just need the uneditable data for reference, you're better putting it in a report.
 
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 :p

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

Thanks again ;)
 
You must log in or register to reply here.
Back
Top Bottom