Search results

How do I add weekly buckets to a crosstab query? The wizard only has monthly and quarterly. Does anyone know the correct expression for this? Thanks!

Hi....I've run several crosstab queries and usually total my data in monthly buckets. I would love to know how to total in weekly buckets as well but this is not an option in the crosstab query wizard. Is there a certain expression I can enter, or is there a way to add to the wizard? Thanks...

Hi, We recently switched to Access 2007, and all of our existing databases could be used with this version. However, I have just created a new database and found that I can not link files from the database created in the new version (.accdb) to databases that were created in the old version...

Hello, In the old version of Access I could easily export a report from print preview into a PDF file. I just got the new version (Access 2007) and I can't find a way to do this. Every export method it lets me do changes the format. I just need the PDF as it looks exactly as my report does...

Hello, I thought this would be easier, but the results I'm getting are inaccurate. I have a table that includes items and dates. There are multiple records per item. I want to show each item only once with the earliest corresponding date. I've sorted, used the TOP, DISTINCT, and FIRST...