Recent content by lordrom

I've changed it to many things. I take it I cannot calculate a value/column and then use that value to recalculate another column? I have removed all reference to values calculated within this query and now it works

i amended some input columns to remove the possibility of null values, and now can sort the column. however, when i try to enter a criteria it asks for a parameter for some other column. any thoughts at all please?

I can run my query and retreive the results, however, when I try to add a criteria (col value >0.04) I get a Division By Zero message. I also get this when I try to sort on the same column. Any ideas please? Thanks in advance

I am starting to build a database and have to decide whether to use select queries or make table queries. Can anyone advise me on when it is best to use either type of query please? Are there guidelines on which is best in different circumstances?

i created a primary key on 3 fields to determine uniqueness, and set the append query to return only unique values only it gives an error about not being able to insert all the records, but if i click add anyway it does append the new rows only. so i have it working, but i'm not sure it is the...

HI, I currently get sent rows and rows of data, but am only ever interested in the last row of data for an event that I receive. I want to create a table that only shows me the last rows for these events, so i created a make table query that retreives the 'LAST' values. The problem with this...