Search results

http://answers.microsoft.com/en-us/office/forum/office_2010-access/union-query-for-crosstab-quieres/06571a30-264e-41fe-8fd8-4ab66e129145 Did some more web browsing, looks like must do the union first, then run the crosstab. Seems promising, I'll post when confirmed.

Stuck here a bit creating the UNION query for my two cross tab queries. It's my first venture into UNION queries and Crosstab queries and proving quite challenging. Used the instructions here...

Thanks I'll give a go with a union query when I get home from work. :)

Access 2003 Win XP, 7 hey all, I'm having some issues with the dispay of some data created in multiple crosstab queries. I can easily get the data that I want to display, but I'm having a hard time to format the results in something that looks close to what I want. My ideal display...

Please excuse my photo editing job! :) Win 7 Access 03 New user but active DB admin and learning fast I'm having issues with a small group of end users who despite training manage to create havoc with the customer list in DB. My form design obviously needs to be more robust to alleviate some...

Then it works perfectly of course! I couldn't figure out exactly how to do that in the design view (do not display and type expression would have been good). Trying to learn more and more SQL. Thanks!

SELECT STD21Basic.STD21PacketSentDate, Count(STD21Basic.STDID) AS CntSTDID FROM STD21Basic GROUP BY STD21Basic.STD21PacketSentDate HAVING (((STD21Basic.STD21PacketSentDate)>Date()-[Search how many days past?])); SELECT Sum(qPacketSentCount.CntSTDID) AS [Total Packets in Search] FROM...

Hey Brian, Hopefully someone with more Outlook VBA skills than I have chimes in. I've been looking for the same thing for my application. Best I've been able to come up with is a forward/move rule set in Outlook depending on the subject line. it's a bit clunky but solves the issue for me...

Created a quick sample for you to check out the logic. Place them both on your C drive in the C:\ . Open the Access database and click the run macro button. :) Code will be a little difficult to provide beacuse it is very specific to the names of your forms, queries, excel file ect. This...

I also use excel to publish some charts that I can't get in access. The process that I use starts via macro in access. 1. run necessary queries 2. transfer spreadsheet command to export the data to my excel file 3. Run app command to open excel 4. Excel auto_open VBA to manipulate the data...

Jim, The code (or pieces of it) can be pasted into the SQL view. From your query in design view go to the view menu and select SQL view. You'll see code similar to the one posted above. You can edit, amend and or copy paste directly there.

Hey all, New to exploring access and having fun doing it! I want to learn more about the difference between defining a relationship on the relationship window vs. Doing it only as a join in the query. I gather that from the relationship area it will apply to all future queries using those...

Very cool. I spent a bunch of time to set it up and they worked great! Followup question not totally related to subreport. Is it possible to show report output of 1 field laterally instead of vertically? I'm using a continous form and the format makes me question if it's possible. For example...

Hey all, Still new to access and working out a report issue. I believe I need to use subreports to display the data I want and am trying to ensure I have a clear(ish) understanding before getting really deep into it. I have my employee table with personal info which included employee ID...

I think this sums it all up. My append query works beautifully. Thanks!

Hey all, New to access but learning every day. I'm working to merge two access databases so I can retire the old one. I'm currently working on merging multiple fields from one table into one table that will allow one--> many. In the current setup [CFISupp] any particular CFI can only have 1...

Would not give proper results but got me thinking about how I was excluding null. Read up on nz and Iff relating to use of null. I ended up using an iff to substitute an incorrect date for null DOB in my query. Report then warns user that a null value is on of the two fields was discovered and...

Your solution seems to have worked. However it also seems like I was running into null fields returning #Error when making calculations in date fields. Found some workaround by putting far off unrealistic dates in the null field. Any suggestions for something more elegant? I'm able to run the...

I'm attempting to create a query to show an expiration date of an authorization for my employees. The authorization expiration is based upon their age at the time they were given the authorization, 5 years if under 40 at the time of authorization, 2 years if 40 or older. It is also valid until...