Recent content by anasttin

Hi everyone, I have a table of data with 3 fields: "part_number", "date_of_price_change" and "new_price", but I need to convert the "new_price" field to show the "price_change", rather than the full "new_price" of each part on each date. This will obviously involve some process that looks...

Thanks so much Galaxiom... that's awesome and will save me a lot of time. Much appreciate the help. :)

Hi, I've set up an access database and in one of the fields in my table the numbers are stored as text and negative numbers have a "-" character preceding them. When I change the field data type from text to numbers in the SQL, I lose the negative values from my output. ie. in my code below...

Thanks sneuberg but I already tried that. With the button (linked to a query) on the form, it takes about 40 seconds to load the database but without the button, it takes about 4 seconds. No other buttons being added or deleted seem to do that. Very strange. Any other thoughts? Thanks in...

I've got a form that loads when my access database does. It works fine, until I add a particular command button to run a query. Can anyone advise why adding a command button should slow it all down considering that I already have other command buttons running other queries on the form? Any...