I need to write VBA code for MS Access that runs a query and sets it in the Query Objects view. I have set up and performed operations on tables but can not...

Hi all, My apologies if this post does not respect newsgroup standards. I am unsure what is Okay to post here. I am interested in hearing from Access...

I need to subtract a field sum from another, but they are in different formats. How can I convert one of themor get one to recognize the other? For...

When creating a simple query, how do I write a criteria expression that will retreive only records with a "Yes" value in a field with "Yes/No" data type?

I have a table called tbl_training which stores training data. The fields in the table are as follows: ID (this is the primary key; data type: AutoNumber),...

I am converting a large database to Access and need to divide a field containing full names into seperate fields (ie., First name, middle initial and last...

I write in English and Spanish. Are both spell and grammer checks possible

OK I am a little stumped. I am working on a dispute database. I have a main data table which users update via a form. On this form I have a number of push...

I produce mail merge documents using an Access query, and I need to write numbers as alpha, eg 100 as ONE HUNDRED. Can anyone advise how to do this? Thanks...

Hello, I am using Access 2007 and writing SQL Queries. I insert some line breaks on my queries to help in visualization. When I close and the reopen the...

can you write a syntax that says if text in one field is "x" take the date from another filed add 45 days and populate a third field any help would be...

I have 2 tables and 1 query: tblPersonalInfo containing: dtmHiredDate for Employees (a for Bill, b for Sam, c for Tom) tblJobPromotions containing:...

Hi, what teh CDate convert myDate to wrong date? Please advice... Dim myDate As String myDate = "Jun 13,05" MsgBox CDate(myDate) Debug.Print CDate(myDate) '...

I have a query as shown below that is getting the wrong match. The Lead ID from Combine (which is a query itself) is getting a wrong match from the Lead ID...

Hello all, I recieved a database that has the "Middle Initial" data combined with the "First Name" data, which leaves the middle initial fields all blank. Is...

I need to filter 8 pay periods (PP) from user selected PP. For example if user select PP 12, I need to show every entry between PP 5 and 12. I have set up...

In a simple query on a data table (design view) a Between And is placed on the criteria line of the field "first_attendance" which is formatted in medium...

Dear All, Currently I ask myself if the design of my database is wrong. I have several tables with a lot of fields which use 'Value List' as a row source...

Hi to all, I am getting a data type mismatch in the following query in the where condition: UPDATE tblBudgetBr SET tblBudgetBr. =...

I live in Spain and here the date format is a bit different than in the United States. I've just upgraded to Office 2003 and now, when I combine my word...