Search results

been looking all over and following links to suggestions and tips and i'm still not getting it right. i have created a query based on the table using only the time controls i.e "opened date" and "resolved date". in the field tab of the query i created a field called "Time Taken" Time Taken...

please can someone help me. i have a opened date[default value =Now()] and resolved date[default value =Now()]. i would like to calculate the time elapsed between the two dates. it is normally on the same day, but there are instances where it can run past midnight.

Can anyone please, please help me. I would like to make some changes to the Northwind sample database. it will work perfectly for me. I need to have the Customers section completely removed as my company issues products to our own staff, not to external customers, so there is no Customers and...

Hi I have a query (Inventory Transactions Extended) in which i am trying to caculate current stock. I have a form (Inventory Transactions Form) where i either add or remove Inventory Items. I have used this statement to create a new field (Actual Quantity) to calculate current stock based on...

Really??? Thanks anyway. the form i have has 3x subforms on it, one for the inventory table, one for the vehicle table and one for the customer table. when i try and open the form it comes up completely blank, the aren't even controls on it. i have now moved the customer details to the cases...

hi so im having a bit of a problem. i have a number of tables...ie... tblcases: (title, assigned to, opened by, opened date, customer, status, category, priority, description, due date, comments, resolved date) tblcustomers: (last name, first name, email address, contact number, house number...

I'm actually tryng to remove the duplicates on the query. The two tables are joined on a one to many relationship where many records in table 2 equal one record in table 1. What my query does is remove all the zero values in table 2 then generates a report based on table 1's ID What I need is...

I have a query which gets information from 2x tables where the I'd on one table is the reference number on the second table. I would like to know how I can remove the duplicates on my reference number field?

do i follow the methods described in this link only on my backend or do i have to do it on the front end as well? all my other tables are ok, its just the one that gives me problems. i have already isolated the corupted entries.tion now is how to repair them without losing the links to the other...

decompile doesnt work

i seem to have some corrupted data...i think... im also not running any code on the table. i dont really have a lot of code as i dont really know much about it, anyway...the code i have is all on my forms. will try a de-compile...hope it works i am loathe to lose all the data thanks for the input

no. doesn't seem to be #deleted entries. the entries are still there if i run the query. its only when i try to generate a report that it gives me the error. tried compact and repair...doesn't sort the problem out

hi all i have a table on my database from which i generate a monthly report by running a query. when i run the query (date from to date to) i have no problem. it shows me all the relevant records. when i want to generate a report, i input the start date and the closing date for the report. it...

Hi Sorry about the lack of info. I have a number of fields... Start date Completion date... These 2x fields are "short date" Then I have 3x time fields... Time received Time started Time completed... I'm using a calculated field at the moment between time received and time completed. Most of...

hi i have 3x time fields in a table i.e time received, time started, time completed i need to accurately caculate the time between time received and time completed. whenever the time goes past 00:00 it seems to add 24 hrs to my calculated time is there a macro or code that i can use to rectify...

Hi I'm new to this programming thing. Set up a database at work at have received a lot of help on this forum, so just wanna thk all u guys from whom I got ideas and tips