When using "Between and " where Start and Finish are Time fields, I've noticed some inconsistencies where one or both of the times are the same as one or...

Is there a way to calculate percentages in a pivot table? -- Rose

Thank you all for looking, I very much appreciate any suggestions. I have a database that is has a summary table that has a collection of data about...

Does anyone know what is causing this error? Reserved error Item; there is no message for this error. (Error 3000) An unexpected error occurred. The...

Need to select top 20 records by location based on the sum of balances. Here is what I have so far, but it is only giving me the top 20 of all not of each...

is there an easy way when entering information in a database for Access to look and see if the information is already in yoru database? I am using Access...

I am trying to sum records in a query and I am not getting a value for the following: SELECT TotalOnline.Date, TotalOnline.Shift, ++++ +++++ AS...

Hi, I'm using Access 2003 and have been doing a bunch of volunteer work for an organization from home. I've created several new queries and reports on some...

I need to normalize by moving a field from one table to another. How can I update the field after I move it? For example, I'm moving from tblOld to tblNew....

I am trying to call a function written in VBA using the runcode command within the macro window. How do I declare the function and then call it...

I have created a data base with a large amount of information for cross referencing purposes. It mostly consists of lots of queries. Each query is a list...

I am building a line capacity table for a can routing in a factory. Several machines, each as a line capacity in a column - one column one machine. How do I...

I have a query (named qry_Safety_ITSRR_Sub1) that bases on another two queries. Those two queries are all right when they're run seperately. But when I run...

Hi, i have 2 query and 2 Table, Table A AAA 2 qty BBB 1 qty CCC 3 qty Query 1 - sum up Table A = 6 qty

I am trying to create a calculated expression in a query to sum the total weeks service each individual has worked in their current department. For example...

I have a query (named qry_Safety_ITSRR_Sub1) that bases on another two queries. Those two queries are all right when they're run seperately. But when I run...

Hi, I have access database with date column and number of rows with same date but with different time, I'm trying to view names from database that has the...

I am creating an application which will have 20+ users. In order to minimize errors or record locking issues, I have created three tables for each record....

What does this mean in criteria for date? Thanks

I have SQL that I am trying to put into the SQL view of an access query, that is not working. At a glance, can you scan this and tell me what you think...