Search results

I have a query that is generating two colums, one the states the Start Date and the other that States the End Date. I need to display another column that displays the time difference between the two. Any ideas how?

I have a Transactoin Table that holds the following fields: TransID (*Primary Key Numerical Value) OrderID (Non Unique Number Value, One Order can have multiple Transactions attributed to it. Status (Numerical Value ranging from 0 to 32, each is a different phase in the life of a transaction...

I need to make a coupel of statements that display the total (sum) of negative amounts and positive amounts from a single list of results which comtains both negative and positive values. The two answers need to be displayed in the footer of a report

I have a report of all the earnings and expenses of several transactions from several departments, organized with the total earnigns of each transaction type. The results are both positive and Negative. I need to Separate the Report in two sections between the Positive and Negative Values Work...

I have a report that takes money values form several records and sums them up in various category's making a list of departments with the total amount of balance for each (positive and negative numbers). I need to categorize the positive values form the negative and calculate the totals of each...

I have a single Employees table where several details of employees from several different departments are stored. Amongst this data there is the Department Code (numerical value referring to a Code Description Table) and the Monthly Salary. how can I make a query that displays how much total...

I have a single Employees table where several details of employees from several different departments are stored. Amongst this data there is the Department Code (numerical value referring to a Code Description Table) and the Monthly Salary. how can I make a query that displays how much total...

I have a Form that refers to two Reports, both of which refer to two query's one for each. the whole lot(1 Form, 2 Reports, 2 Querys) is in one mdb file and the actual database is another mdb file. How do I get my objects to get their data from the main Data Base File? the 5 objects are acting...

I require to perform a query that returns all the records between two particular dates, a 'from' date and a 'to' date, both values take from text boxes within a form and both in the following format: 12/12/2005 15:26:00 Anybody has a clue?

Greetings, I'm a bit new to the world of MS Access and have encountered a problem when making a search form for my database. The query is using a Like Condition with the '*' Wildcard for a single field like so: Like "*" & [Forms]![frmPickUpReport]![txtAgentName].[Text] & "*" While the query on...