I have a decimal value into hours and minutes. The decimal value of 1.09 should equal 1:05 Is there a function to do this? Thanks

Hello All here is the SQL i am working on: SELECT dbo_CUSTOMER.NAME AS CustomerName, dbo_CUSTOMER_ORDER.CUSTOMER_ID AS CustomerID, dbo_CUSTOMER_ORDER.ID AS...

I have my query set up to place a number instaed of the actual selection to go into my table. This is based on a lookup from another table. I.E. You select a...

We are testing a new procedures/process for extracting data from multiple sources . To test the results we use a query comparing the two tables and test...

I have a form, frmParameterForm, that has 10 checkboxes on it, chk1-chk10. I also have 10 queries, qry1-qry10, that are corespond with the same # checkbox. ...

Hello, I have one table with one column that lists all customers' name. e.g. NAME Brian Dan John

I'm trying to work up a dynamic crosstab query. The criteria I have to use is bouncing against a text field holding data like "0810", "0712" - basically a...

I am building a db that lists number of entries by person each two week period. So right now it shows a list of people with the number of entries each under...

Hello all, I hope I can explain this. Le me first show you the data: PP Nest 857 000123 857 000123 857 000123 857 526987 857 001450

Hello. I have set a simple query based on one table. The problem is, when I add a second table to choose from on the query design, and run the same query, it...

I work in the healthcare industry and in order to qualify a patient for a discounted fee I need to be able to calculate where they fall in the Federal...

I'm trying to calculate the cubed root of a number in an Access query. Can anyone help me figure this out? Or, can it even be done?

I just started working with access and having issue with calculating a total. For example in a query I am attempting to calculate the results of Column A -...

Any clue on how I might write a Select statement to retrieve the records which were NOT selected from this Summary Query? strSQL2 = "SELECT DISTINCTROW...

I have a query result with one column has 250 records. Some of them are duplicates and I want to set up a new query with only unique records from that 250...

I have a data base used to transact sales . I have an "invoiced sales report", which has a data soiurce called "invoiced sales query". It pulls invoices out of...

What is the syntax for hyperlinkpart in a query? I already have the address in the linked field, but I need to change the display text only without...

I have a query stored in Access 2007 that populates a sheet in Excel 2007. The query has two limits, Not Like *track* for a part description and a Is Not...

Can someone walk me through writing code (or any other solution) for a parameter query that uses a form to select the parameter criteria. The search is for...

I have a table and it has numbers in the one item and I would like it to add the them together and show my there name in the table. Thanks, Anthony