wevans
Last Activity: Mar 8 '08, 07:41 PM
Joined: Feb 14 '08
Location:
-
Silly me. I just created a Union query and all my problems went away. lol -
Query mutiple tables with date input.
I have 3 tables, Customer, Offsite Service and service. I need to create a sales report/query based on the results of the user input, which is a date range. I've got it working great with two of the tables, but not the third. Here's the code for the working one I have now.
...Code:SELECT [Customer List].[Last Name], [Customer List].[First Name], First([Service Records].Date) AS [First Of Date], Sum([Service Records].Price) AS Price
-
I ended up creating another query based on that previous query. Then based the labels report on the second query. This did exactly what I wanted to do. If you still got a solution to do it with one query, I would still like to know how to do that. Thank youLeave a comment:
-
Return unique entries in access
Somehow I need to only return 1 record if there's two or more in the tables. I'm using this to create a mailing list labels so I don't want to print two or more labels for the same person. I want to find duplicate First and Last Name. Like Tim Wolf appears twice. I just need one label for him. But I need to print a label for Tina Wolf, and so on.
Here's my code so far, only reason I have code is cause access did it for me. I couldn't... -
Error in Access 2007 Corrupt VBA project
I designed a db in Access 07 and opened it up once in Access 2003. No when I open it up in 07 again I get this message...
"The database cannot be opened because the VBA project contained in it
cannot be read. The database can be opened only if the VBA project is
first deleted. Deleting the VBA project removes all code from modules,
forms and reports"
Is there any way to extract the vba... -
Calendar Control in excel
Hi and ty in advance.
First of all I have no experience in vb, vba or any type of coding. So please try to explain it as simple as you can.
Here's what I would like to do, if at all possible. I want to create an excel workbook schedule with 13 pages. First page will have a calendar on it. The rest of the pages will be months. I would like to use a calendar control and if clicking on a date, it will jump to a specific sheet and... -
Calendar - Schedule Access 2007
Hello all.
I'm new to access and am trying to create a calendar/schedule in access. Yes I know there's a bunch of other ways and software to use, but I want to keep it together with the database I already have. I'm new to access and know very little about "coding" (vba) or anything else. Point and click I'm good at. LOL
Here's what I'm working with....
I have 5 days Mon-Fri.. Each day has 8 time...
No activity results to display
Leave a comment: