Search results

Date Range So how was that formatted? Did you just have for example 11/1/04-12/5/04 in that field for each record? -Paul

Added Picture of Date Table Here is what I built, not sure if I'm off base or if there is a better way I could do it. See screen shot of part of table attached Thanks, Paul

Hello, I am building a Db that will report against individual transactions. Each transaction will be on a specific day. Now I will need to slice and dice the data in a number of different ways depending on what the end user wants to see. Therefore I need to build a date table that will...

Couldn't make it work I haven't ben able to get it to work yet, but am still trying to work on it. If I can get something figured out, I'll let you know. -Paul

I'm looking for someone to help me with a solution to my problem of importing data into a data table. What I'd like to do is have a command button on a form. When this button is clicked the records in a table are cleared out. Then I'd like for a browse window to come up to locate an Excel...

Here's the SQL of the Query Could someone help me figure out how I'd do that based upon this query? Thanks, Paul SELECT DISTINCTROW [CORE TABLE].CATEGORY, [CORE TABLE].SEGMENT, [CORE TABLE].[SUB SEGMENT], [CORE TABLE].CORE_UPC, [CORE TABLE].CORE_ITEM, Sum(ACNDATA.ACNUNITVOLCUR) AS [Sum Of...

I'm looking for someone that knows how to link check boxes on a form to the "show" check-box in a query. Basically, all I'm trying to do is have the end-user tell the query which fields to show in the output. If checkbox "A" is checked on a form prior to kicking off the query, I'd like field...

I need help I am stuck!! It's been a while since I've been using Access and I'm trying to merge two data sources into a report. I can not get my output correct and I'm 99% sure it's my relationships. Is there anyone that would take a quick look at my file and tell me what I need to do. I'm...