I work for a residential home builder. I have a query that pulls notes regarding homes. I have another query that combines these notes with the details of...

I have calculated date field in my query: Target Closure Date: +45 the problem is when i try to filter particular date range in the Target Closure Date field...

I have a table of Job Codes as follows: Job Code Job Family Number The Job Code field is populated, but the Job Family Number field is currently...

I need to retrieve data from a table which is 4 columns by 4 rows, I have the column and row information but don't know what statement to use to look up the...

I have a query that is grouping by a process ID. This ID has several different names associated with it due to entry errors, etc. I would like to group by...

In an Access database append query, I could put Forms!frmOrders.OrderID in and append it to an order details table. I can't seem to be able to do this...

Hi, I have a table where we key-in Delivery notes for customers; in my form I use the following : =Nz(DMax("","delivery note table"),0)+1 to have continuous...

I have an update query where I am trying to remove the '.' out of the version number and populating a numeric field. On execution I get a type conversion...

Hi, Can somebody help me with an urgent request, please? I have been given an Access database file that has the table 'Table' and a field 'surname'. Data in...

how come when I'm doing some SQL queries, access auto change my dates to strings??

I'm trying to write an update query, but am stuck because the criteria required make the query non-updateable. tblTask: TaskID (pk) TaskName Price Completed

I have an excel sheet linked to an access database but it is setup as read only(and must stay that way), It will not allow me to run queries...(I keep...

i want to calculate the overtime hours if someone work from 6 am to 4 pm but the work duty is from(7:30 to 2:30) i donot want to calculate the time between...

Hi , I'm quite new to microsoft access program especially access query. Could you explain to me what type of query should i use to get my output table. At the...

Hello all, I am not an Access user but I am having to convert a badly written VBA interface which pulls information from a database. It uses the following...

Not to good on IIF statements, i need one to show IFF qty received is greater than or = to qty ordered then show 0 i,ve tried but can not seem to get it to...

Hi I have a table with many duplicate records...I have used the duplicate query wizard to select the duplicate records....I specified a duplicate as having...

HI, Please help. I am working on a project with over 200,000 counts. Someone suggests I use Access but I don’t know much about Access. The data I work on...

I'm using a form and query to bring up records from a table between selected dates. I've used the query to ask the user to input the "start" and "finish"...

I have created a database which hold customer details, stock control and sales. I am having difficulty with the following. When I sell and Item I need this...