I have a record in a table that I would like to Update from one status to another status. The problem is the record I want to update contains the StatusID...

is there a way in which i could insert or update a field in a table using a value calcuated in a query to an existing row in the table? now in one of my...

in my database, i got an invoice table with field invoice_no, client_no, total a job table with job_no, job_amount, invoice_no a part table with part_no,...

I'm sure its already been posted but I wasn't able to find anything on this. I have a table that has a field "Unit Price" which is a sined field. I need to...

is there a way in which i could insert or update a field in a table using a value calcuated in a query to an existing row in the table? now in one of my...

I'm calculating the difference between two dates (in months) and I am receiving an 'enter parameter value' prompt when I try and run the query: SELECT...

I am trying to run an update query (let me know if this is a better way) to Update the field in a table tbl_Transactions. I want to multiply the by -1 if...

is there a way in which i could insert or update a field in a table using a value calcuated in a query to an existing row in the table? now in one of my...

Good Day, I have an access database with an employees table. This table has employee ids, first names and last names. I also have a form which...

Hello all; I have created a search query. I want to put in search criteria that would filter the data. All I want to do is have the software look for two...

I have a many-to-many relationship set up (with a linking table with two one- many relationships), where both "many" sides include a UserID that references a...

Like "*"&&"*" where Record ID is entered by a user how I can make sure what they enter is seen as a string so that a user does not have a problem...

I'm trying to combine this data: SELECT tbl_PullData.FiscalYear, tbl_PullData.Period, tbl_PullData.Store, tbl_Stores., tbl_PullData.Date, tbl_PullData.,...

Hi I have a query in access. I have 1 table in my query and 14 fields in my table. I am using all 14 fields in my query and have sorted the first 13 fields in...

SELECT SUM(Binding_physical_damage + binding_damaging_repairs + binding_chemical_damage + binding_biological_damage + binding_brittle_paper) as...

Like "*"&&"*" where Record ID is entered by a user how I can make sure what they enter is seen as a string so that a user does not have a problem...

Seen an unanswered post the other day and was interested in what the solution may be. The question was or simular to: If you wanted to sort by colors VS....

I have a large table, with many instances of data. Each record has an identifier field and a date field. I want to find the first occurence of the record...

Hi, I'm trying to design a sort of search panel where the user types in the first few letters of a customer's name into a textbox, clicks a command button,...

I have a table that has fields T1 to T10 corresponting to fields DEC1 to DEC10 and I would like to search the fields in DEC1 to DEC10 , based on a criteria...