Calculating percentages

[SDowse]

Hi,

I am new to Access, so bare with me.

I have 2 tables, both with date fields. One tables records visits to a website, by date, and the other records sign-ups by date. I have created a cross-tab query to count the visits by month and a second cross-tab query to count sign-ups by month. What I am now wanting to do is work out the percentage of sign-ups compared to visits to the website. Any idea how I can do this?

Thanks,
Me

 

[Joe4]

You will want to create a query that has a record for each month, and shows the visits and sign-ups for each month. You can then add a calculated field to calculate the percentage between those two numbers.

What exactly the SQL code for that query should look like depends on the structure of your data tables. If you need help with that, please provide the structure and a small data sample of the tables.