Recent content by KAT1162

I'll try it, thanks!

Thanks for your response. For instance, I use the query wizard to create a new crosstab query. The table I am using for the crosstab query contains many records including quantities and dates for each record. The wizard asks which interval I want to group the dates by and gives me these...

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...

Help with crosstab query - when I do a crosstab query, the sum options include quarters and months, but not weeks. How can I do a crosstab query and put my data into weekly buckets? Can I do this via the query wizard or do I need to know what the expression is and type it myself?

I'll try saving the .accdb in .mdb instead. In the meantime, I created a new database which was in .accdb. Then went into an original database created in .mdb and attempted to link a file from the .accdb database. The message I received was: "Attached fields are not supported in the MDB or...

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...

Thanks. Actually I have one more column in there for quantity. I used the MIN in the date field and FIRST in the quantity field (MIN didn't work), and it looks like it's working. Thanks for your help!

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...